WGU D100 – Introduction to
Spreadsheets Exam Final Exam Prep
(Latest Update ) Questions
and Verified Answers | 100% Correct |
Grade A.
1. Which spreadsheet feature is used to organize data into rows and
columns?
A. Slide layout
B. Worksheet
C. Text box
D. Presentation theme
Rationale: A worksheet is the primary grid-based workspace in a
spreadsheet application. It organizes information into rows and
columns, allowing users to enter, calculate, analyze, and format data
efficiently.
2. In a spreadsheet, what is the intersection of a row and a column
called?
A. Range
B. Formula
C. Cell
D. Workbook
,Rationale: A cell is formed where a row and column intersect. Each cell
has a unique address, such as A1, that identifies its location within the
worksheet.
3. Which cell reference identifies column C and row 7?
A. 7C
B. C-7
C. C7
D. C:7
Rationale: Spreadsheet cell references normally identify the column first
and the row second. Therefore, C7 refers to the cell in column C and row
7.
4. Which of the following is an example of a valid spreadsheet
formula?
A. SUM A1:A5
B. A1+A2
C. =A1+A2
D. A1=A2
Rationale: Spreadsheet formulas generally begin with an equals sign (=).
The formula =A1+A2 instructs the spreadsheet to add the values stored
in cells A1 and A2.
5. What is the primary purpose of a spreadsheet formula?
A. Change the worksheet's page orientation
B. Apply a font style
C. Perform a calculation or return a result
D. Rename the workbook
,Rationale: Formulas allow spreadsheets to calculate results dynamically.
When referenced values change, the spreadsheet can recalculate the
formula and update the result.
6. Which function is used to add a group of numbers?
A. COUNT
B. AVERAGE
C. MAX
D. SUM
Rationale: The SUM function adds numerical values together. For
example, =SUM(A1:A10) calculates the total of the numeric values in
cells A1 through A10.
7. What does the formula =AVERAGE(B2:B6) calculate?
A. The largest value in B2:B6
B. The number of values in B2:B6
C. The arithmetic mean of the values in B2:B6
D. The total of B2 and B6 only
Rationale: AVERAGE calculates the arithmetic mean by adding the
numeric values and dividing by the number of numeric values. The
range B2:B6 includes every cell from B2 through B6.
8. Which function returns the largest numerical value in a range?
A. MIN
B. LARGECOUNT
C. MAX
D. HIGH
, Rationale: The MAX function returns the highest numerical value in the
specified range. For example, =MAX(C2:C20) identifies the largest
number in cells C2 through C20.
9. Which function returns the smallest numerical value in a range?
A. LOW
B. MIN
C. SMALLER
D. BOTTOM
Rationale: The MIN function identifies the smallest numerical value in a
specified range. For example, =MIN(D2:D15) returns the lowest value
found in that range.
10. What does the colon in the reference A1:A10 represent?
A. Division
B. A comparison
C. A range of cells
D. A text separator
Rationale: A colon indicates a continuous range between two cell
references. A1:A10 includes A1, A2, A3, and every cell through A10.
11. Which of the following is an example of a relative cell
reference?
A. $A$1
B. $A1
C. A$1
D. A1
Spreadsheets Exam Final Exam Prep
(Latest Update ) Questions
and Verified Answers | 100% Correct |
Grade A.
1. Which spreadsheet feature is used to organize data into rows and
columns?
A. Slide layout
B. Worksheet
C. Text box
D. Presentation theme
Rationale: A worksheet is the primary grid-based workspace in a
spreadsheet application. It organizes information into rows and
columns, allowing users to enter, calculate, analyze, and format data
efficiently.
2. In a spreadsheet, what is the intersection of a row and a column
called?
A. Range
B. Formula
C. Cell
D. Workbook
,Rationale: A cell is formed where a row and column intersect. Each cell
has a unique address, such as A1, that identifies its location within the
worksheet.
3. Which cell reference identifies column C and row 7?
A. 7C
B. C-7
C. C7
D. C:7
Rationale: Spreadsheet cell references normally identify the column first
and the row second. Therefore, C7 refers to the cell in column C and row
7.
4. Which of the following is an example of a valid spreadsheet
formula?
A. SUM A1:A5
B. A1+A2
C. =A1+A2
D. A1=A2
Rationale: Spreadsheet formulas generally begin with an equals sign (=).
The formula =A1+A2 instructs the spreadsheet to add the values stored
in cells A1 and A2.
5. What is the primary purpose of a spreadsheet formula?
A. Change the worksheet's page orientation
B. Apply a font style
C. Perform a calculation or return a result
D. Rename the workbook
,Rationale: Formulas allow spreadsheets to calculate results dynamically.
When referenced values change, the spreadsheet can recalculate the
formula and update the result.
6. Which function is used to add a group of numbers?
A. COUNT
B. AVERAGE
C. MAX
D. SUM
Rationale: The SUM function adds numerical values together. For
example, =SUM(A1:A10) calculates the total of the numeric values in
cells A1 through A10.
7. What does the formula =AVERAGE(B2:B6) calculate?
A. The largest value in B2:B6
B. The number of values in B2:B6
C. The arithmetic mean of the values in B2:B6
D. The total of B2 and B6 only
Rationale: AVERAGE calculates the arithmetic mean by adding the
numeric values and dividing by the number of numeric values. The
range B2:B6 includes every cell from B2 through B6.
8. Which function returns the largest numerical value in a range?
A. MIN
B. LARGECOUNT
C. MAX
D. HIGH
, Rationale: The MAX function returns the highest numerical value in the
specified range. For example, =MAX(C2:C20) identifies the largest
number in cells C2 through C20.
9. Which function returns the smallest numerical value in a range?
A. LOW
B. MIN
C. SMALLER
D. BOTTOM
Rationale: The MIN function identifies the smallest numerical value in a
specified range. For example, =MIN(D2:D15) returns the lowest value
found in that range.
10. What does the colon in the reference A1:A10 represent?
A. Division
B. A comparison
C. A range of cells
D. A text separator
Rationale: A colon indicates a continuous range between two cell
references. A1:A10 includes A1, A2, A3, and every cell through A10.
11. Which of the following is an example of a relative cell
reference?
A. $A$1
B. $A1
C. A$1
D. A1
