,WGU D388 – Fundamentals of Spreadsheets and Data Presentations
| Actual study Questions and Answers + Expert Rationales | 2026
Updates | 100% correct
1. What is a workbook in Excel?
A. A single spreadsheet within a file
B. An Excel file that stores all information, previous calculations, and analyses; must contain at
least one worksheet
C. A collection of cells arranged in a table
D. A formatting tool for data presentation
Correct Answer: B
Expert Rationale:
A workbook is the entire Excel file that contains one or more worksheets. It stores all the
information, calculations, and analyses you have completed. A workbook can be stored locally
or in cloud storage such as Microsoft OneDrive.
2. What is a worksheet?
A. An Excel file containing multiple workbooks
B. A collection of cells arranged in columns and rows that contains the actual data and
calculations
C. A single cell within a spreadsheet
D. A formatting option for data presentation
Correct Answer: B
Expert Rationale:
A worksheet is a collection of cells arranged in the form of a table that contains the actual data
and calculations . Data on a worksheet is organized as a collection of cells .
3. What is a cell in a worksheet?
,A. A small box that stores an individual piece of data or a calculation in a worksheet
B. A collection of data arranged in rows
C. The entire worksheet
D. A formatting tool for data
Correct Answer: A
Expert Rationale:
A cell is a small box that stores an individual piece of data or a calculation in a worksheet . A
worksheet will also include the analyses you have done on this data, and the data on a
worksheet is organized as a collection of cells .
4. What is a value in a spreadsheet?
A. The cell address of a specific location
B. The content within a cell
C. The formula used for calculation
D. The formatting applied to a cell
Correct Answer: B
Expert Rationale:
The content within a cell is referred to as a value . A value can be text, a number, a date, or any
other type of data entered into a cell.
5. What is a column in a worksheet?
A. A collection of cells arranged horizontally from left to right
B. A stack of cells arranged vertically from the top to the bottom of a worksheet, labeled with a
letter
C. A single cell within a row
D. A formatting tool for data
Correct Answer: B
Expert Rationale:
A column is a stack of cells arranged vertically from the top to the bottom of a worksheet and is
labeled with a letter .
6. What is a row in a worksheet?
, A. A stack of cells arranged vertically, labeled with a letter
B. A collection of cells arranged horizontally from left to right, labeled with a number
C. A single cell within a column
D. A formatting tool for data
Correct Answer: B
Expert Rationale:
A row is a collection of cells arranged horizontally from left to right of a worksheet and is
labeled with a number .
7. Which naming convention is used for cells in spreadsheets?
A. Row number and cell content
B. Column letter and row number
C. Cell content only
D. Random identifiers
Correct Answer: B
Expert Rationale:
The naming convention used for cells in spreadsheets is the column letter and row number . For
example, cell A1 is at the intersection of column A and row 1.
8. What is a range in Excel?
A. A single cell with formatting
B. A consecutive block of cells arranged in a row, a column, or a combination of both
C. The entire worksheet
D. A formatting tool for data
Correct Answer: B
Expert Rationale:
A range is a consecutive block of cells arranged in a row, a column, or a combination of both .
For example, A1:B3 is the range of cells that includes A1, A2, A3, B1, B2, and B3 .
9. What is a function in Excel?
| Actual study Questions and Answers + Expert Rationales | 2026
Updates | 100% correct
1. What is a workbook in Excel?
A. A single spreadsheet within a file
B. An Excel file that stores all information, previous calculations, and analyses; must contain at
least one worksheet
C. A collection of cells arranged in a table
D. A formatting tool for data presentation
Correct Answer: B
Expert Rationale:
A workbook is the entire Excel file that contains one or more worksheets. It stores all the
information, calculations, and analyses you have completed. A workbook can be stored locally
or in cloud storage such as Microsoft OneDrive.
2. What is a worksheet?
A. An Excel file containing multiple workbooks
B. A collection of cells arranged in columns and rows that contains the actual data and
calculations
C. A single cell within a spreadsheet
D. A formatting option for data presentation
Correct Answer: B
Expert Rationale:
A worksheet is a collection of cells arranged in the form of a table that contains the actual data
and calculations . Data on a worksheet is organized as a collection of cells .
3. What is a cell in a worksheet?
,A. A small box that stores an individual piece of data or a calculation in a worksheet
B. A collection of data arranged in rows
C. The entire worksheet
D. A formatting tool for data
Correct Answer: A
Expert Rationale:
A cell is a small box that stores an individual piece of data or a calculation in a worksheet . A
worksheet will also include the analyses you have done on this data, and the data on a
worksheet is organized as a collection of cells .
4. What is a value in a spreadsheet?
A. The cell address of a specific location
B. The content within a cell
C. The formula used for calculation
D. The formatting applied to a cell
Correct Answer: B
Expert Rationale:
The content within a cell is referred to as a value . A value can be text, a number, a date, or any
other type of data entered into a cell.
5. What is a column in a worksheet?
A. A collection of cells arranged horizontally from left to right
B. A stack of cells arranged vertically from the top to the bottom of a worksheet, labeled with a
letter
C. A single cell within a row
D. A formatting tool for data
Correct Answer: B
Expert Rationale:
A column is a stack of cells arranged vertically from the top to the bottom of a worksheet and is
labeled with a letter .
6. What is a row in a worksheet?
, A. A stack of cells arranged vertically, labeled with a letter
B. A collection of cells arranged horizontally from left to right, labeled with a number
C. A single cell within a column
D. A formatting tool for data
Correct Answer: B
Expert Rationale:
A row is a collection of cells arranged horizontally from left to right of a worksheet and is
labeled with a number .
7. Which naming convention is used for cells in spreadsheets?
A. Row number and cell content
B. Column letter and row number
C. Cell content only
D. Random identifiers
Correct Answer: B
Expert Rationale:
The naming convention used for cells in spreadsheets is the column letter and row number . For
example, cell A1 is at the intersection of column A and row 1.
8. What is a range in Excel?
A. A single cell with formatting
B. A consecutive block of cells arranged in a row, a column, or a combination of both
C. The entire worksheet
D. A formatting tool for data
Correct Answer: B
Expert Rationale:
A range is a consecutive block of cells arranged in a row, a column, or a combination of both .
For example, A1:B3 is the range of cells that includes A1, A2, A3, B1, B2, and B3 .
9. What is a function in Excel?
