Quiz: Formulas | Jan's Working with Numbers

For each question, click on

the radio button for your answer. You will be notified immediately whether your choice is correct or not. Double clicking may work better in some browsers.

1. Your sheet has an image that covers cells A1, A2, B1, and B2. You select cell A1, cut it and paste to cell F1. The image ____.

a. does not appear at F1

b. is pasted also to F1

c. is pasted but is sized to fit inside cell F1

d. is deleted from A1 but not pasted to F1

2. In the Sort dialog you can sort rows or cells based on all of the choices below except _____

a. three different columns at once

b. numerical order

c. using a custom list

d. two criteria on the same column

3. The range C4:F10 contains a table. Column F contains AutoSum formulas that add the values in the row. You move the range C4:D10 left two columns, but leave the cells in column F in place. The formulas in column F _____.

a. still refer to the original cells

b. are automatically changed to use the cell references for the new location of the table cells

c. are replaced with the error value #REF!

d. are replaced with the error value #VALUE!

4. Sheet2 is a copy of Sheet1. You change some of the values on Sheet1. The values on Sheet2 _____.

a. do not change to match

b. change to match the new values on Sheet1

c. are replaced with error value #REF!

d. are replaced with the error value #VALUE!

5. A formula in cell E6 refers to cell A6. Cells A4, A5, and A6 are then merged. The formula in cell E6 will now _____.

a. use the value in the merged cell A4

b. use the original value in A6.

c. use a zero for the value of A6

d. show the error value #REF!

6. You select several cells which contain numbers. AutoCalculate shows the value that it calculates with these numbers in _____.

a. a screen tip

b. the upper left selected cell

c. the Status bar

d. the Formula bar

7. To insert an AutoShape, you could use the _____ .

a. ribbon tab Insert, the Shapes button

b. ribbon tab Design, the Shapes gallery

c. right click menu, the Shapes button on the Mini-Toolbar

8. You have a table that uses rows 3 , 4, and 5 for data, leaves row 6 blank, and has formulas in row 7 that add up the cells in the column above. The formulas include the blank row 6. Which rows can you select to insert a new row and the new cells WILL be included in the formulas?

a. 3, 4, 5, 6, or 7

b. 4, 5, 6, or 7

c. 3, 4, 5, or 6

d. 4 and 5 only

9. Sheet3 has cells that are linked to the originals in Sheet1. Which of the following changes to Sheet1 WILL be updated in Sheet3:

a. reformatting text in a linked cell

b. correcting spelling in a linked text cell

c. inserting a row in the middle of a table of linked cells

d. inserting a row at the bottom edge of a table of linked cells

10. You want to create subtotals for a table. You should first _____.

a. on the ribbon tab Data, click on Subtotals... which will sort on the columns you choose and create subtotals.

b. sort your data

c. create blank lines where you want the subtotals to appear

d. create a grand total yourself

Jan's Working with Numbers

Formulas: Quiz