Microsoft Excel Assessment Test Quiz!

19 Questions | Total Attempts: 1922

SettingsSettingsSettings
Please wait...
Microsoft Excel Assessment Test Quiz!

Microsoft Excel is a spreadsheet program developed by Microsoft; it has calculation, graphing tools and pivot tables, and a Visual Basic for Applications macro programming language. It is a reliable, multi-purpose software downloadable tool. If you want to learn more about Microsoft Excel, look no further than this quiz.


Questions and Answers
  • 1. 
    What is an Excel Workbook?
    • A. 

      A table of data that holds information.

    • B. 

      A Microsoft Office Application file that contains worksheets.

    • C. 

      A file where you can enter practice data.

  • 2. 
    A range in Excel refers to:
    • A. 

      A group of tabs.

    • B. 

      A group of cells.

    • C. 

      A way of arranging a series of data.

  • 3. 
    Double-clicking between two column headings will auto-size the column to the widest width.
    • A. 

      True

    • B. 

      False

  • 4. 
    You can insert a row or column by right-clicking on the row number or column letter and selecting Insert.
    • A. 

      True

    • B. 

      False

  • 5. 
    You can select multiple non-adjacent cells by holding the __________________ button and selecting the cells.
    • A. 

      Alt

    • B. 

      Shift

    • C. 

      Ctrl

    • D. 

      Enter

  • 6. 
    How can you open a spreadsheet?
    • A. 

      Click File then Open

    • B. 

      Click Ctrl + O

    • C. 

      Click the Open Folder Icon on the Standard Toolbar

    • D. 

      All of the above

  • 7. 
    All formulas in Excel begin with:
    • A. 

      A plus (+) sign

    • B. 

      Parenthesis ( )

    • C. 

      A minus (-) sign

    • D. 

      An equal sign (=)

    • E. 

      None of the above

  • 8. 
    The Auto-Fill Handle can be used to:
    • A. 

      Copy formulas.

    • B. 

      Copy text.

    • C. 

      Fill in a series of numbers or dates.

    • D. 

      None of the Above

    • E. 

      All of the Above

  • 9. 
    Please select the correct answer to the following question. The name box can be used to:
    • A. 

      Navigate to a specific cell with in the workbook

    • B. 

      Indicate to the user the active cell

    • C. 

      Navigate to a specific cell within the worksheet

    • D. 

      Name a cell or range of cells

    • E. 

      All of the Above

  • 10. 
    Which function is used to add up a range of cells?
    • A. 

      Add

    • B. 

      Sum

    • C. 

      Plus

  • 11. 
    The following icon is used to change the font color of text.
    • A. 

      True

    • B. 

      False

  • 12. 
    A cell address is identified using a row and column label.
    • A. 

      True

    • B. 

      False

  • 13. 
    The following icon is used to paste data into a spreadsheet. 
    • A. 

      True

    • B. 

      False

  • 14. 
    The shift button in conjunction with the mouse can be used to select a range of non-adjacent cells.
    • A. 

      True

    • B. 

      False

  • 15. 
    You can attach a file to an e-mail by opening Lotus Notes, creating a new mail message, clicking the open folder, browse to find the file to attach, click the open button.
    • A. 

      True

    • B. 

      False

  • 16. 
    How can you save a new or existing workbook?
    • A. 

      Ctrl+S

    • B. 

      File Save

    • C. 

      File Save As

    • D. 

      F12

    • E. 

      All of the above

  • 17. 
    You must always edit cell data from the formula bar.
    • A. 

      True

    • B. 

      False

  • 18. 
    You can use the left and right arrows or the tab and shift+tab buttons to navigate left or right in the spreadsheet.
    • A. 

      True

    • B. 

      False

  • 19. 
    The is used to sort text data from A to Z and Numbers from the highest to the lowest.
    • A. 

      True

    • B. 

      False

Back to Top Back to top