Front

If I enter a formula and I want Excel to use the same cell over and over in the calculation, (when I copy the formula), which cell reference type do I need to use?

Back

absolute

Front

Which button would you use to copy your formatting?

Back

Front

Which of the following examples makes use of a range? Options: A1+B1, AZ102, B6+C6, SUM(D2:R2)

Back

=SUM(D2:R2)

Front

What option is used to make sure that there is no page number on any other pages but the first page of a report?

Back

different first page

Front

When you see ###### in a cell, this means __.

Back

the column is not wide enough

Front

A __ keeps you from being able to enter the same record twice in that field.

Back

primary key

Front

In order to have different margins on different pages of a report, you have to use a __.

Back

section break

Front

Which of the following symbols is required before all formulas? Options: +, /, =, ^

Back

=

Front

The word "default" refers to __.

Back

settings are automatic in a program.

Front

If you wanted to search a real estate database for all houses that have 1-2 bathrooms, you would create a __ query.

Back

and