Quiz: Microsoft Excel MCQ Exam!

30 Questions | Total Attempts: 73

SettingsSettingsSettings
Please wait...
Microsoft Excel Quizzes & Trivia

Questions and Answers
  • 1. 
    Microsoft Excel is a?
    • A. 

      Program

    • B. 

      File

    • C. 

      Document

  • 2. 
    Microsoft excel consists of________________
    • A. 

      Blank documents

    • B. 

      Slides

    • C. 

      Books

  • 3. 
    Each little box is excel is called a?
    • A. 

      Block

    • B. 

      Table

    • C. 

      Cell

  • 4. 
    In Excel which direction is a row?
    • A. 

      Horizontal

    • B. 

      Vertical

    • C. 

      Diagonol

  • 5. 
    In Excel, which direction is a column?
    • A. 

      Horizontal

    • B. 

      Vertical

    • C. 

      Diagonal

  • 6. 
    What will the FILL COLOR button do in Excel?
    • A. 

      Color the cells

    • B. 

      Color the alphabets and symbols

    • C. 

      Color the numbers

  • 7. 
    The AutoSum will?
    • A. 

      Add any cell location

    • B. 

      Add or subtract any cell location

    • C. 

      Add any row or column

  • 8. 
    the Data Sort button will?
    • A. 

      Sort numerical data only

    • B. 

      Sort alphabetically only

    • C. 

      Sort any row or column data

  • 9. 
    Which statement is true about centering in Excel?
    • A. 

      You can only center a cell at a time

    • B. 

      You can not click the center button before typing

    • C. 

      You can center any range of cells all at one time

  • 10. 
    The currency key looks like?
    • A. 

      A picture of a dollar bill

    • B. 

      The sigma symbol

    • C. 

      The dollar sign

  • 11. 
    The currency key will make the number 4469 look like what?
    • A. 

      $4,469

    • B. 

      4469.00

    • C. 

      $4,469.00

  • 12. 
    What will Auto copy do to the word Monday?
    • A. 

      Copy the word Monday to a selected row or column

    • B. 

      Copy the rest of the week to selected row or column

    • C. 

      Copy the word Monday to the next cell only

  • 13. 
    In order to have the gridlines of  Excel show up when you print, you would need to choose?
    • A. 

      Borders

    • B. 

      Columns

    • C. 

      Format

  • 14. 
    Which is not a true statement?
    • A. 

      Columns and rows are adjustable

    • B. 

      Only rows can expand

    • C. 

      You can expand a row to your desired setting

  • 15. 
    You can practically do any kind of math in Excel by using?
    • A. 

      The sigma symbol

    • B. 

      Functions

    • C. 

      Format painter

  • 16. 
    Which of the following can NOT be deleted?
    • A. 

      An entire row or column

    • B. 

      The font choices

    • C. 

      The contents within the cells

  • 17. 
    Which statement is true?
    • A. 

      You can have several worksheets within one book

    • B. 

      You are only allowed 3 worksheets within a book

    • C. 

      There is no such thing as having worksheets within a book

  • 18. 
    How do you name your worksheet tabs?
    • A. 

      Highlight the tab and type in the name

    • B. 

      Click on the tab and go to save as

    • C. 

      Right click on the tab and go to rename

  • 19. 
    Under which ribbon tab is are the charts located?
    • A. 

      Home

    • B. 

      Insert

    • C. 

      View

  • 20. 
    What will the "merge and center" button do?
    • A. 

      Merge a range of cells into the center of another worksheet

    • B. 

      Merge all of the worksheets together in the center of the screen

    • C. 

      Merge a range of cells together into one cell and center the contents

  • 21. 
    What would be the first step in changing a decimal into a fraction in Excel?
    • A. 

      Click on the NUMBER button under the HOME tab In the ribbon

    • B. 

      Click on the PERCENT button in the ribbon

    • C. 

      Click on the INCREASE DECIMAL button in the ribbon

  • 22. 
    Which tab would you go to in order to set your margins in Excel?
    • A. 

      Page layout

    • B. 

      Home

    • C. 

      Data

  • 23. 
    Which command reverses the last action taken?
    • A. 

      Redo

    • B. 

      Reverse

    • C. 

      Undo

  • 24. 
    Which command allows you to reverse an undo command?
    • A. 

      Redo

    • B. 

      Reverse

    • C. 

      Undo

  • 25. 
    Which cell alignment is assigned to most values by default?
    • A. 

      Left

    • B. 

      General

    • C. 

      Center