WGU D388
WGU D388 Fundamentals of Spreadsheets and Data
Presentations|Explore New 89 Questions and Answers|Extra Notes
Provided to Pass D388 Course|New Study tips 2026 with complete
solutions
Testbankscove
➢
➢
➢
➢
,Question 1
Definition: An option in the number format drop-down menu that defines any type of
number and can be configured to display the number in standardized ways.
A) Time
B) Number
C) Percentage
D) Date
Correct Answer: B) Number
Rationale: The "Number" format in spreadsheet software is the general category for
,numeric values, allowing standardization of decimal places, thousands separators, and
negative number display.
Question 2
Definition: The way values in a cell are positioned
A) Expression
B) Centering
C) Alignment
D) Filtering
Correct Answer: C) Alignment
Rationale: Alignment refers to the horizontal or vertical positioning of content within a
cell (left, center, right, top, bottom).
Question 3
Definition: Group of menu items used to perform calculations using Excel's built-in
functions
A) Formulas
B) Dynamic
C) Data
D) Count
Correct Answer: A) Formulas
Rationale: The Formulas tab in Excel contains Function Library, Defined Names, Formula
Auditing, and Calculation options.
Question 4
Definition: Group of menu items used to format the appearance of worksheets when
they are printed
A) Formula bar
, B) Date
C) Page layout
D) Window
Correct Answer: C) Page layout
Rationale: The Page Layout tab includes margins, orientation, size, print area, and
backgrounds.
Question 5
Definition: A function that counts the number of cells that have values, example, non-
blank cells
A) MAX
B) COUNTALL
C) COUNTIF
D) COUNTA
Correct Answer: D) COUNTA
Rationale: COUNTA counts all non-empty cells regardless of data type (numbers, text,
errors, logicals).
Question 6
Definition: Group of menu items that includes features for specializing elements into
workbooks, such as charts, pictures, and shapes
A) Help
B) Review
C) Insert
D) Select
Correct Answer: C) Insert
Rationale: The Insert tab contains Illustrations, Charts, Sparklines, Filters, and Links.
WGU D388 Fundamentals of Spreadsheets and Data
Presentations|Explore New 89 Questions and Answers|Extra Notes
Provided to Pass D388 Course|New Study tips 2026 with complete
solutions
Testbankscove
➢
➢
➢
➢
,Question 1
Definition: An option in the number format drop-down menu that defines any type of
number and can be configured to display the number in standardized ways.
A) Time
B) Number
C) Percentage
D) Date
Correct Answer: B) Number
Rationale: The "Number" format in spreadsheet software is the general category for
,numeric values, allowing standardization of decimal places, thousands separators, and
negative number display.
Question 2
Definition: The way values in a cell are positioned
A) Expression
B) Centering
C) Alignment
D) Filtering
Correct Answer: C) Alignment
Rationale: Alignment refers to the horizontal or vertical positioning of content within a
cell (left, center, right, top, bottom).
Question 3
Definition: Group of menu items used to perform calculations using Excel's built-in
functions
A) Formulas
B) Dynamic
C) Data
D) Count
Correct Answer: A) Formulas
Rationale: The Formulas tab in Excel contains Function Library, Defined Names, Formula
Auditing, and Calculation options.
Question 4
Definition: Group of menu items used to format the appearance of worksheets when
they are printed
A) Formula bar
, B) Date
C) Page layout
D) Window
Correct Answer: C) Page layout
Rationale: The Page Layout tab includes margins, orientation, size, print area, and
backgrounds.
Question 5
Definition: A function that counts the number of cells that have values, example, non-
blank cells
A) MAX
B) COUNTALL
C) COUNTIF
D) COUNTA
Correct Answer: D) COUNTA
Rationale: COUNTA counts all non-empty cells regardless of data type (numbers, text,
errors, logicals).
Question 6
Definition: Group of menu items that includes features for specializing elements into
workbooks, such as charts, pictures, and shapes
A) Help
B) Review
C) Insert
D) Select
Correct Answer: C) Insert
Rationale: The Insert tab contains Illustrations, Charts, Sparklines, Filters, and Links.
