Excel Ch 3
Use this activity to help or assist you with the vocabulary words for this chapter.
Terms in this set (19)
Absolute Cell Reference
A formula that instructs Excel to keep the cell reference constant in the formula as it copies it to the destination area. (Example: $B$20)
Entries on a chart that will identify the slices or pieces of a chart.
When a chart is created and contains only the chart on a new worksheet, not embedded on worksheet.
Contains the data that determines the size of the slices or pieces in the chart.
Shows the date a workbook, report, or other document was created or the period it represents.
Drag & Drop
Using the mouse to move or copy cells.
Exploded Pie Chart
A pie chart with one or more slices offset from the rest of the chart.
When a number is entered with this symbol, Excel immediately displays it with the assigned format. Symbols include $ , and % signs.
Freeze the Titles
Excel displays the titles on the screen, no matter how far down or to the right you scroll.
If you know the result and want a formula to produce it, you can use this to determine the value of a cell on which the formula depends.
Useful when you want to assign a value to a cell based on a logical test. The argument is made up of 2 expressions and a comparison operator. (Example: =IF (B4>=$B$24,$B$19,0)
Logical test, Value if true, Value if false
Mixed Cell Reference
A cell reference with only one $ sign before either the column or the row. (Example:$B20 or B$20)
Nested IF Function
One in which the action to be taken for the true or false case includes another IF function. The second one is considered to be layered within the first.
one of the 22 date and time functions available in Excel that when assigned to a cell returns a number that corresponds to the system date and time.
A reserved place in the computer's memory that allows you to collect text and graphic items from an Office document and then pastes them into any Office document.
Shows the relationship or proportion of parts to a whole. Each slice of the pie shows what percentage of that slice contributes to the total.
Relative Cell Reference
A formula that instructs Excel to adjust the cell reference as it copies it to the destination area. (Example: B20)
When Excel changes value in cells that are referenced by a formula in another cell; also known as a what-if analysis.
Provides a simple way to show trends and variations in a range of data within a cell. The three types used in Excel are line, column, and win/loss.