MS Spreadsheets & Databases

14 Questions | By Masterson | Last updated: Mar 16, 2016 | Total Attempts: 1205

Questions

Settings

For my students only please

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