Ch 8 Terms

Lakukan tugas rumah & ujian kamu dengan baik sekarang menggunakan Quizwiz!

compare values

the categories used for matching to a specified lookup value in a lookup table

lookup value

the category you want to find in a lookup table

Structured reference

The excel table name or column header that you can use in a formula in place of its cell or range reference

calculated column

a column in an Excel table in which a formula entered or edited in one cell of the cell is automatically copied into all cells in the column

conditional sum

a function that adda the values in a range that match criteria you specify

SUMIF function

a function that adds values in a range that meet multiple criteria

AVERAGEIF function

a function that calculates the average of values in a range that match criteria you specify

DATEDIF function

a function that calculates the difference between two dates and shows the results in months, days or years

COUNTIF function

a function that calculates the number of cells within a range that meet multiple criteria

IFERROR function

a function that can determine if a cell contains an error value and then display the message you choose rather than the default error value

conditional count

a function that counts the number of cells in a range that match criteria you specify

lookup functions

a function that finds a value in a table of data and inserts it in another location in the worksheet, such as a cell or in a formula

AND function

a logical function that returns a TRUE value if all of the logical conditions are true, and a FALSE value if any or all of the logical conditions are false

OR function

a logical function that returns a TRUE value if any of the logical conditions are true, and a FALSE value if none of the logical conditions are true

HLOOKUP function

a lookup function that searches across the first row of the lookup table until the lookup value exactly matches a value in the first row, and then retrieves the corresponding value from the second row of the lookup table

Approximate match lookup

a lookup where the lookup value falls within a range of numbers in the compare values in the lookup table

exact match lookup

a lookup where the lookup value must match one of the compare values in the lookup table

error values

a message in a cell that indicates some part of a formula is preventing Excel from returning a calculated value

conditional formatting rule

a rule that specifies the condition, the formatting, and the cell or range to apply the rule to

lookup table

a table that stores the data you want to retrieve with a lookup function in categories

nested IF function

one IF function placed inside another IF function to test an additional condition

VLOOKUP function

the function that returns values from a vertical lookup table


Set pelajaran terkait

What did you learn?- Fluid Volume Excess

View Set

Business Ownershipi & Entrepreneurship Quiz

View Set

Business Law Chapter 50: Real Property

View Set

Ch 34: Management of Patients with Hematologic Neoplasms

View Set

History Chapter 15.1 Renaissance Quiz

View Set

Social Media + Content Marketing - Exam Two

View Set