Cell References
Formats
Functions
Chart Depiction
Worksheet Features
100
Comparatively adjusts a cell reference as it copies to the destination area
What is Relative Referencing
100
Any set of characters used to place titles that are left aligned by default
What is Text
100
Calculates the mean for a range of cells
What is the AVERAGE Function
100
Key to a chart that identifies each bar or section as titles from the leftmost column
What is a Legend
100
Used to conceal data that is sensitive or not relative
What is Hiding
200
Keeps a cell constant when copying a formula
What is Absolute Reference
200
Represent amounts that are right aligned by default
What is Numbers
200
Computes the total of a range of cells
What is the SUM Function
200
Vertical scale derived on the basis of the values in a worksheet
What is the Y-Axis (Value Axis)
200
Immobilizes worksheet row and or column titles as you scroll
What is Freeze Panes
300
Keeps only part of the cell reference constant as it copies
What is Mixed Cell Reference
300
Displays a value by multiplying the cell entry by 100 and rounding to the nearest hundredth
What is Percent Style
300
Displays the lowest value in a range
What is the MIN Function
300
Titles are derived from the entries in the topmost row of the range
What is the X-Axis (Category Axis)
300
Key used to select nonadjacent ranges
What is CTRL
400
Symbol used to specify absolute cell referencing before a column letter and/or row number
What is a Dollar Sign ($)
400
Displays when a column is not wide enough to display its numeric value
What is the Pound Symbol (#)
400
Assigns a value to a cell based on a logical test
What is the IF Function
400
Offsets one or more slices in a pie chart
What is Exploding
400
Combination of keys that allows you to enter a multi-line heading
What is ALT + ENTER
500
Small black square in lower right corner of the active cell used to copy a formula or series
What is the Fill Handle
500
Only appears when the value in a cell meets a specific condition
What is Conditional Formatting
500
Displays the system date
What is the NOW Function
500
Option that allows adjustment of the elevation and rotation of how a chart is viewed
What is 3-D View
500
Used to view the impact of changing values of cells referenced in a formula
What is What-If Analysis
M
e
n
u