D100 WGU (Excel Basics) Study Guide | 2025/2026 | Approved !!
Eight areas of activity on the Ribbon
that contain groups or collections
Tabs
of related commands.
Why should you not duplicate Duplicate headings make it difficult to understand the data stored in
column headings? the column.
, What is the total row used for in Summarize values in the table
an Excel table?
What automatically applies a Calculated columns
formula used in one cell to
the remaining cells in a
column?
What kind of calculation contains A calculation that includes inaccurate or incomplete data
an error caused by poor input?
What kind of calculation contains A calculation that includes an inaccurate or incomplete
an error caused by poor logic?
qualative data descriptive data
Dynamic Function A dynamic function changes when the values in the cells it references
change.
Quantitive data numerical data
=YEAR(J21)
Year
=TODAY()
Todays Date
=MONTH(J21)
Month
=YEARFRAC(J27,J21)
Years since
=DATEDIF(J21,J27,"D")
Days since last
parentheses, exponents, multiplication, division, addition,
PEDMAS and subtraction. Multiplication/division and
addition/subtraction go together, do whichever comes first.
Active Cell The cell in the worksheet in which you can type data.
Descending Order In order from the highest value to the lowest. e.g. 9-1 or Z-A.
Ascending Order In order from the lowest value to the highest. e.g. 1-9 or A-Z.
A strip of icons that appears across
the top of the Excel; divided into
Ribbon
tabs, each of which contains
groups of related tools.
Eight areas of activity on the Ribbon
that contain groups or collections
Tabs
of related commands.
Why should you not duplicate Duplicate headings make it difficult to understand the data stored in
column headings? the column.
, What is the total row used for in Summarize values in the table
an Excel table?
What automatically applies a Calculated columns
formula used in one cell to
the remaining cells in a
column?
What kind of calculation contains A calculation that includes inaccurate or incomplete data
an error caused by poor input?
What kind of calculation contains A calculation that includes an inaccurate or incomplete
an error caused by poor logic?
qualative data descriptive data
Dynamic Function A dynamic function changes when the values in the cells it references
change.
Quantitive data numerical data
=YEAR(J21)
Year
=TODAY()
Todays Date
=MONTH(J21)
Month
=YEARFRAC(J27,J21)
Years since
=DATEDIF(J21,J27,"D")
Days since last
parentheses, exponents, multiplication, division, addition,
PEDMAS and subtraction. Multiplication/division and
addition/subtraction go together, do whichever comes first.
Active Cell The cell in the worksheet in which you can type data.
Descending Order In order from the highest value to the lowest. e.g. 9-1 or Z-A.
Ascending Order In order from the lowest value to the highest. e.g. 1-9 or A-Z.
A strip of icons that appears across
the top of the Excel; divided into
Ribbon
tabs, each of which contains
groups of related tools.
