INTRO TO SPREADSHEETS - D100 WGU NEWEST 2025/2026 ACTUAL EXAM
COMPLETE QUESTIONS AND CORRECT ANSWERS (VERIFIED ANSWERS)
|ALREADY GRADED A+
Question 1
What is the definition of a "Workbook" in Excel?
A) A collection of cells arranged in the form of a table
B) A continuous block of selected cells
C) An Excel file that stores all information, previous calculations, and analyses
D) A class of menu items used to format data
E) A visual representation of a large set of data
Correct Answer: C) An Excel file that stores all information, previous calculations, and
analyses
Rationale: A Workbook is the actual Excel file itself (e.g., file.xlsx). It serves as the container
for all the data and must contain at least one worksheet. Option A describes a Worksheet, and
Option B describes a Range.
Question 2
Which term describes a collection of cells arranged in the form of a table that contains
actual data and calculations?
A) Workbook
B) Worksheet
C) Pane
D) Window
E) Range
Correct Answer: B) Worksheet
Rationale: A Worksheet (often called a sheet) is the specific grid or table within a workbook
where data entry and calculations occur. It is a single page within the Workbook file.
Question 3
Small boxes that store individual pieces of data or calculations are known as:
A) Panes
B) Ranges
C) Arguments
D) Cells
E) Filters
Correct Answer: D) Cells
Rationale: Cells are the fundamental units of a spreadsheet. They are the intersections of rows
and columns where individual data points or formulas are stored.
Question 4
What is a "Range" in the context of an Excel worksheet?
, 2
A) A single cell selected for formatting
B) A continuous block of cells that are selected
C) The area of the worksheet visible on the screen
D) A built-in color theme
E) A list of function arguments
Correct Answer: B) A continuous block of cells that are selected
Rationale: A Range refers to a group or block of cells that are selected together (e.g., A1:B10).
This allows the user to apply formatting or calculations to multiple cells simultaneously.
Question 5
Which of the following best describes "Quantitative" data?
A) Data used to screen information in a PivotTable
B) Data that includes names, locations, and gender
C) Built-in colors and styles
D) Numerical data generally used as the basis for calculations
E) Data that remains constant when pasted
Correct Answer: D) Numerical data generally used as the basis for calculations
Rationale: Quantitative data deals with numbers and quantities (amounts, prices, scores) that
can be calculated. This contrasts with Qualitative data (Option B), which is descriptive.
Question 6
Data that are descriptive, such as name, location, or gender, are classified as:
A) Quantitative
B) Qualitative
C) Static
D) Dynamic
E) Syntax
Correct Answer: B) Qualitative
Rationale: Qualitative data describes qualities or characteristics. It is often used to categorize
data into groups rather than for mathematical calculations.
Question 7
What is the purpose of "Formula Auditing"?
A) To change the color theme of the worksheet
B) To analyze a calculation in a spreadsheet to ensure that it is correct
C) To import large amounts of data
D) To freeze the top row of the pane
E) To compare parts to a whole in a chart
, 3
Correct Answer: B) To analyze a calculation in a spreadsheet to ensure that it is correct
Rationale: Formula Auditing is a set of tools used to trace precedents, dependents, and check
for errors. Its primary goal is ensuring the accuracy of the calculations within the sheet.
Question 8
A cell reference that remains constant when a formula is pasted into a new cell is called
a(n):
A) Relative Cell Reference
B) Mixed Reference
C) Absolute Cell Reference
D) Dynamic Reference
E) Static Reference
Correct Answer: C) Absolute Cell Reference
Rationale: An Absolute Cell Reference (indicated by $) locks the row and column so that the
reference does not change when the formula is copied or moved.
Question 9
Which symbol is used to indicate an Absolute Cell Reference?
A) &
B) #
C) %
D) $
E) @
Correct Answer: D)
∗∗∗∗ 𝑅𝑎𝑡𝑖𝑜𝑛𝑎𝑙𝑒:∗∗ 𝑇ℎ𝑒𝑑𝑜𝑙𝑙𝑎𝑟𝑠𝑖𝑔𝑛(∗∗
) is the syntax used to lock a reference. For example,
𝐴
1 locks both the column and the row.
Question 10
What is a "Relative Cell Reference"?
A) A reference that automatically updates when a formula is pasted to a new cell
B) A reference that contains two "$" signs
C) A reference where only the row is fixed
D) A formula that produces a consistent value like 1+1
E) A reference to a different workbook
, 4
Correct Answer: A) A reference that automatically updates when a formula is pasted to a
new cell
Rationale: Relative Cell References change based on their position relative to the new location.
If you move a formula down one row, a relative reference within it also shifts down one row.
Question 11
When one part of a cell reference is fixed (absolute) and the other part is relative, it is
known as a:
A) Static Reference
B) Dynamic Reference
C) Mixed Reference
D) Locked Reference
E) Syntax Error
Correct Answer: C) Mixed Reference
Rationale: A Mixed Reference locks either the row (A
1)𝑜𝑟𝑡ℎ𝑒𝑐𝑜𝑙𝑢𝑚𝑛(
A1), but not both. One part remains constant while the other updates when pasted elsewhere.
Question 12
A formula that references and responds to changes in values in other cells is described as:
A) Static
B) Dynamic
C) Absolute
D) Qualitative
E) Filtered
Correct Answer: B) Dynamic
Rationale: A Dynamic formula (e.g., =A1+B1) updates its result automatically whenever the
data in the referenced cells (A1 or B1) changes.
Question 13
What is a "Static" formula?
A) A formula that changes based on cell proximity
B) A formula that references other cells
C) A formula that produces a consistent value (e.g., =1+1)
D) A formula used in a PivotTable
E) A formula with optional arguments
COMPLETE QUESTIONS AND CORRECT ANSWERS (VERIFIED ANSWERS)
|ALREADY GRADED A+
Question 1
What is the definition of a "Workbook" in Excel?
A) A collection of cells arranged in the form of a table
B) A continuous block of selected cells
C) An Excel file that stores all information, previous calculations, and analyses
D) A class of menu items used to format data
E) A visual representation of a large set of data
Correct Answer: C) An Excel file that stores all information, previous calculations, and
analyses
Rationale: A Workbook is the actual Excel file itself (e.g., file.xlsx). It serves as the container
for all the data and must contain at least one worksheet. Option A describes a Worksheet, and
Option B describes a Range.
Question 2
Which term describes a collection of cells arranged in the form of a table that contains
actual data and calculations?
A) Workbook
B) Worksheet
C) Pane
D) Window
E) Range
Correct Answer: B) Worksheet
Rationale: A Worksheet (often called a sheet) is the specific grid or table within a workbook
where data entry and calculations occur. It is a single page within the Workbook file.
Question 3
Small boxes that store individual pieces of data or calculations are known as:
A) Panes
B) Ranges
C) Arguments
D) Cells
E) Filters
Correct Answer: D) Cells
Rationale: Cells are the fundamental units of a spreadsheet. They are the intersections of rows
and columns where individual data points or formulas are stored.
Question 4
What is a "Range" in the context of an Excel worksheet?
, 2
A) A single cell selected for formatting
B) A continuous block of cells that are selected
C) The area of the worksheet visible on the screen
D) A built-in color theme
E) A list of function arguments
Correct Answer: B) A continuous block of cells that are selected
Rationale: A Range refers to a group or block of cells that are selected together (e.g., A1:B10).
This allows the user to apply formatting or calculations to multiple cells simultaneously.
Question 5
Which of the following best describes "Quantitative" data?
A) Data used to screen information in a PivotTable
B) Data that includes names, locations, and gender
C) Built-in colors and styles
D) Numerical data generally used as the basis for calculations
E) Data that remains constant when pasted
Correct Answer: D) Numerical data generally used as the basis for calculations
Rationale: Quantitative data deals with numbers and quantities (amounts, prices, scores) that
can be calculated. This contrasts with Qualitative data (Option B), which is descriptive.
Question 6
Data that are descriptive, such as name, location, or gender, are classified as:
A) Quantitative
B) Qualitative
C) Static
D) Dynamic
E) Syntax
Correct Answer: B) Qualitative
Rationale: Qualitative data describes qualities or characteristics. It is often used to categorize
data into groups rather than for mathematical calculations.
Question 7
What is the purpose of "Formula Auditing"?
A) To change the color theme of the worksheet
B) To analyze a calculation in a spreadsheet to ensure that it is correct
C) To import large amounts of data
D) To freeze the top row of the pane
E) To compare parts to a whole in a chart
, 3
Correct Answer: B) To analyze a calculation in a spreadsheet to ensure that it is correct
Rationale: Formula Auditing is a set of tools used to trace precedents, dependents, and check
for errors. Its primary goal is ensuring the accuracy of the calculations within the sheet.
Question 8
A cell reference that remains constant when a formula is pasted into a new cell is called
a(n):
A) Relative Cell Reference
B) Mixed Reference
C) Absolute Cell Reference
D) Dynamic Reference
E) Static Reference
Correct Answer: C) Absolute Cell Reference
Rationale: An Absolute Cell Reference (indicated by $) locks the row and column so that the
reference does not change when the formula is copied or moved.
Question 9
Which symbol is used to indicate an Absolute Cell Reference?
A) &
B) #
C) %
D) $
E) @
Correct Answer: D)
∗∗∗∗ 𝑅𝑎𝑡𝑖𝑜𝑛𝑎𝑙𝑒:∗∗ 𝑇ℎ𝑒𝑑𝑜𝑙𝑙𝑎𝑟𝑠𝑖𝑔𝑛(∗∗
) is the syntax used to lock a reference. For example,
𝐴
1 locks both the column and the row.
Question 10
What is a "Relative Cell Reference"?
A) A reference that automatically updates when a formula is pasted to a new cell
B) A reference that contains two "$" signs
C) A reference where only the row is fixed
D) A formula that produces a consistent value like 1+1
E) A reference to a different workbook
, 4
Correct Answer: A) A reference that automatically updates when a formula is pasted to a
new cell
Rationale: Relative Cell References change based on their position relative to the new location.
If you move a formula down one row, a relative reference within it also shifts down one row.
Question 11
When one part of a cell reference is fixed (absolute) and the other part is relative, it is
known as a:
A) Static Reference
B) Dynamic Reference
C) Mixed Reference
D) Locked Reference
E) Syntax Error
Correct Answer: C) Mixed Reference
Rationale: A Mixed Reference locks either the row (A
1)𝑜𝑟𝑡ℎ𝑒𝑐𝑜𝑙𝑢𝑚𝑛(
A1), but not both. One part remains constant while the other updates when pasted elsewhere.
Question 12
A formula that references and responds to changes in values in other cells is described as:
A) Static
B) Dynamic
C) Absolute
D) Qualitative
E) Filtered
Correct Answer: B) Dynamic
Rationale: A Dynamic formula (e.g., =A1+B1) updates its result automatically whenever the
data in the referenced cells (A1 or B1) changes.
Question 13
What is a "Static" formula?
A) A formula that changes based on cell proximity
B) A formula that references other cells
C) A formula that produces a consistent value (e.g., =1+1)
D) A formula used in a PivotTable
E) A formula with optional arguments
