MS Spreadsheets & Databases
Settings
For my students only please
- 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
Back to top