Microsoft Excel Exam Trivia: Quiz!

10 Questions | Total Attempts: 23387

SettingsSettingsSettings
Please wait...
Microsoft Excel Exam Trivia: Quiz!

What do you know about Microsoft Excel, and do you think you can pass this quiz? Microsoft Excel is said to provide the most efficient spreadsheet for organization and basic applications. It features calculation tools, graphing items, and other essential variables. It came out in 1987, so there have been several incarnations since the original. If you want to learn more about Microsoft Excel and see how this spreadsheet can help you, try this quiz.


Questions and Answers
  • 1. 
    B7:B9 indicates:
    • A. 

      Cells B7 and cell B9 only

    • B. 

      Cells B7 through B9

    • C. 

      Cell B8 only

    • D. 

      None of the above

  • 2. 
    The Cancel and Enter buttons appear in the:
    • A. 

      Title bar

    • B. 

      Formula bar

    • C. 

      Menu bar

    • D. 

      Sheet tabs

  • 3. 
    MS-EXCEL can be used to automate:
    • A. 

      Financial statements, Business forecasting

    • B. 

      Transaction registers, inventory control

    • C. 

      Accounts receivable, accounts payable

    • D. 

      Any of the above

  • 4. 
    NOT, AND, OR and XOR are:
    • A. 

      Logical Operators

    • B. 

      Arithmetic operators

    • C. 

      Relational operators

    • D. 

      None of the above

  • 5. 
    In a report, you need to show the monthly rainfall in Nepal. The best way to do this is to insert a
    • A. 

      Calendar

    • B. 

      Photograph of rainfall

    • C. 

      Chart showing rainfall amounts

    • D. 

      Database of rainfall

  • 6. 
    You want to record experiment information and create a chart that shows the rate of crystal growth over a period of time. The best application to use would be:
    • A. 

      Word processing

    • B. 

      Spreadsheet

    • C. 

      Database

    • D. 

      Graphics

  • 7. 
    You are editing a worksheet that you had previously saved. If you want to save the edited sheet without losing the original one, which command should you use?
    • A. 

      New

    • B. 

      Save As

    • C. 

      Edit

    • D. 

      Save

  • 8. 
    If you want to have a blank line after the title in a worksheet, what is the best thing for you to do?
    • A. 

      Re-format the spreadsheet

    • B. 

      Insert a row

    • C. 

      Increase the column width

    • D. 

      Use the spacebar

  • 9. 
    In order to arrange the countries from those with the highest population to those with the lowest, you need to sort on the population field in ……………
    • A. 

      Ascending order

    • B. 

      Descending order

    • C. 

      Alphabetical order

    • D. 

      Random order

  • 10. 
    In order to perform a calculation in a spreadsheet, you need to use a:
    • A. 

      Table

    • B. 

      Formula

    • C. 

      Field

    • D. 

      Variable

Back to Top Back to top