Excel/Access EOC Review

What is an active cell?

• The first cell in a database.
• The cell currently selected.
• The cell that all the data goes to.
• The cell that you typed in last.

A bar graph compares multiple values.

• True
• False

When you create a graph, you...

• select all the data.
• select what you want to affect.
• select the first cell only.
• select the entire spreadsheet.

What allows one to enter numbers to be calculated?

• cells
• formulas
• functions
• active cells

Where do you configure the field properties of a Table?

• Design View
• Datasheet View
• Access View
• Window View

Where do you see the results of a Query?

• Query Design View
• Query Datasheet View
• Query DataSet Review
• Table Design View

You want to enter a series of dates down a column.  What would be the best tool for the job?

• Cut and Paste
• Spelling Checker
• Autofill
• Find and Replace

What term refers to mathematical equations used in Excel to perform calculations?

• Formal
• Cell
• Formulas
• Summations

What symbol is used to designate an absolute cell reference?

• #
• !
• $
• @

In Excel, all formulas must begin with what symbol?

• !
• #
• $
• =