Intro to Computer Apps Review

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?

• function
• absolute
• autosum
• relative

Which button would you use to copy your formatting?

• 
• 
• 
• 

Which of the following examples makes use of a range?

• =A1+B1
• AZ102
• =B6+C6
• =SUM(D2:R2)

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

• different first page
• different odd & even pages
• Remove Page Number
• Page Number

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

• you used the wrong type of cell reference
• the formula entered is incorrect
• the column is not wide enough

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

• record
• query
• primary key
• autonumber

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

• page break
• column break
• section break
• nothing, just change the top margin on each page that should be different.

Which of the following symbols is required before all formulas?

• +
• /
• =
• ^

The word "default" refers to __.

• settings that you cannot change in a program
• settings are automatic in a program.
• settings that are the same in all programs

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

• and
• or
• wildcard