Could You Pass This Basic MS Excel Test? Trivia Quiz

15 Questions

Settings
Please wait...
Could You Pass This Basic MS Excel Test? Trivia Quiz

Simple excel test to judge the basic level of understanding use


Questions and Answers
  • 1. 
    On an Excel sheet the active cell is indicated by:
    • A. 

      A dark border

    • B. 

      A dotted border

    • C. 

      A blinking border

    • D. 

      None of the above

  • 2. 
    To select a column the easiest method is to:
    • A. 

      Double-click any cell in the column

    • B. 

      Drag from the top cell in the column to the last cell in the column

    • C. 

      Click the column heading

    • D. 

      Click the column label

  • 3. 
    If you press _____, the cell accepts your typing as its contents but the focus stays in the cell.
    • A. 

      ENTER

    • B. 

      CTRL+ENTER

    • C. 

      TAB

    • D. 

      INSERT

  • 4. 
    The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is _____.
    • A. 

      B1-G10

    • B. 

      B1.G10

    • C. 

      B1;G10

    • D. 

      B1:G10

  • 5. 
    The view that puts a blue line around each page that would be printed is the
    • A. 

      Print Preview

    • B. 

      Normal

    • C. 

      Page Break Preview

    • D. 

      Split View

  • 6. 
    To select several cells or ranges that are not touching each other, you would _____ while selecting
    • A. 

      Hold down the CTRL key

    • B. 

      Hold down the SHIFT key

    • C. 

      Hold down the ALT key

    • D. 

      Hold down CTRL+SHIFT

  • 7. 
    • A. 

      Nothing will print because some cells with data have been omitted

    • B. 

      Only the cells with gray background will print

    • C. 

      The whole sheet will print

    • D. 

      Only the cells with white background will print

  • 8. 
    To arrange rows in alphabetical order based on column A, you need to use the command
    • A. 

      Tools I Sort

    • B. 

      Data I Sort

    • C. 

      Edit I Data I Sort

    • D. 

      None of the above

  • 9. 
    To edit existing data in a cell without having to retype it all, you should
    • A. 

      Double-click the cell

    • B. 

      Click the formula button

    • C. 

      A & B

    • D. 

      None of the above

  • 10. 
    If you select a cell with a date in it and drag the fill handle down across several cells, what happens is th
    • A. 

      The date is copied to each cell

    • B. 

      The date is increased by 1 day into each cell

    • C. 

      The date is increased by 1 week into each cell

    • D. 

      Nothing as Auto Fill applies only to numbers

  • 11. 
    To print just part of a sheet, you would select what you want to print and
    • A. 

      Click the Print button

    • B. 

      Press the PRINT SCREEN key

    • C. 

      Select Print selection on Page Setup | Sheet and then print

    • D. 

      Select Print selection in the Print dialog and then print

  • 12. 
    To remove the contents of several cells at once, you can
    • A. 

      Select the cells and press DELETE

    • B. 

      Select the cells and choose Edit | Clear... | Contents

    • C. 

      Select the cells and drag the fill handle back up over them

    • D. 

      All of the above

  • 13. 
    The default orientation for the printed page is
    • A. 

      Portrait

    • B. 

      Landscape

    • C. 

      Whatever was last used

    • D. 

      Vertical

  • 14. 
    Cell A4 =2 and A5 = 4. You select both cells and drag the fill handle down to A8. The contents of cells A6, A7, and A8 are
    • A. 

      8,16,32

    • B. 

      2,4,2

    • C. 

      2,2,2

    • D. 

      6,8,10

  • 15. 
    • A. 

      Your formula has a syntax error

    • B. 

      The row is too short to show the number at the current font size

    • C. 

      The column is too narrow to show all the digits of the number

    • D. 

      None of the above