Test Your Spreadsheets Knowledge! Trivia Quiz

12 Questions | Total Attempts: 1901

SettingsSettingsSettings
Test Your Spreadsheets Knowledge! Trivia Quiz - Quiz

Spreadsheets are a file made of rows and columns that help sort data, arrange data easily, and calculate numerical data. Spreadsheets have been used by people to prepare budgets, charts, graphs and for storing data. The quiz below is designed to test out how much you understand about preparing and understanding spreadsheets. Take up the 6th-grade 3rd rotation quiz below and see how good you do.


Questions and Answers
  • 1. 
    What software application is the most effective tool to create charts of data?
    • A. 

      Word Processing software

    • B. 

      Spreadsheet software

    • C. 

      Photo editing software

    • D. 

      Desktop Publishing software

  • 2. 
    Which of the following activities would spreadsheet software typically be used for?
    • A. 

      Create brochures and flyers

    • B. 

      Develop storyboards for presentations

    • C. 

      Manage large numbers of records

    • D. 

      Organize and analyze financial data

  • 3. 
    Which spreadsheet feature would you use to identify the different sections of a pie chart?
    • A. 

      Legend

    • B. 

      Axis

    • C. 

      Category

    • D. 

      Series

  • 4. 
    Putting names into a spreadsheet and then alphabetizing them is called putting them into ____________ order.
    • A. 

      Name

    • B. 

      Ascending

    • C. 

      Descending

    • D. 

      Logical

  • 5. 
    Which of the following are spreadsheets commonly used for?
    • A. 

      Writing and editing technical manuals and documents

    • B. 

      Making data more readable and understandable using charts/graphs

    • C. 

      Conducting searches of extensive collections of records

    • D. 

      Formatting and displaying documents combining text, graphics, and video

  • 6. 
    To create a personal budget, which is the MOST effective application to be used?
    • A. 

      Desktop Publishing software

    • B. 

      Spreadsheet software

    • C. 

      Presentation software

    • D. 

      Database software

  • 7. 
    Charlie wants to be an accountant.  He knows that accountants frequently use spreadsheets. Which of the following would it be most helpful for Charlie to learn about?
    • A. 

      Formulas and functions

    • B. 

      Hyperlinks and hypertext

    • C. 

      Fields and records

    • D. 

      Web and file servers

  • 8. 
    You've been assigned a project to collect and analyze data.  What is the most effective type of application to enter data, build a graph and/or create a chart?
    • A. 

      E-mail

    • B. 

      Spreadsheet

    • C. 

      Blog

    • D. 

      Desktop Publishing

  • 9. 
    Which is the active cell in the spreadsheet above?
    • A. 

      B2

    • B. 

      2B

    • C. 

      C1

    • D. 

      1C

  • 10. 
    What part of the graph is the arrow pointing to?
    • A. 

      The axis

    • B. 

      The header

    • C. 

      The category

    • D. 

      The legend

  • 11. 
    How has the data in this spreadsheet been sorted?
    • A. 

      In alphabetical order

    • B. 

      In ascending order

    • C. 

      In descending order

    • D. 

      It has not been sorted

  • 12. 
    Which of the lines represents the girls?
    • A. 

      Red

    • B. 

      Blue

    • C. 

      Green

    • D. 

      Yellow

Back to Top Back to top