Upgrade to remove ads
Only $2.99/month

Excel Chapter 3 Vocabulary List

Terms in this set (21)

#REF! (EX 146)
Excel displays the error message, in those cells to indicate a cell reference error.
absolute cell reference (EX 151)
Excel keep the cell reference B4 constant(absolute) in the formula as it copies it to the destination.
assumptions (EX 130)
Are values in cells that you can change to determine new values for formulas.
category names (EX 170)
Will identify the major groups for the chart; these entries are called category names.
clustered (EX 170)
Column chart to compare values side by side, broken down by category.
data series (EX 170)
Contains the data that determines the individual columns in each month cluster, and the names of each column; these entries are called data series.
drag and drop (EX 143)
Using the touch system or the mouse to move or copy cells is called drag and top.
format symbols (EX 147)
Symbols which assign a format to numbers as they are entered.
freeze columns and rows (EX 185)
So Excel displays their content on the screen, no matter how far down or to the right you scroll.
IF function (EX 155)
When you want to assign a value to a cell based on a logical test.
logical test (EX 154)
It can be represented in diagram form.
mixed cell reference (EX 151)
A cell reference with only one dollar sign before either the column or the row is called a mixed cell reference.
nested IF function (EX 159)
Is one in which the action to be taken for the true or false case includes yet another if function.
NOW function (EX 148)
Is one of 24 date and time functions available in Excel.
Office Clipboard (EX 141)
A temporary storage area in the computer's memory that allows you to collect text and graphics from an Office document and then paste them into almost any other type of document.
relative cell reference (EX 151)
Instructs Excel to keep the cell reference as it copies it tho the destination area.
sensitivity analysis (EX 187)
Using Excel to scrutinize the impact of changing values in cells that are referenced by a formula in another cell what-if analysis or sensitivity analysis.
sparkline chart (EX 160)
Provides a simple way to show trends and variations in a range of data within a single cell.
underline format (EX 169)
Format underline only the characters in the cell, rather than the entire cell, as is the case when you assign a cell a bottom border.
volatile function (EX 149)
The number that the function returns is not constant, but changes each time the worksheet is opened.
what-if analysis (EX 187)
Using Excel to scrutinize the impact of changing values in cells that are referenced by a formula in another cell is called what-if analysis or sensitivity analysis.
YOU MIGHT ALSO LIKE...