Before taking this test, please remember to complete the Microsoft Excel Unit!

Please answer the questions to the best of your abilities. When you have answered all of the questions, a box will pop-up with your score. You will be asked to show this score to your teacher, or print out the results.

1. When formatting currency values using the Cells dialog box, you can choose whether to display the dollar sign.

   1.   ?    true
   2.   ?    false

2. If your worksheet is very wide, you can sometimes fit it on one page by changing to

   1.   ?    portrait orientation
   2.   ?    landscape orientation
   3.   ?    expanded orientation
   4.   ?    wide orientation

3. The intersection of a single row and a single column is called a

   1.   ?    cell reference
   2.   ?    field
   3.   ?    frame
   4.   ?    cell

4. A spreadsheet is a grid of rows and columns containing only numbers.

   1.   ?    false
   2.   ?    true

5. Each Excel workbook has three worksheets in it by default.

   1.   ?    false
   2.   ?    true

6. You can delete more than one row or column at a time.

   1.   ?    true
   2.   ?    false

7. When data is too wide for a cell, Excel might display a series of number signs (###).

   1.   ?    true
   2.   ?    false

8. By default, Excel aligns numbers at the

   1.   ?    center of a cell
   2.   ?    right side of a cell
   3.   ?    top of a cell
   4.   ?    left side of a cell

9. The small square in the bottom right corner of the active cell is called the

   1.   ?    selection handle
   2.   ?    fill handle
   3.   ?    sizing handle
   4.   ?    active handle

10. A collection of related worksheets is called a

    1.   ?    notebook
    2.   ?    workbook
    3.   ?    book
    4.   ?    database

11. You can print one or all sheets from a workbook.

    1.   ?    false
    2.   ?    true

12. In the Excel worksheet, the mouse pointer displays as a(n)

    1.   ?    arrow
    2.   ?    pointing finger
    3.   ?    crosshair
    4.   ?    thick plus sign

13. If desired, you can add new worksheets in your current Excel file.

    1.   ?    true
    2.   ?    false

14. To remove both data and formats from a cell, use the

    1.   ?    Delete All command
    2.   ?    Delete command
    3.   ?    Clear command
    4.   ?    Remove command

15. A selected group of cells is called a

    1.   ?    group
    2.   ?    range
    3.   ?    frame
    4.   ?    set

16. Labels at the tops of columns make up the

    1.   ?    column row
    2.   ?    header row
    3.   ?    label row
    4.   ?    name row

17. To quickly fill down, click the destination cell and press

    1.   ?    Ctrl + down arrow
    2.   ?    Ctrl + D
    3.   ?    Page Down
    4.   ?    Ctrl + End

18. You can print an entire worksheet or only a range of cells.

    1.   ?    true
    2.   ?    false

19. In Excel, Undo and Redo actions are cleared whenever you save the worksheet.

    1.   ?    false
    2.   ?    true

20. You must delete rows or columns one at a time.

    1.   ?    false
    2.   ?    true