INTRO TO SPREADSHEETS - D100 WGU
COMPLETE EXAM STUDY QUESTIONS
WITH VERIFIED ANSWERS
1. Absolute Cell Reference - ANSWER A cell reference that remains constant
when a formula is pasted into a new cell; contains two "$".
2. Algorithm - ANSWER The part of a calculation that is applied to the
measure. Example: average gas price.
3. Home - ANSWER A class of menu items used to format the appearance of
data in cells.
4. Insert - ANSWER An area that includes features for specializing elements
into workbooks, such as charts, pictures, and shapes.
5. Line Charts - ANSWER Charts that depict values as discrete points of
intersection for the values of the horizontal and vertical axes. The points are
generally connected using a line.
6. File - ANSWER A class of menu items used to manipulate workbooks.
7. Formula Auditing - ANSWER Analyzing a calculation in a spreadsheet to
ensure that it is correct
8. Formulas - ANSWER The calculations performed in a spreadsheet.
,9. Function Wizard - ANSWER A window that allows you to select inputs for
a function. Also provides a description of the function and lists the function
result based on the inputs you enter
10.Graphs - ANSWER - A two-dimensional representation of numerical data
using a line or a curve
- Used to display a numerical representation of data
11.Static - ANSWER A formula that produces a consistent value (for example,
=1+1 will always yield 2)
12.Syntax - ANSWER The layout and order of the function and its arguments
13.Themes - ANSWER Built-in colors and styles that can be applied to entire
worksheets
14.Values - ANSWER Defines which data will be displayed on the PivotTable
15.View - ANSWER A class of menu items that are used to change how a
worksheet is displayed on the screen.
16.Window - ANSWER A view of the current workbook
17.Linear Trendline - ANSWER A line usually dotted that is added to a line
graph that shows a statistical trend in a set of data
18.Measure - ANSWER The part of a calculation to which an algorithm is
applied. Example: gas price.
,19.Mixed References - ANSWER When one part of the cell reference, either
the column or the row, is fixed (absolute) and the other part is relative
(changes based on proximity to other cells)
20.Optional Arguments - ANSWER Appear with brackets in a function.
Provide aditional information or instructions for how to handle a calculation.
Omission does not prevent completion of a calculation
21.Page Layout - ANSWER A class of menu items used to format the
appearance of worksheets.
22.Pane - ANSWER The area of a worksheet that is visible on the screen
23.Pie Chart - ANSWER A chart used to compare parts to a whole by dividing
a circle into slices, or wedges, that represent individual data values. The
slices of the pie chart are sized proportionally to the relative size of the
values each slice represents. Large values are represented with larger slices.
24.Qualitative - ANSWER Data that are descriptive, such as name, location,
gender, etc; Often used to classify data into groups.
25.Quantitative - ANSWER Numerical data, generally used as the basis for
calculations
26.Range - ANSWER A continous block of cells that are selected in an Excel
worksheet.
, 27.When it appears as the first character in a cell, which character signals to
Excel that the contents of the cell should be treated as a calculation?
• The equals character (=)
• The multiplication character (*)
• The division character (/)
• The exponent character (^) - ANSWER The equals character
(=) - The equals sign is the first character in a cell. Without
the equals sign, Excel would not recognize the cell's contents
as a calculation.
28.The result of a function changes as the values in the other cells referenced by
that function change in what kind of function?
• Dynamic
• Simple
• Static
• Complex - ANSWER Dynamic - A dynamic function
changes when the values in the cells it references change.
29.Which Excel feature(s) are used to reuse a formula from one cell to another?
• Freeze Panes
• Copy and Paste
• Repeat Headers
• Sort and Filter - ANSWER Copy and Paste - Copy and Paste
allow you to transfer a formula into another cell.
30.A spreadsheet template __________.
• is static and resistant to changes in the worksheet
• may only be used by the person who created it
• must be rebuilt every time a person uses it
• can be used repeatedly with changing inputs - ANSWER can
be used repeatedly with changing inputs - A spreadsheet
template is very versatile.
COMPLETE EXAM STUDY QUESTIONS
WITH VERIFIED ANSWERS
1. Absolute Cell Reference - ANSWER A cell reference that remains constant
when a formula is pasted into a new cell; contains two "$".
2. Algorithm - ANSWER The part of a calculation that is applied to the
measure. Example: average gas price.
3. Home - ANSWER A class of menu items used to format the appearance of
data in cells.
4. Insert - ANSWER An area that includes features for specializing elements
into workbooks, such as charts, pictures, and shapes.
5. Line Charts - ANSWER Charts that depict values as discrete points of
intersection for the values of the horizontal and vertical axes. The points are
generally connected using a line.
6. File - ANSWER A class of menu items used to manipulate workbooks.
7. Formula Auditing - ANSWER Analyzing a calculation in a spreadsheet to
ensure that it is correct
8. Formulas - ANSWER The calculations performed in a spreadsheet.
,9. Function Wizard - ANSWER A window that allows you to select inputs for
a function. Also provides a description of the function and lists the function
result based on the inputs you enter
10.Graphs - ANSWER - A two-dimensional representation of numerical data
using a line or a curve
- Used to display a numerical representation of data
11.Static - ANSWER A formula that produces a consistent value (for example,
=1+1 will always yield 2)
12.Syntax - ANSWER The layout and order of the function and its arguments
13.Themes - ANSWER Built-in colors and styles that can be applied to entire
worksheets
14.Values - ANSWER Defines which data will be displayed on the PivotTable
15.View - ANSWER A class of menu items that are used to change how a
worksheet is displayed on the screen.
16.Window - ANSWER A view of the current workbook
17.Linear Trendline - ANSWER A line usually dotted that is added to a line
graph that shows a statistical trend in a set of data
18.Measure - ANSWER The part of a calculation to which an algorithm is
applied. Example: gas price.
,19.Mixed References - ANSWER When one part of the cell reference, either
the column or the row, is fixed (absolute) and the other part is relative
(changes based on proximity to other cells)
20.Optional Arguments - ANSWER Appear with brackets in a function.
Provide aditional information or instructions for how to handle a calculation.
Omission does not prevent completion of a calculation
21.Page Layout - ANSWER A class of menu items used to format the
appearance of worksheets.
22.Pane - ANSWER The area of a worksheet that is visible on the screen
23.Pie Chart - ANSWER A chart used to compare parts to a whole by dividing
a circle into slices, or wedges, that represent individual data values. The
slices of the pie chart are sized proportionally to the relative size of the
values each slice represents. Large values are represented with larger slices.
24.Qualitative - ANSWER Data that are descriptive, such as name, location,
gender, etc; Often used to classify data into groups.
25.Quantitative - ANSWER Numerical data, generally used as the basis for
calculations
26.Range - ANSWER A continous block of cells that are selected in an Excel
worksheet.
, 27.When it appears as the first character in a cell, which character signals to
Excel that the contents of the cell should be treated as a calculation?
• The equals character (=)
• The multiplication character (*)
• The division character (/)
• The exponent character (^) - ANSWER The equals character
(=) - The equals sign is the first character in a cell. Without
the equals sign, Excel would not recognize the cell's contents
as a calculation.
28.The result of a function changes as the values in the other cells referenced by
that function change in what kind of function?
• Dynamic
• Simple
• Static
• Complex - ANSWER Dynamic - A dynamic function
changes when the values in the cells it references change.
29.Which Excel feature(s) are used to reuse a formula from one cell to another?
• Freeze Panes
• Copy and Paste
• Repeat Headers
• Sort and Filter - ANSWER Copy and Paste - Copy and Paste
allow you to transfer a formula into another cell.
30.A spreadsheet template __________.
• is static and resistant to changes in the worksheet
• may only be used by the person who created it
• must be rebuilt every time a person uses it
• can be used repeatedly with changing inputs - ANSWER can
be used repeatedly with changing inputs - A spreadsheet
template is very versatile.
