WGU D388 OA Exam | Spreadsheets & Data Presentations (2026)
Q&A | WGU
1. In Microsoft Excel, what is the intersection of a column and a row called?
A) A range
B) A cell
C) A worksheet
D) A workbook
Correct Answer: A cell
Rationale: A cell is the fundamental unit of a worksheet, defined by the intersection of a
column letter and a row number. Each cell has a unique address, such as A1 or B2, which is
used to reference it in formulas and functions.
2. An Excel file that contains one or more worksheets is known as a:
A) Cell
B) Range
C) Workbook
D) Table
Correct Answer: Workbook
Rationale: A workbook is the entire Excel file that stores all data, calculations, and analyses.
It must contain at least one worksheet, which is the individual spreadsheet where data is
entered and manipulated.
3. Which Excel feature is used to organize data into a structured format with banded rows
and automatic totals?
A) PivotTable
B) Table
,C) Chart
D) Range
Correct Answer: Table
Rationale: Excel Tables provide a structured way to organize data, with features like banded
rows, calculated columns, and a Total Row that automatically displays aggregate functions
like sum or average.
4. What is the primary function of the "Home" tab in the Excel ribbon?
A) To insert charts and pictures
B) To format the appearance of data in cells
C) To perform calculations using built-in functions
D) To manage workbook sharing and review
Correct Answer: To format the appearance of data in cells
Rationale: The Home tab contains groups of menu items used to format the appearance of
data in cells, such as font style, alignment, number formats, and cell styles.
5. Which of the following is a built-in method for performing a calculation in Excel?
A) A formula
B) A function
C) An expression
D) A macro
Correct Answer: A function
Rationale: A function is a predefined, built-in method for performing a specific calculation in
Excel. Examples include SUM, AVERAGE, and COUNT, which simplify complex calculations.
6. A cell reference that stays fixed when a formula is copied to another cell is called a(n):
,A) Relative reference
B) Absolute reference
C) Mixed reference
D) Dynamic reference
Correct Answer: Absolute reference
Rationale: An absolute reference is a cell reference that remains constant when a formula is
copied. It is denoted by dollar signs (e.g., $A$1) and is used when you want a formula to
always refer to the same cell.
7. What is the function of the "Insert" tab in the Excel ribbon?
A) To format data in cells
B) To add specialized elements like charts, pictures, and shapes
C) To perform data analysis with PivotTables
D) To review and share workbooks
Correct Answer: To add specialized elements like charts, pictures, and shapes
Rationale: The Insert tab provides features for adding specialized elements into workbooks,
such as charts, pictures, shapes, and PivotTables.
8. Which of the following is NOT a valid data type in Excel?
A) Number
B) Text
C) Date
D) Image
Correct Answer: Image
, Rationale: While images can be inserted into a worksheet, they are not a fundamental data
type stored in a cell. Excel's core data types include numbers, text, dates, times, and Boolean
values.
9. What does the COUNT function do in Excel?
A) It calculates the average of a dataset
B) It counts the number of cells that contain numbers
C) It counts the number of non-blank cells
D) It sums the values in a range
Correct Answer: It counts the number of cells that contain numbers
Rationale: The COUNT function counts the number of cells in a range that contain numeric
values. It does not count cells with text, logical values, or errors.
10. What does the COUNTA function do in Excel?
A) It counts the number of cells that contain any value (non-blank cells)
B) It counts the number of cells that contain numbers
C) It calculates the average of a dataset
D) It counts the number of blank cells
Correct Answer: It counts the number of cells that contain any value (non-blank cells)
Rationale: The COUNTA function counts the number of cells in a range that are not empty,
regardless of the type of data they contain, such as text, numbers, or logical values.
11. Which function calculates the simple average of a dataset?
A) SUM
B) AVERAGE
C) COUNT
D) MAX
Q&A | WGU
1. In Microsoft Excel, what is the intersection of a column and a row called?
A) A range
B) A cell
C) A worksheet
D) A workbook
Correct Answer: A cell
Rationale: A cell is the fundamental unit of a worksheet, defined by the intersection of a
column letter and a row number. Each cell has a unique address, such as A1 or B2, which is
used to reference it in formulas and functions.
2. An Excel file that contains one or more worksheets is known as a:
A) Cell
B) Range
C) Workbook
D) Table
Correct Answer: Workbook
Rationale: A workbook is the entire Excel file that stores all data, calculations, and analyses.
It must contain at least one worksheet, which is the individual spreadsheet where data is
entered and manipulated.
3. Which Excel feature is used to organize data into a structured format with banded rows
and automatic totals?
A) PivotTable
B) Table
,C) Chart
D) Range
Correct Answer: Table
Rationale: Excel Tables provide a structured way to organize data, with features like banded
rows, calculated columns, and a Total Row that automatically displays aggregate functions
like sum or average.
4. What is the primary function of the "Home" tab in the Excel ribbon?
A) To insert charts and pictures
B) To format the appearance of data in cells
C) To perform calculations using built-in functions
D) To manage workbook sharing and review
Correct Answer: To format the appearance of data in cells
Rationale: The Home tab contains groups of menu items used to format the appearance of
data in cells, such as font style, alignment, number formats, and cell styles.
5. Which of the following is a built-in method for performing a calculation in Excel?
A) A formula
B) A function
C) An expression
D) A macro
Correct Answer: A function
Rationale: A function is a predefined, built-in method for performing a specific calculation in
Excel. Examples include SUM, AVERAGE, and COUNT, which simplify complex calculations.
6. A cell reference that stays fixed when a formula is copied to another cell is called a(n):
,A) Relative reference
B) Absolute reference
C) Mixed reference
D) Dynamic reference
Correct Answer: Absolute reference
Rationale: An absolute reference is a cell reference that remains constant when a formula is
copied. It is denoted by dollar signs (e.g., $A$1) and is used when you want a formula to
always refer to the same cell.
7. What is the function of the "Insert" tab in the Excel ribbon?
A) To format data in cells
B) To add specialized elements like charts, pictures, and shapes
C) To perform data analysis with PivotTables
D) To review and share workbooks
Correct Answer: To add specialized elements like charts, pictures, and shapes
Rationale: The Insert tab provides features for adding specialized elements into workbooks,
such as charts, pictures, shapes, and PivotTables.
8. Which of the following is NOT a valid data type in Excel?
A) Number
B) Text
C) Date
D) Image
Correct Answer: Image
, Rationale: While images can be inserted into a worksheet, they are not a fundamental data
type stored in a cell. Excel's core data types include numbers, text, dates, times, and Boolean
values.
9. What does the COUNT function do in Excel?
A) It calculates the average of a dataset
B) It counts the number of cells that contain numbers
C) It counts the number of non-blank cells
D) It sums the values in a range
Correct Answer: It counts the number of cells that contain numbers
Rationale: The COUNT function counts the number of cells in a range that contain numeric
values. It does not count cells with text, logical values, or errors.
10. What does the COUNTA function do in Excel?
A) It counts the number of cells that contain any value (non-blank cells)
B) It counts the number of cells that contain numbers
C) It calculates the average of a dataset
D) It counts the number of blank cells
Correct Answer: It counts the number of cells that contain any value (non-blank cells)
Rationale: The COUNTA function counts the number of cells in a range that are not empty,
regardless of the type of data they contain, such as text, numbers, or logical values.
11. Which function calculates the simple average of a dataset?
A) SUM
B) AVERAGE
C) COUNT
D) MAX
