INTRO TO SPREADSHEETS - D100 WGU NEWEST 2025 ACTUAL EXAM
COMPLETE QUESTIONS AND CORRECT ANSWERS (VERIFIED ANSWERS)
|ALREADY GRADED A+
Question 1
In spreadsheet terminology, what is an Excel file that stores all the information, calculations,
and analyses, and must contain at least one worksheet?
A) A Cell
B) A Worksheet
C) A Workbook
D) A Pane
E) A Range
Correct Answer: C) A Workbook
Rationale: A Workbook is the entire Excel file, acting as a container for all related data. It is
analogous to a physical binder that holds one or more individual sheets of paper
(Worksheets). Cells, Panes, and Ranges are all components within a worksheet, not the file
itself.
Question 2
What term describes a collection of cells arranged in a table format of columns and rows that
contains the actual data and calculations?
A) A Workbook
B) A Window
C) A Worksheet
D) A Formula
E) A Theme
Correct Answer: C) A Worksheet
Rationale: A Worksheet, often called a spreadsheet or a sheet, is the primary grid-like area
where you work. It is composed of columns and rows, and the intersection of these forms
cells where you input data. A Workbook is the file that contains one or more worksheets.
,Question 3
In a spreadsheet, what are the small boxes that are arranged in columns and rows and are used
to store individual pieces of data or calculations?
A) Ranges
B) Panes
C) Workbooks
D) Cells
E) Arguments
Correct Answer: D) Cells
Rationale: A cell is the fundamental unit of a worksheet. It is the specific location, identified
by its column letter and row number (e.g., A1, B2), where data, text, or a formula is entered.
A range is a group of cells, but a cell is the individual box.
Question 4
When you copy a formula from one cell to another and the cell references in the formula
automatically update to reflect the new location, what type of cell references are being used?
A) Absolute Cell References
B) Mixed Cell References
C) Static Cell References
D) Dynamic Cell References
E) Relative Cell References
Correct Answer: E) Relative Cell References
Rationale: Relative cell references are the default in Excel. They are "relative" to the location
of the cell containing the formula. When you copy the formula, these references adjust
automatically, which is efficient for applying the same calculation across multiple rows or
columns.
Question 5
What is a cell reference that remains constant when a formula is pasted into a new cell and is
identified by the inclusion of two dollar signs ($)?
,A) An Absolute Cell Reference
B) A Relative Cell Reference
C) A Mixed Cell Reference
D) A Dynamic Cell Reference
E) A Static Cell Reference
Correct Answer: A) An Absolute Cell Reference
Rationale: An absolute cell reference, such as $A$1, locks the reference to a specific cell. The
two dollar signs fix both the column (A) and the row (1). This is crucial when a formula must
always refer to a single, constant cell, such as a tax rate or a commission percentage, no
matter where the formula is copied.
Question 6
A cell reference in a formula that has one part fixed (absolute) and one part that can change
(relative), such as $A1 or A$1, is known as what?
A) A Relative Reference
B) An Absolute Reference
C) A Dynamic Reference
D) A Static Reference
E) A Mixed Reference
Correct Answer: E) A Mixed Reference
Rationale: A mixed reference combines both absolute and relative referencing. $A1 locks the
column but allows the row to change when the formula is copied, while A$1 locks the row but
allows the column to change. This is useful for creating tables where calculations refer to both
a specific row and a specific column header.
Question 7
The calculations performed in a spreadsheet, which typically begin with an equals sign (=), are
known as what?
A) Functions
B) Formulas
, C) Arguments
D) Syntax
E) Algorithms
Correct Answer: B) Formulas
Rationale: A formula is an expression that operates on values in a range of cells. It is a user-
defined calculation. While a formula can contain functions (pre-built calculations like SUM or
AVERAGE), the term "formula" refers to the entire calculation string starting with the equals
sign.
Question 8
When a formula in a cell references other cells and its result automatically updates in response
to changes in the values of those referenced cells, the formula is described as what?
A) Static
B) Absolute
C) Relative
D) Dynamic
E) Audited
Correct Answer: D) Dynamic
Rationale: A dynamic formula creates a live link between cells. Its power lies in its ability to
change its output automatically whenever the input data changes, making the spreadsheet
interactive and efficient. A static formula, by contrast, does not change.
Question 9
If you enter =5+10 into a cell, the result will always be 15, regardless of the values in other cells.
What term describes this type of formula?
A) Dynamic
B) Relative
C) Static
D) Absolute
E) Corrupt
COMPLETE QUESTIONS AND CORRECT ANSWERS (VERIFIED ANSWERS)
|ALREADY GRADED A+
Question 1
In spreadsheet terminology, what is an Excel file that stores all the information, calculations,
and analyses, and must contain at least one worksheet?
A) A Cell
B) A Worksheet
C) A Workbook
D) A Pane
E) A Range
Correct Answer: C) A Workbook
Rationale: A Workbook is the entire Excel file, acting as a container for all related data. It is
analogous to a physical binder that holds one or more individual sheets of paper
(Worksheets). Cells, Panes, and Ranges are all components within a worksheet, not the file
itself.
Question 2
What term describes a collection of cells arranged in a table format of columns and rows that
contains the actual data and calculations?
A) A Workbook
B) A Window
C) A Worksheet
D) A Formula
E) A Theme
Correct Answer: C) A Worksheet
Rationale: A Worksheet, often called a spreadsheet or a sheet, is the primary grid-like area
where you work. It is composed of columns and rows, and the intersection of these forms
cells where you input data. A Workbook is the file that contains one or more worksheets.
,Question 3
In a spreadsheet, what are the small boxes that are arranged in columns and rows and are used
to store individual pieces of data or calculations?
A) Ranges
B) Panes
C) Workbooks
D) Cells
E) Arguments
Correct Answer: D) Cells
Rationale: A cell is the fundamental unit of a worksheet. It is the specific location, identified
by its column letter and row number (e.g., A1, B2), where data, text, or a formula is entered.
A range is a group of cells, but a cell is the individual box.
Question 4
When you copy a formula from one cell to another and the cell references in the formula
automatically update to reflect the new location, what type of cell references are being used?
A) Absolute Cell References
B) Mixed Cell References
C) Static Cell References
D) Dynamic Cell References
E) Relative Cell References
Correct Answer: E) Relative Cell References
Rationale: Relative cell references are the default in Excel. They are "relative" to the location
of the cell containing the formula. When you copy the formula, these references adjust
automatically, which is efficient for applying the same calculation across multiple rows or
columns.
Question 5
What is a cell reference that remains constant when a formula is pasted into a new cell and is
identified by the inclusion of two dollar signs ($)?
,A) An Absolute Cell Reference
B) A Relative Cell Reference
C) A Mixed Cell Reference
D) A Dynamic Cell Reference
E) A Static Cell Reference
Correct Answer: A) An Absolute Cell Reference
Rationale: An absolute cell reference, such as $A$1, locks the reference to a specific cell. The
two dollar signs fix both the column (A) and the row (1). This is crucial when a formula must
always refer to a single, constant cell, such as a tax rate or a commission percentage, no
matter where the formula is copied.
Question 6
A cell reference in a formula that has one part fixed (absolute) and one part that can change
(relative), such as $A1 or A$1, is known as what?
A) A Relative Reference
B) An Absolute Reference
C) A Dynamic Reference
D) A Static Reference
E) A Mixed Reference
Correct Answer: E) A Mixed Reference
Rationale: A mixed reference combines both absolute and relative referencing. $A1 locks the
column but allows the row to change when the formula is copied, while A$1 locks the row but
allows the column to change. This is useful for creating tables where calculations refer to both
a specific row and a specific column header.
Question 7
The calculations performed in a spreadsheet, which typically begin with an equals sign (=), are
known as what?
A) Functions
B) Formulas
, C) Arguments
D) Syntax
E) Algorithms
Correct Answer: B) Formulas
Rationale: A formula is an expression that operates on values in a range of cells. It is a user-
defined calculation. While a formula can contain functions (pre-built calculations like SUM or
AVERAGE), the term "formula" refers to the entire calculation string starting with the equals
sign.
Question 8
When a formula in a cell references other cells and its result automatically updates in response
to changes in the values of those referenced cells, the formula is described as what?
A) Static
B) Absolute
C) Relative
D) Dynamic
E) Audited
Correct Answer: D) Dynamic
Rationale: A dynamic formula creates a live link between cells. Its power lies in its ability to
change its output automatically whenever the input data changes, making the spreadsheet
interactive and efficient. A static formula, by contrast, does not change.
Question 9
If you enter =5+10 into a cell, the result will always be 15, regardless of the values in other cells.
What term describes this type of formula?
A) Dynamic
B) Relative
C) Static
D) Absolute
E) Corrupt
