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