INTRODUCTION TO SPREADSHEETS -
D100 VOCABULARY
1. Absolute Cell Reference
Answer A cell reference that remains constant when a formula is pasted into a new cell; contains a $
2. Algorithm
Answer The part of a calculation that is applied to the measure. Example
average gas price.
3. Arguments
Answer The information inputted to create a function
4. Bar Charts
Answer Charts that depict values with boxes that span the horizontal axis of the chart. The length of the boxes
represents the individual values. Larger values are depicted using longer boxes.
5. Cells
Answer Small boxes that store individual pieces of data or calculations
6. Charts
1/8
, Answer Depictions of larger data sets which less-related categories
7. Column Charts
Answer Charts that depict values with boxes that span the vertical axis of the chart. The length of the boxes
represents the individual values. Larger values are depicted using longer boxes.
8. Column and Row Labels
Answer Used to define how the data will be summarized and arranged on the PivotTable, defines
how source data will be categorized
9. Data
Answer A class of menu items used to aid in importing and working with large amounts of data.
10. Dynamic
Answer A formula that references and responds to changes in values in other cells
11. Expression
Answer The calculation prescribed by the formula in a spreadsheet
12. File
Answer A class of menu items used to manipulate workbooks.
2/8
D100 VOCABULARY
1. Absolute Cell Reference
Answer A cell reference that remains constant when a formula is pasted into a new cell; contains a $
2. Algorithm
Answer The part of a calculation that is applied to the measure. Example
average gas price.
3. Arguments
Answer The information inputted to create a function
4. Bar Charts
Answer Charts that depict values with boxes that span the horizontal axis of the chart. The length of the boxes
represents the individual values. Larger values are depicted using longer boxes.
5. Cells
Answer Small boxes that store individual pieces of data or calculations
6. Charts
1/8
, Answer Depictions of larger data sets which less-related categories
7. Column Charts
Answer Charts that depict values with boxes that span the vertical axis of the chart. The length of the boxes
represents the individual values. Larger values are depicted using longer boxes.
8. Column and Row Labels
Answer Used to define how the data will be summarized and arranged on the PivotTable, defines
how source data will be categorized
9. Data
Answer A class of menu items used to aid in importing and working with large amounts of data.
10. Dynamic
Answer A formula that references and responds to changes in values in other cells
11. Expression
Answer The calculation prescribed by the formula in a spreadsheet
12. File
Answer A class of menu items used to manipulate workbooks.
2/8
