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. As you enter data in a cell in an Excel worksheet, it appears not only in the cell but in the

   1.   ?    Status Bar
   2.   ?    Text Bar
   3.   ?    Formula Bar
   4.   ?    Navigation Bar

2. A selected group of cells is called a

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

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

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

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

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

5. A quick way to copy identical values to a series of adjacent cells is to use the

   1.   ?    Fill command
   2.   ?    AutoComplete command
   3.   ?    AutoInsert command
   4.   ?    Insert command

6. A collection of related worksheets is called a

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

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

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

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

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

9. By default, Excel aligns numbers at the

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

10. To create a title that spans several columns or rows, the button to use is

    1.   ?    Span and Center
    2.   ?    Merge and Span
    3.   ?    Merge and Center
    4.   ?    Merge Cells

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

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

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

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

13. The command sequence you use to hide columns is

    1.   ?    Format, Hide Column
    2.   ?    View, Column, Hide
    3.   ?    Format, Column, Hide
    4.   ?    View, Hide Column

14. If you clicked in cell B2 and issued the Freeze Panes command, what would be frozen?

    1.   ?    all columns after B and all rows below 1
    2.   ?    row 1 and column A
    3.   ?    row 2 and column B
    4.   ?    none of the above

15. Labels at the tops of columns make up the

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

16. You will find the Sort command on the

    1.   ?    Edit menu
    2.   ?    Format menu
    3.   ?    Data menu
    4.   ?    Tools menu

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

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

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

    1.   ?    true
    2.   ?    false

19. A cell reference consists of the column letter and row number.

    1.   ?    true
    2.   ?    false

20. By default, Excel aligns text at the right of the cell.

    1.   ?    true
    2.   ?    false

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

    1.   ?    true
    2.   ?    false

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

    1.   ?    true
    2.   ?    false

23. Hiding a column removes it from view temporarily.

    1.   ?    true
    2.   ?    false

24. You must accept Excel's determination of where to break pages when printing.

    1.   ?    true
    2.   ?    false

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

    1.   ?    true
    2.   ?    false

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

    1.   ?    true
    2.   ?    false

27. A worksheet is the same as a spreadsheet.

    1.   ?    true
    2.   ?    false

28. Rows in a worksheet are identified by numbers.

    1.   ?    true
    2.   ?    false

29. To remove cell data, you can simply press the Delete key.

    1.   ?    true
    2.   ?    false

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

    1.   ?    true
    2.   ?    false

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

    1.   ?    true
    2.   ?    false

32. If you Undo an action from the Undo list, Excel will also undo all actions listed above it on the list.

    1.   ?    true
    2.   ?    false

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

    1.   ?    true
    2.   ?    false

34. When you copy or move data, formats applied to those cells are also copied or moved.

    1.   ?    true
    2.   ?    false

35. To quickly fill to the right, click in the destination cell and press Ctrl + R.

    1.   ?    true
    2.   ?    false

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

    1.   ?    true
    2.   ?    false

37. After you hide columns, you must close and reopen the worksheet to unhide the columns.

    1.   ?    true
    2.   ?    false

38. If you sort a last name column in ascending order, Adams would come first and Williams last.

    1.   ?    true
    2.   ?    false

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

    1.   ?    true
    2.   ?    false