Summarize Data with Subtotals
Über den Vortrag
Der Vortrag „Summarize Data with Subtotals“ von Sonic Performance ist Bestandteil des Kurses „Working with Lists in Excel 2016 (EN)“.
Quiz zum Vortrag
What is the primary difference between filtering and sorting?
- Sorting rearranges entries while filtering removes entries from view.
- A worksheet can be saved in a sorted state but not in a filtered state.
- Filtering affects the original data while sorting leaves it intact.
- Filtering is only possible in tables.
What do the Subtotals feature and summary functions have in common?
- They both use SUBTOTAL functions to perform calculations.
- They both work on both tables and ranges.
- Neither of them work on either tables or ranges.
- They are both types of database functions.
Database functions are setup the same way as advanced filters.
- True
- False
Which statements are true regarding sorting?
- You can sort data ranges by rows or columns.
- You can sort data based on numeric values, alphabetically, and chronologically.
- Sorting alters your original data.
- You can sort on only one column at a time.
Diese Kurse könnten Sie interessieren
Dozent des Vortrages Summarize Data with Subtotals
Sonic Performance
Sonic Performance Support is a provider of web-based video learning solutions in multiple languages for consumers, corporations of every size, associations and educational institutions.
All videos can be accessed instantly from any computer or mobile device via any browser and come with a human touch. Experienced trainers guide you step-by-step through the software features.
Kundenrezensionen
5,0 von 5 Sternen
| 5 Sterne |
|
5 |
| 4 Sterne |
|
0 |
| 3 Sterne |
|
0 |
| 2 Sterne |
|
0 |
| 1 Stern |
|
0 |
