D100 WGU (EXCEL BASICS)
1. Tabs
Answer Eight areas of activity on the Ribbon that contain groups or collections of related commands.
2. Why should you not duplicate column headings?
Answer Duplicate headings make it diflcult to
understand the data stored in the column.
3. What is the total row used for in an Excel table?
Answer Summarize values in the table
4. What automatically applies a formula used in one cell to the remaining cells
in a column?
Answer Calculated columns
1/
10
, 5. What kind of calculation contains an error caused by poor input?
Answer A calculation that
includes inaccurate or incomplete data
6. What kind of calculation contains an error caused by poor logic?
Answer A calculation that includes an inaccurate or incomplete
7. qualative data
Answer descriptive data
8. Dynamic Function
Answer A dynamic function changes when the values in the cells it references change.
9. Quantitive data
Answer numerical data
10. Year
2/
10
1. Tabs
Answer Eight areas of activity on the Ribbon that contain groups or collections of related commands.
2. Why should you not duplicate column headings?
Answer Duplicate headings make it diflcult to
understand the data stored in the column.
3. What is the total row used for in an Excel table?
Answer Summarize values in the table
4. What automatically applies a formula used in one cell to the remaining cells
in a column?
Answer Calculated columns
1/
10
, 5. What kind of calculation contains an error caused by poor input?
Answer A calculation that
includes inaccurate or incomplete data
6. What kind of calculation contains an error caused by poor logic?
Answer A calculation that includes an inaccurate or incomplete
7. qualative data
Answer descriptive data
8. Dynamic Function
Answer A dynamic function changes when the values in the cells it references change.
9. Quantitive data
Answer numerical data
10. Year
2/
10
