Microsoft Excel Exam

20 Questions | Total Attempts: 97

Settings
Please wait...
Microsoft Excel Quizzes & Trivia

Take an exam to see how well you know some Excel basics. Content in this quiz was excerpted from Training on Microsoft Excel.


Questions and Answers
  • 1. 
    How do you change column width to fit the contents?
    • A. 

      Single-click the boundary to the left of the column heading.

    • B. 

      Double-click the boundary to the right of the column heading.

    • C. 

      Press ALT and single-click anywhere in the column.

  • 2. 
    On an Excel sheet the active cell is indicated by ____.
    • A. 

      A dark wide border

    • B. 

      A dotted border

    • C. 

      A blinking border

    • D. 

      None of the above

  • 3. 
    A Formula and a function are the same thing.
    • A. 

      True

    • B. 

      False

  • 4. 
    In order to multiply items in Excel you would use:
    • A. 

      ^

    • B. 

      /

    • C. 

      *

    • D. 

      #

  • 5. 
    If cells: A1=90 A2=85 A3=80 A4=75 A5=75 What will be your formula if you are going to get the average?
  • 6. 
    If cells: A1=90 A2=85 A3=80 A4=75 A5=75 What will be your formula if you are going to get the total?
  • 7. 
    Place where data, text, or equations are entered into a cell.
    • A. 

      Name Box

    • B. 

      Formula Bar

    • C. 

      Column Headings

    • D. 

      Row Headings

  • 8. 
    To add a new row, click a cell in the row immediately above where you want the new row.
    • A. 

      True

    • B. 

      False

  • 9. 
    Which key do you press to group two or more nonadjacent columns/rows?
    • A. 

      CTRL

    • B. 

      SHIFT

    • C. 

      ALT

  • 10. 
    A cell is a 
    • A. 

      Grid made of columns and rows

    • B. 

      Horizontal space going across

    • C. 

      Vertical space that goes up and down

    • D. 

      Area where columns and rows intersect

  • 11. 
    Which key do you press to group two or more adjacent columns/ rows?
    • A. 

      CTRL

    • B. 

      SHIFT

    • C. 

      ALT

  • 12. 
    ###### means:
    • A. 

      You've entered a number wrong.

    • B. 

      You've misspelled something.

    • C. 

      The cell is not wide enough.

  • 13. 
    In order to divide items in Excel you would use:
    • A. 

      ^

    • B. 

      /

    • C. 

      *

    • D. 

      #

  • 14. 
    Contains the name of the application and the document name
    • A. 

      Title bar

    • B. 

      Menu bar

    • C. 

      Tool bar

    • D. 

      Name box

  • 15. 
    How are rows designated?
    • A. 

      Numbers

    • B. 

      Letters

    • C. 

      Stars

    • D. 

      Circles

  • 16. 
    A column is 
    • A. 

      Vertical and designated by a number

    • B. 

      Horizontal and designated by a number

    • C. 

      Vertical and designated by a letter

    • D. 

      Horizontal and designated by a letter

  • 17. 
    A formula in the spreadsheet should always start with a/an
    • A. 

      Asterisk

    • B. 

      Equal sign

    • C. 

      Bracket

    • D. 

      Capital letter

  • 18. 
    Which of the following is a spreadsheet application?
    • A. 

      Microsoft Word

    • B. 

      Microsoft Excel

    • C. 

      Microsoft PowerPoint

    • D. 

      Microsoft Access

  • 19. 
    What is the name of this cell?
    • A. 

      A7

    • B. 

      B7

    • C. 

      B6

    • D. 

      A6