Excel Chapter 3
chart sheet
A chart that occupies its own worksheet.
Format Painter
A tool to copy character and paragraph formatting.
Goal Seek
A what-if analysis tool that finds the input needed in one cell to arrive at the desired result in another cell.
Fill Without Formatting
Fill destination area with contents without formatting
category names
Ranges that identify the major groups for a chart.
fill handle
The black square in the lower-right corner of the active cell or range that you drag over the cells you want to fill.
zoom out
To shrink the appearance of a worksheet or chart
assumptions
a cell value that you can change to determine a new value for formulas
drag and drop
a feature that allows a user to select text using a mouse or pointing device, and quickly move (drag) it to a different location
violative Function
a function that automatically recalculates its values every time excel does any calculation in the workbook
relative cell reference
cell reference that adjusts to a new location when copied or moved
Paste cells
fill destination area-do not create a series.
#REF!
indicates a cell reference error
nested IF function
one in which the action to be taken for the true or false case includes yet another IF function
What-if analysis
process of changing values in cells to see how those changes affect the outcome of formulas in the worksheet
format symbols
symbols which assign a format to numbers as they are entered
IF function
useful when you want to assign a value to a cell based on a logical test
rotating text
1 degree to 90 degrees on alignment sheet
Absolute Reference
A cell reference that does not change when a formula is copied to a new location.
mixed cell reference
A cell reference that uses an absolute column or row reference, but not both.
NOW function
A function that returns today's date and the current time, in the default format of mm/dd/yyyy hh:mm.
data series
A group of related information in a column or row of a worksheet that is plotted on a chart.