Excel exam

Which of the following is a correctly named cell?

• 8B

• B8

• 8-B

• BB-8

A-------------------- is where a row and column meet

• sheet

• formula

• blank

• cell

Which symbol tells the computer you want to create an formula?

• $

• +

• -

• =

Select----------------- from the functions drop-down menu to add a set of numbers.

• average

• sum

• count

• max

What is the cell in the worksheet in which you can type data?

• Active cell

• Main cell

• Open cell

• Absolute cell

Rows are labeled by-------------------------.

• numbers

• letters

• symbols

• colors

The contents in cell A1 through A5 are 6,3,4,7,9 .What function would return the answer 9?

• =MAX(A1:A5)

• =AVG(A1:A5)

• =SUM(A1:A5)

• MIN(A1:A5)

To make borders around data that you entered using :

• 
• 
• 
• 

A command line above the worksheet where text ,numbers, and formula are entered into a worksheet.

• Insert

• Formula bar

• Tables

Multiplication symbol in Microsoft Excel

• $

• *

• x

• &