A feature which allows data to to be formatted a certain way if it meets certain user-defined conditions.
What is the Conditional Formatting?
A function that performs a horizontal lookup by searching for a value in the top row of a table and returning the value from the same column.
HLOOKUP
What is the intersection of rows and columns on the worksheet?
Cell Address
A function that adds all numbers in a range of cells.
What is SUM?
A function that counts the number of cells in a range.
What is COUNT?
What is the infinite number of rectangles in a workbook?
A cell
An option that will format a cell to a user-defined format.
What is Cell Style?
A function that returns the average of all numbers in a range of cells.
What AVERAGE?
A function that returns a value based on multiple user-specified criteria.
What is IF?