30 terms

A set of rules that governs the structure and components for properly entering a function.

Syntax

Displays the current date.

TODAY function

Indicates a cell's specific location; the cell reference does not change when you copy the formula.

Absolute cell reference

Occurs when a formula directly or indirectly refers to itself.

Circular reference

An input, such as a cell reference or value, needed to complete a function.

Argument

Identifies the highest value in a range.

MAX function

Tallies the number of cells in a range that contain values.

COUNT function

Looks up a value in a vertical lookup table and returns a related result from the lookup table.

VLOOKUP function

A range that contains data for the basis of the lookup and data to be retrieved.

Lookup table

Calculates the arithmetic mean, or average, of values in a range.

AVERAGE function

Identifies the midpoint value in a set of values.

MEDIAN function

Displays the current date and time.

NOW function

Evaluates a condition and returns one value if the condition is true and a different value if the condition is false.

IF function

Calculates the total of values contained in two or more cells.

SUM function

Calculates the periodic payment for a loan with a fixed interest rate and fixed term.

PMT function

Indicates a cell's location from the cell containing the formula; the cell reference changes when the formula is copied.

Relative cell reference

Contains both an absolute and a relative cell reference in a formula; the absolute part does not change but the relative part does when you copy the formula.

Mixed cell reference

A word or string of characters that represents one or more cells.

Range name

An expression that evaluates to true or false.

Logical test

Displays the lowest value in a range.

MIN function

If cell D15 contains the formula =$C$5*D$15, what is the D15 in the formula?

Relative reference

Circular reference

Absolute reference

Range name

Relative reference

Circular reference

Absolute reference

Range name

Circular reference

What function would most appropriately accomplish the same thing as =(B5+C5+D5+E5+F5)/5?

=AVERAGE(B5:F5)

=SUM(B5:F5)/5

=COUNT(B5:F5)

=MEDIAN(B5:F5)

=AVERAGE(B5:F5)

=SUM(B5:F5)/5

=COUNT(B5:F5)

=MEDIAN(B5:F5)

=AVERAGE(B5:F5)

When you start =AV, what displays a list of functions and defined names?

Function Arguments dialog box

Function ScreenTip

Insert Function dialog box

Formula AutoComplete

Function Arguments dialog box

Function ScreenTip

Insert Function dialog box

Formula AutoComplete

Formula AutoComplete

A formula containing the entry =$B3 is copied to a cell one column to the right and two rows down. How will the entry appear in its new location?

=$B3

=$C5

=B3

=$B5

=$B3

=$C5

=B3

=$B5

=$B5

Cell B10 contains a date, such as 1/1/2016. Which formula will determine how many days are between that date and the current date, given that the cell containing the formula is formatted with Number Format?

=TODAY()

=TODAY()+NOW()

=TODAY()-B10

=CURRENT()-B10

=TODAY()

=TODAY()+NOW()

=TODAY()-B10

=CURRENT()-B10

=TODAY()-B10

Given that cells A1, A2, and A3 contain values 2, 3, and 10, respectively, and B6, C6, and D6 contain values 10, 20, and 30, respectively, what value will be returned by the function =IF(B6>A3,C6**A1,D6**A2)?

60

40

90

10

60

40

90

10

90

Given the function =VLOOKUP(C6,$D$12:$F$18,3), the entries in:

The third column of the lookup table must be text only.

Range D12:D18 are in ascending order.

Range D12:D18 are in descending order.

Range D12:D18 contain multiple values in each cell.

The third column of the lookup table must be text only.

Range D12:D18 are in ascending order.

Range D12:D18 are in descending order.

Range D12:D18 contain multiple values in each cell.

Range D12:D18 are in ascending order.

The function =PMT(C5,C7,-C3) is stored in cell C15. What must be stored in cell C5?

Periodic interest rate

Loan amount

Number of payment periods

APR

Periodic interest rate

Loan amount

Number of payment periods

APR

Periodic interest rate

Which of the following is not an appropriate use of the SUM function?

=SUM(F1:G10)

=SUM(D15-C15)

=SUM(A8:A15,D8:D15)

=SUM(B3:B45)

=SUM(F1:G10)

=SUM(D15-C15)

=SUM(A8:A15,D8:D15)

=SUM(B3:B45)

=SUM(D15-C15)

Which of the following is not an acceptable range name?

Goal for 2016

Test_Weight

FICA

Target_2015

Goal for 2016

Test_Weight

FICA

Target_2015

Goal for 2016