A graphic that appears behind the informatin in a worksheet. Solid colors, patterns or pictures that fill the entire slide and appear behind the slide's content
What is Background
100
A line or box that frames text or a cell
What is Border
100
A function that displays the date and time that a worksheet is opened or used.
What is NOW
100
The side-to-side placement of the contents of a cell
What is Horizontal Alignment
100
The top-to-bottom placement of the contents of a cell
What is Vertical Alignment
200
A graphic that organizes data visually. Common ones are pie, bar, and line
What is Chart
200
A symbol that represents a mathematical function
What is Operator
200
A group of cells
What is Range
200
A gallery that contains six types of customizable diagrams
What is SmartArt
200
A rule
What is Condition
300
A graphic that may be used in a list, such as bulleted or numbered list.
What is Graphical list
300
A function used to find tha number of cells in a range that contains data (numbers and text)
What is COUNTA
300
A function that counts the number of cells in the range that contains numbers
What is COUNT
300
A feature that allows you to look at only the data that you need
What is Filter
300
A list of preset formulas that are used to solve equations
What is Function
400
A function that checks to see if a condition is met and then has one result if it is true and another if it is false
What is IF
400
A cell reference that does not change when a formula is copied to a new location
What is Absolute reference
400
A cell reference that is part relative and part absolute
What is Mixed reference
400
A cell reference that changes when a formula is copied to a new location
What is Relative reference
400
To put a list of data is ascending or descending order
What is Sort
500
A divider that separates text
What is delimiter
500
A set of formatting traits that has been given a name
What is Cell style
500
A pre-defined set of formats that can be applied to a range of data
What is Table style
500
A function that calculates payments for a loan based on interest rate, number of payments and the amount of the loan