MS Spreadsheets & Databases

14 Questions

Settings
Please wait...
MS Spreadsheets & Databases

For my students only please


Related Topics
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 spreadsheet feature would you use to identify the different sections of a pie chart?
    • A. 

      Legend

    • B. 

      Axis

    • C. 

      Category

    • D. 

      Series

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

      Desktop Publishing software

    • B. 

      Presentation software

    • C. 

      Spreadsheet software

    • D. 

      Database software

  • 4. 
    A project at school requires you to place names, addresses, birth dates, and phone numbers into a program. This information will be sorted, queried, placed into mailing labels and forms. What is the best type of program to use to place this information?
    • A. 

      Word processor

    • B. 

      Spreadsheet

    • C. 

      Database

    • D. 

      Web page

  • 5. 
    You create a database report of your CD collection. You want to sort it to locate all the songs by a particular artist. You will need to:
    • A. 

      Sort by field name

    • B. 

      Sort by the record

    • C. 

      Sort by a cell

    • D. 

      Sort by a row

  • 6. 
    After setting up records in a database, which of the following functions can be performed?
    • A. 

      Create a form

    • B. 

      Create a graph

    • C. 

      Create a multi-media presentation

    • D. 

      Create a web page

  • 7. 
    Online career resources such as those found in the Michigan Electronic Library's (Mel.org) Learning Express Library, can help students:
    • A. 

      Locate colleges by educational programs

    • B. 

      Identify a career path

    • C. 

      Analyze skills and abilities

    • D. 

      All of the choices

  • 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. 
    You create a database to enter data collected from a school survey. Information you enter for each individual questionnaire is called a:
    • A. 

      Table

    • B. 

      Record

    • C. 

      Query

    • D. 

      Field

  • 10. 
    Mary enters the names and phone numbers of all the people in her cooking club into a table. What is the one thing she can NOW do with that information?
    • A. 

      Generate accounts and passwords for each of the people

    • B. 

      Automatically confirm the spelling of all the names

    • C. 

      Sort the rows into ascending or descending order

    • D. 

      Include a button bar with each of the member's names

  • 11. 
    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

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

      Writing and editing technical manuals and documentation

    • 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

  • 13. 
    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

  • 14. 
    In spreadsheets, a cell reference is also referred to as which of the following?
    • A. 

      Entry bar

    • B. 

      Active cell

    • C. 

      Axis

    • D. 

      Cell address