Excel Basics - Review Test

The correct reference for the cell slected would be:

• 9C

• C9

The function used to calculate average in Excel is:

• =ARG()

• =AVG()

• =AVERAGE()

• =AVGE()

In order to type extra long text in cells so that all are visible, we use

• Merge and Center

• Find & Select

• Wrap Text

• Conditional Formatting

In order to print the selection only we should select

• 
• 
• 

The correct reference for the selected cell range would be:

• A5:C11

• A5:A11

• A5:C5

• C5:C11

The feature used in the diagram is called

• Merge and Center

• Fill Handle

• Copy and Paste

To format the table with borders as shown, we should select:

• 
• 
•