Excel Basics:
Summary
|
|
Excel Basics:
|
|
|
|
||
|
Grouping similar data lets you create subtotals for each group. The data must be sorted first. You can sort on more than one column. A custom list can only be applied to the first column. Moving or inserting cells can scramble formulas. You can repair the broken formulas with AutoFill or by editing the cell references to include the new cells. |
|
Project 4: Groups & Formulas
Search Appendix |
|
What You Printed for Project 4: Groups & Formulas | |||
|
File and sheet |
What is it? |
# of pages |
||
|
1. |
trips23.xls - Agents Totals |
Subtotals with just subtotals displayed |
1 page |
|
|
2. |
trips28.xls - Specials |
Merged cells, repaired formulas |
1 page |
|
|
3. |
trips28.xls - Formatted Groups, Tahiti, New Zealand, World |
Repaired linked cells after changes to Specials |
4 pages |
|
|
4. |
trips30.xls - Specials (upper table only) | Inserted rows and repaired formulas | 1 page | |
|
Important Terms
~~ 1 Cor. 10:31 ...whatever you do, do it all for the glory of God. ~~ |
