Microsoft Excel - Formatting

The cell address of the highlighted cell is

• C

• A4

• C4

How do you change column width to fit the contents?

• Single-click the boundary to the left of the column heading
• Double-click the boundary to the right of the column heading
• Press ALT and single-click anywhere in the column

A pie graph is a visual representation of what?

• Values change over time.

• comparison of a piece of data to the whole group

• a categorical data with rectangular bars with heights or lengths proportional to the values that they represent.

You accidentally erased a record in the sheet. What command can be used to restore it immediately?

• A. Insert

• B. Copy

• C. Undo

• D. Replace

What is this icon?

• Zoom

• Sort and Filter

• Symbol

• Merge and Center

By default the text data is________ aligned in cell.

• Left

• Center

• Right

• Bottom

By default the number data is __________ aligned in cell.

• Right

• Center

• Top

• Left

Excel allows you to work with?

• Sentences

• Paragraphs

• data

Which tab in Excel has charts and tables?

• review
• home
• file
• insert

What type of chart will you use to compare performance of sales of two products ?

• Column/ Bar Chart

• Line Chart

• Pie Chart