DA-2

Q1. A reference that refers to the same cell or range on multiple sheets is called a(n) __________ reference

A. 3-D

B. Clustered

C. Indexed

D. Pivotal

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

A. right

B. left

C. top

D. bottom

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

A. =C2+C3

B. =$C1+$C2

C. =D2+D3

D. =E1+E2

Q4. When you copy a formula that contains an absolute reference to a new location, the reference ____

A. is updated automatically

B. does not change

C. becomes bold

D. has a dotted outline in its cell

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

A. TRUE

B. FALSE

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

A. cell reference

B. column heading

C. name box

D. row heading

Q7. Which shortcut key is used in MS Excel to "Create names from the row or column labels for the selected cell"?

A. Alt + Ctrl + F4

B. Shift + F3

C. F4

D. Ctrl + Shift + F3

Q8. What is the value of the following MS-Excel function? =FLOOR(14, 4)

A. 10

B. 13

C. 14

D. 12

Q9. Files created with Lotus 1-2-3 have an extension

A. DOC

B. XLS

C. 123

D. WK1

Q10. In Excel two common wildcard characters that Excel recognizes are

A. * and ?

B. < and >

C. ^ and /

D. + and –