WGU D100 (Excel Basics)-with 100%solutions-2024-
2025
, Tabs
Eight areas of activity on the Ribbon that contain groups or collections of related commands.
Why should you not duplicate column headings?
Duplicate headings make it difficult to understand the data stored in the column.
What is the total row used for in an Excel table? Summarize
values in the table
What automatically applies a formula used in one cell to the remaining cells in a column? Calculated
columns
What kind of calculation contains an error caused by poor input? A
calculation that includes inaccurate or incomplete data
What kind of calculation contains an error caused by poor logic? A
calculation that includes an inaccurate or incomplete
qualative data
descriptive data
Dynamic Function
A dynamic function changes when the values in the cells it references change.
Quantitive data
numerical data
Year
=YEAR(J21)
Todays Date
=TODAY()
Month
=MONTH(J21)
2025
, Tabs
Eight areas of activity on the Ribbon that contain groups or collections of related commands.
Why should you not duplicate column headings?
Duplicate headings make it difficult to understand the data stored in the column.
What is the total row used for in an Excel table? Summarize
values in the table
What automatically applies a formula used in one cell to the remaining cells in a column? Calculated
columns
What kind of calculation contains an error caused by poor input? A
calculation that includes inaccurate or incomplete data
What kind of calculation contains an error caused by poor logic? A
calculation that includes an inaccurate or incomplete
qualative data
descriptive data
Dynamic Function
A dynamic function changes when the values in the cells it references change.
Quantitive data
numerical data
Year
=YEAR(J21)
Todays Date
=TODAY()
Month
=MONTH(J21)
