excel review

Which of these is Microsoft Excel?

• 
• 
• 
• 

Which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?

• Count

• Average

• Sum

A simple formula always start with :

• +

• =

• -

• *

/ is a symbol for:

• Multiplication

• Addition

• Subtraction

• Dividing

What is the reference of the active cell?

• g15

• H19

• B21

• V11

• a17

What would be a correct formula for SUM in excel?

• =SUM(B3:B9)
• =SUMB3+B9
• SUM(B3:B9)
• =ADD(B3:B9)

Blank are vertical

• Columns
• Rows

What is action of Tab key in Excel?

• One cell down in the column

• Next cell in the row

• Previous cell in the row

• One cell up in the column

16. In Excel columns are labeled by letters.

• True

• False

14. What is the Formula sign for multiply?

• +

• \

• *

• :