How can we help?

You can also find more resources in our Help Center.

Excel Ch 3 Review

STUDY
PLAY
NOW function
Returns a number that corresponds to the system date & time beginning with December 31, 1899.
format painter button
Formats a cell quickly by copying a cell's format to another cell or range of cells
goal seeking
Determines the value of a cell on which the formula depends.
what-if analysis
Scrutinizes the impact of changing values in cells that are referenced by a formula in another cell.
Pie chart
Shows the relationship or proportion of parts to a whole.
freeze titles
Excel will display titles on the screen, no matter how far you scroll
relative cell referencing
Adjusts a cell referen ce when copying a formula or function
exploding
Offsets a piece of a pie chart for emphasis
IF function
Assigns a value to a cell based on a logical test.
absolute cell referencing
Keeps a cell reference constant when copying a formula or function.
Exploded Pie Chart
A Pie chart with one or more slices offset is called a(n) ______.
immediately redraws the chart based on the new value
When you change a value on which a chart is dependent, Excel _____.
Goal seeking
If you know the result you want a formula to produce, you can use ____ to determine the value of a cell on shich the formula depends.
Absolute Cell Reference
Keeps a cell reference constant when copying a formula or function
Pie chart
Shows the relationship or porportion of parts to a whole.
Mixed Cell Reference
A cell reference with only one dollar sign before either the column or the row.
#REF!
Indicates a cell reference error.