Excel Lessons 4-6 Test

Which command on the Home Tab displays the total of the selected cells directly after the selected cells?

• AutoSum

• Add

• Total

• Calculate

Which of the following is not an arithmetic operator?

• +
• -
• *
• ]

Which of the following is an example of an absolute cell reference?

• A9
• A$9
• $A$9
• A9:E9

True or False? To allow Excel to distinguish formulas from data, all formulas begin with an equal sign (=).

• True

• False

There are 2 types of cell reference, absolute and relative. Select the relative cell reference.

• A

• A7

• 7

• $A$7

Which symbol makes a cell reference absolute?

• @

• &

• #

• $

A function that returns the largest values in a set of values

• MAX function
• AVERAGE function
• MIN function
• SUM function

Write a FORMULA or FUNCTION for the following:

Add cells A1 and B1

• A1 + B1

• =A1 + B1

• =SUM(A1+B1)

• SUM(A1+B1)

Write a FORMULA or FUNCTION for the following:

Find the average of the range of cells C1 through C20

• AVERAGE(C1:C20)

• =AVG C1:C15

• =AVERAGE C1:C15

• =AVERAGE(C1:C20)

Formulas can be copied to adjacent cells with the ____________.

• Fill handle

• PgDn Key

• Function key F4

• None of the above