5. The
AutoSum and AutoSum: Average commands suggest a range of cells that may
or may not be what you want.

a. True

b. False

Tip: Beginning Excel, page 91

6. Which of the following commands are in the AutoSum menu?

(Select all
correct answers.)

a. Sum

b. Average

c. Count Number

d. Max

e. Min

Tip: Beginning Excel, page 92

7. Which of the following is true?

(Select all
correct answers.)

a. COUNTA counts all cells with text or numbers

b. COUNT counts all cells with numbers

c. Neither COUNT or COUNTA counts empty cells

Tip: Beginning Excel, page 95

8. A logic
function asks a question, then determines if your data matches.

a. True

b. False

Tip: Beginning Excel, page 97

9. Which is a logic function?

a. COUNTA

b. Average

c. IF

d. Sum

Tip: Beginning Excel, page 98

10. Which of the following is a way to enter a formula?

(Select all
correct answers.)

a. Type the formula

b. Insert the formula using the Formula Ribbon

c. Copy and paste the formula

Tip: Beginning Excel, page 84, 89