Excel 2007 Layout

10 Questions | Total Attempts: 217

SettingsSettingsSettings
Please wait...
Microsoft Excel Quizzes & Trivia

Short Test to check your knowledge


Questions and Answers
  • 1. 
    A  worksheet is..
    • A. 

      A symbol that represents a specific action

    • B. 

      Refers to the change a formula makes when it is moved or copied to other cells with different data

    • C. 

      A table of data that is organized into rows and columns

    • D. 

      No ne of the above

  • 2. 
    Pressing ENTER moves the selection one cell to the right.
    • A. 

      True

    • B. 

      False

  • 3. 
    The Name Box shows you the contents of the active cell.
    • A. 

      True

    • B. 

      False

  • 4. 
    On an Excel spreadsheet the active cell is indicated by
    • A. 

      A dark wide border

    • B. 

      A dotted border

    • C. 

      A blinking border

    • D. 

      None of the above

  • 5. 
    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

  • 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. 
    Once data is entered into a cell, can it be edited?
    • A. 

      Yes, but it has to be saved as a different file name.

    • B. 

      No, once it is saved it cannot be changed.

    • C. 

      Yes, even after saving the file, double click on the cell where data is to be changed to edit

    • D. 

      A and C

  • 8. 
    What do you type into an empty cell to start a formula?
    • A. 

      *

    • B. 

      (

    • C. 

      =

    • D. 

      $

  • 9. 
    Ctrl+B key makes the shortcut for making font in selected cell bold.
    • A. 

      True

    • B. 

      False

  • 10. 
    Which is the part of the Excel screen where you can find all the commands or buttons, depending on the tab you selected before?
    • A. 

      Ribbon

    • B. 

      Formula Bar

    • C. 

      Tab

    • D. 

      Name Box

    • E. 

      Sheet Tab