TCO 2) In Excel, a relative cell reference:

indicates a cell’s specific location and the

reference does not change when you copy the formula.

contains both an absolute and a relative cell

reference.

indicates a cell’s relative location from the

cell containing the formula; the reference changes when you copy the formula.

occurs when a formula directly or indirectly

refers to the cell containing the formula.

:

Question 2. Question

:

(TCO 2) In Excel, a function can be defined as a _____.

predefined formula that performs a calculation

cell reference or a value

list of values and defined names as you enter

data into a spreadsheet

set of rules that govern the structure and

components for a formula

Question 3. Question

:

(TCO 2) The rules for constructing a function can be

referred to as the function’s _____.

synthesis

synergy

synchronization

syntax

Question 4. Question

:

(TCO 2) Which of the following describes the SUM function?

Identifies the midpoint value in a set of

values.

Calculates the total of values contained in

two or more cells.

Calculates the arithmetic mean or average of

values in a range.

Displays the lowest value in a range.

Question 5. Question

:

(TCO 2) The _____ function returns a result based on a

condition.

Student Answer: MAX

TODAY

FIND

IF

Question 6. Question

:

(TCO 2) Which of the following best describes the COUNT

function?

Tallies the number of cells in a range that

are not empty.

Tallies the number of blank cells in a range.

Displays the current date.

Tallies the number of cells in a range that

contain values.

Question 7. Question

:

(TCO 2) In the arguments to an IF function, the condition

that is evaluated to determine if it is true or false is also sometimes called

a _____.

logical test

lookup value

breakpoint

table array action

Question 8. Question

:

(TCO 2) If you enter an = and the first few letters of a

function in the formula bar, Excel will display a drop-down list of functions

beginning with those letters. This feature is called _____.

Syntax Helper

Formula AutoComplete

Formula Wizard

:

Question 9. Question

:

(TCO 2) Which of the following best describes the HLOOKUP

function?

The periodic interest rate, such as a monthly

interest rate.

Calculates the periodic payment for a loan

with a fixed interest rate and fixed term.

Looks up a value in a lookup table where the

first column contains the values to compare with the lookup value.

Looks up a value in a lookup table in which

the first row contains the values to compare with the lookup value.

Question 10. Question

:

(TCO 2) One benefit of using range names in formulas is that

_____ .

it directly or indirectly refers to the cell

containing the formula

it contains both an absolute and a relative

cell reference

it identifies the present value of the loan

if you copy the formula, you do not have to

make the cell reference absolute

Question 11. Question

:

(TCO 2) The PMT function is best described by which of the

following?

It is the periodic interest rate, such as a

monthly interest rate.

It is the total number of payment periods.

It is the present value of a loan.

It calculates the periodic payment for a loan

with a fixed interest rate and a fixed term.

:

Question 12. Question

:

(TCO 7) Which of the following is NOT an Excel tool used to

improve productivity in developing consistently formatted workbooks?

Macros

Templates

Themes

INCORRECT Background

Question 13. Question

:

(TCO 7) Before protecting a worksheet, you should _____ the

cells that you want users to be able to edit.

format

hide

lock

unlock

:

Question 14. Question

:

(TCO 7) Which of the following file formats can store

macros?

xlsm

csv

xml

xlsx

Question 15. Question

:

(TCO 7) To create a macro button, click the _____ tab, click

Insert, then click Button in the Form Controls section of the Insert palette.

View

Data

Insert

Developer