Add Subtotals to Grouped Data
About the Lecture
The lecture Add Subtotals to Grouped Data by Sonic Performance is from the course Auditing Worksheets in Excel 2013. It contains the following chapters:
- Introduction to Subtotals
- Add Subtotals
- Summary
Included Quiz Questions
The best way to understand the relationships between formulas and the cells they reference is to use which of the following tools?
- Trace Cells
- Conditional Formatting
- Macros
- Solver
What types of errors can you find by using the Error Checking tool?
- Divide by 0
- Non-intersecting values
- Conditional formatting
- Data validation
True or False? You can find errors inside a complex formula by evaluating it step-by-step.
- True
- False
What options can be selected within the Outline group?
- Group
- Ungroup
- Subtotals
- Colors
Author of lecture Add Subtotals to Grouped Data
Sonic Performance
Customer reviews
5,0 of 5 stars
| 5 Stars |
|
5 |
| 4 Stars |
|
0 |
| 3 Stars |
|
0 |
| 2 Stars |
|
0 |
| 1 Star |
|
0 |
