Beginning to Intermediate Excel
About This Book
7 3.1 More on Formulas and Functions Learning Objectives - Review the use of the =MAX function. - Examine the Quick Analysis Tool to create standard calculations, formatting, and charts very quickly. - Create Percentage calculation. – Use the Smart Lookup tool to acquire additional information about percentage calculations. – Review the use of Absolute cell reference in a division formula. Another use for =MAX Before we move on to the more interesting calculations we will be discussing in this c
| Category | general |
|---|---|
| Subject | Secretarial, clerical and office skills |
| Year | 2023 |
| Authors | |
| Chapters | 10 |
| Word Count | |
| Price | |
| License | Creative Commons - Attribution - https://creativecommons.org/licenses/by/4.0/ |
Chapters
- 7 3.1 More on Formulas and Functions
- 11 3.5 Chapter Practice
- 12 3.6 Chapter Scored
- 13 3 Advanced – Advanced Formulas, Functions and Macros
- An effective way to communicate findings in Excel is by graphing data. Graph the
- 26 5.1 Table Basics
- 28 5.3 Preparing to Print
- 29 5.4 Chapter Practice
- 30 5.5 Scored Assessment
- 33 6.3 Templates