Excel / Access Quiz

If you see a series of "######" in a cell, that means the following:

• You keyed in an incorrect number
• The row height is too high
• The text is incorrectly spelled
• The column width is not wide enough

Microsoft Excel is what type of software?

• Word Processing
• Spreadsheet
• Presentation
• Drawing

What would be a correct formula for SUM in excel?

• =SUM(B3:B9)
• =SUMB3+B9
• SUM(B3:B9)
• =ADD(B3:B9)

Which formula gets the biggest value of a range of cells?

• MAX
• MIN
• LARGE
• SUM

Which of the following formulas is not entered correctly?

• =10+50
• =B7+B8
• =B7+14
• 10+50

What do you call the rectangles on a spreadsheet?

• Cell
• Button
• Sentence

True or False: Spreadsheets can be used in everyday life by analyzing sports stats, grades, and creating a budget for expenses?

• false
• true

A _________ is a computerized filing system that is used to organize and maintain a collection of information for future use.

• Query

• Report

• Database

• Spreadsheet

A database and a table is the same thing.

• True
• False

What function enables you to ask questions about the data stored in a database and returns the answers based on your criteria?

• Query

• Look Up

• Report

• Inquiry