BG-4

Q1. The AutoAdd function adds up numbers in a column or row you specify.

A. True

B. False

Q2. "AAA" is an example of a ____ in Excel.

A. cell reference

B. column heading

C. name box

D. row heading

Q3. _______ quickly highlight(s) important information in a spreadsheet that match your criteria by applying formatting options, data bars, color scales, or icon sets.

A. cell references

B. conditional formatting

C. Excel tables

D. pivot tables

Q4. When you use the scroll bars, the active cell does not change. True or false?

A. True

B. False

Q5. As a general rule, Excel will _____-align numbers.

A. right

B. left

C. top

D. bottom

Q6. Cell D4 contains the formula =C1+C2. What formula will see when you paste this into cell E5?

A. =C1+C2

B. =$C1+$C2

C. =D2+D3

D. =E6+E7

Q7. Which of the following is a logical function?

A. AVERAGE

B. IF

C. SUMPRODUCT

D. VLOOKUP

Q8. Which of the following is not a term pertaining to spreadsheets?

A. Cell

B. Character

C. Browser

D. Formula

Q9. Which term is used to join the selected cells in to one cell?

A. Filter

B. Wrap

C. Pivot

D. Merge

Q10. A formula in Excel always begins with an ____

A. Equal sign

B. Colon

C. Comma

D. Space