Show:
Terms
Basics
Formulas
Functions
Charts/Graphs
100
Format data using commas and dollar signs
What is currency format
100
A feature that allows the user to copy or fill data in cells adjacent to the original cells
What is fill
100
Symbol that indicates the information that follows is a calculation rather than a value
What is an equal sign
100
Built-in mathematical formula
What is a function
100
Chart object that explains the colors, patterns, or symbols used in a chart
What is legend
200
A format that converts a decimal number to a percentage
What is percentage format
200
A method of keeping certain rows or columns visible at all times, such as column headings
What is freeze title
200
Alternative term for order of precedence in math hierarchy (Please Excuse My Dear Aunt Sally)
What is order of operation
200
function that returns the highest number in a range of cells
What is Max function
200
Data is arranged in the shape of a pie with data represented by various percentages of the pie
What is pie chart
300
Built-in set of formatting instructions that applies fonts, colors, borders, and other formats to a range
What is AutoFormat
300
Action that divides the screen into to or more screens
What is split screen
300
Cell address that adjusts to the row or column where a copied formula is located
What is relative reference
300
Function that returns the lowest number in a range of cells
What is Min function
300
A chart in which data is represented by vertical bars
What is a column chart
400
Sets of formatting specifications
What are styles
400
Printing option that allows user to change page scaling
What is fit to
400
Cell address that does not change when copied in a formula
What is absolute reference
400
Built-in mathematical function that determines the average of a block of cells
What is Average function
400
One value from a data series in a chart
What is a data point
500
Retangular area on a chart bound by the category and value axes
What is plot area
500
Projecting with a spreadsheet by changing the data
What is what-if analysis
500
Cell address that adjusts either the row or the column when the formula is copied
What is mixed reference
500
Values or cell references (included between parentheses) that a function needs to complete its calculation
What is argument
500
Horizontal or vertical grouping of values from the worksheet
What is value axis