WGU D100 BASICS FOR EXCEL WITH VERIFIED
ANSWERS RATED A+
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
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
, 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)
Years since
=YEARFRAC(J27,J21)
Days since last
=DATEDIF(J21,J27,"D")
PEDMAS
ANSWERS RATED A+
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
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
, 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)
Years since
=YEARFRAC(J27,J21)
Days since last
=DATEDIF(J21,J27,"D")
PEDMAS
