Page 8 - Ms Excel Note and Workbook
P. 8
Formatting Cells ....................................................................................................................... 50
Change The Font Size ............................................................................................................... 50
Change The Font ...................................................................................................................... 51
To Use the Bold, Italic, and Underline Commands: ................................................................. 53
Cell Borders And Fill Colors ...................................................................................................... 53
Cell Styles ................................................................................................................................. 55
Text Alignment ......................................................................................................................... 57
Understanding Number Formats ............................................................................................. 58
Applying Number Formats ....................................................................................................... 58
Percentage Formats ................................................................................................................. 60
Date Formats ............................................................................................................................ 61
Number Formatting Tips .......................................................................................................... 64
Increase and Decrease Decimal ............................................................................................... 65
6 PAGE LAYOUT AND PRINTING ................................................................................................ 66
Choosing A Print Area .............................................................................................................. 68
Adjusting Content .................................................................................................................... 72
7 FORMULAS AND FUNCTIONS ................................................................................................. 80
Intro to Formulas ..................................................................................................................... 80
Mathematical Operators .......................................................................................................... 80
Modifying Values with Cell References .................................................................................... 84
Copying Formulas with The Fill Handle .................................................................................... 86
Edit a Formula .......................................................................................................................... 86
8 CREATING MORE COMPLEX FORMULAS ................................................................................. 88
Creating Complex Formulas ..................................................................................................... 88
9 RELATIVE & ABSOLUTE CELL REFERENCES ............................................................................... 91
Introduction ............................................................................................................................. 91
Create and Copy a Formula Using Relative References ........................................................... 91
Absolute References ................................................................................................................ 93
10 FUNCTIONS ........................................................................................................................... 98
Introduction ............................................................................................................................. 98
The Parts of a Function ............................................................................................................ 98
Working with Arguments ......................................................................................................... 98
Creating a Function .................................................................................................................. 99
The Function Library .............................................................................................................. 104
The Insert Function Command ............................................................................................... 107
Freezing rows and columns .................................................................................................... 110