30 terms

# Excel Chapter 2

#### Terms in this set (...)

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
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)
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
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
=\$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()-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,C6A1,D6A2)?

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.
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
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(D15-C15)
Which of the following is not an acceptable range name?
Goal for 2016

Test_Weight

FICA

Target_2015
Goal for 2016
STUDY GUIDE