Simple Excel Test

15 Questions | Total Attempts: 367

Settings
Please wait...
Microsoft Excel Quizzes & Trivia

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 certain spreadsheet shows in Page Break Preview that cells in Rows 1 - 25 have white background. The cells in Row 26 that contain data have a dark gray background. When you click the Print button:
    • 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