Groups & Formulas:

Title: Jan's Illustrated Computer Literacy 101
Did you want Working with Numbers: 2007,2010,2013,2016  or españolIcon: Change web

For each question, click on Radio Button 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.

Choose the BEST answer.

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 not sort rows or cells based on _____

   a. up to three different columns

   b. numerical order

   c. using a custom list for the first level of sort

  d. using a custom list any sort level but only on one at a time

3. The range C4:F10 contains a table. Column F contains 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 in place 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 popup tip

   b. the upper left selected cell

   c. the Status bar

  d. the Formula bar

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

   a. menu command Insert | AutoShape

   b. AutoShapes button on the Drawing bar

  c. AutoShapes button on the Formatting bar

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.  Sheet 3 has cells that are linked to the originals  in Sheet 1. Which of the following changes to Sheet 1 WILL be updated in sheet 3.

   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.  use the menu command Data | Subtotals... which will sort on the columns you choose and create subtotals.

  b.  use the menu command Data | Sort... to group together the rows you want to subtotal.

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

  d. create a grand total yourself