D100 WGU (Excel
Basics)
1. Tabs: Eight areas of activity on the Ribbon that contain groups or collections of related commands.
2. Why should you not duplicate column headings?: Duplicate headings make it difficult to understand the data
stored in the column.
3. What is the total row used for in an Excel table?: Summarize values in the table
4. What automatically applies a formula used in one cell to the remaining cells in a column?: Calculated columns
5. What kind of calculation contains an error caused by poor input?: A calcu- lation that includes inaccurate or
incomplete data
6. What kind of calculation contains an error caused by poor logic?: A calcu- lation that includes an inaccurate or
incomplete
7. qualative data: descriptive data
8. Dynamic Function: A dynamic function changes when the values in the cells it references change.
9. Quantitive data: numerical data
10.Year: =YEAR(J21)
11.Todays Date: =TODAY()
12. =MONTH(J21)
Month:
13. =YEARFRAC(J27,J21)
Years since:
14.Days since last: =DATEDIF(J21,J27,"D")
1/
3
Basics)
1. Tabs: Eight areas of activity on the Ribbon that contain groups or collections of related commands.
2. Why should you not duplicate column headings?: Duplicate headings make it difficult to understand the data
stored in the column.
3. What is the total row used for in an Excel table?: Summarize values in the table
4. What automatically applies a formula used in one cell to the remaining cells in a column?: Calculated columns
5. What kind of calculation contains an error caused by poor input?: A calcu- lation that includes inaccurate or
incomplete data
6. What kind of calculation contains an error caused by poor logic?: A calcu- lation that includes an inaccurate or
incomplete
7. qualative data: descriptive data
8. Dynamic Function: A dynamic function changes when the values in the cells it references change.
9. Quantitive data: numerical data
10.Year: =YEAR(J21)
11.Todays Date: =TODAY()
12. =MONTH(J21)
Month:
13. =YEARFRAC(J27,J21)
Years since:
14.Days since last: =DATEDIF(J21,J27,"D")
1/
3
