Page 8 - Ms Excel Note and Workbook

Change The Font Size ............................................................................................................... 68

Change The Font ...................................................................................................................... 69
To Use the Bold, Italic, and Underline Commands: ................................................................. 72

Cell Borders And Fill Colors ...................................................................................................... 72
Cell Styles ................................................................................................................................. 75

Text Alignment ......................................................................................................................... 77
Understanding Number Formats ............................................................................................. 80
Applying Number Formats ....................................................................................................... 80

Percentage Formats ................................................................................................................. 82
Date Formats ............................................................................................................................ 83

Number Formatting Tips .......................................................................................................... 87
Increase and Decrease Decimal ............................................................................................... 89
6 PAGE LAYOUT AND PRINTING ........................................................................................................ 90

Choosing A Print Area .............................................................................................................. 93
Adjusting Content .................................................................................................................... 96

7 FORMULAS AND FUNCTIONS ........................................................................................................ 105
Intro to Formulas ................................................................................................................... 105

Mathematical Operators ........................................................................................................ 105
Modifying Values with Cell References .................................................................................. 109

Copying Formulas with The Fill Handle .................................................................................. 112
Edit a Formula ........................................................................................................................ 113
8 CREATING MORE COMPLEX FORMULAS ...................................................................................... 116

Creating Complex Formulas ................................................................................................... 116
9 RELATIVE & ABSOLUTE CELL REFERENCES .................................................................................... 119

Introduction ........................................................................................................................... 119
Create and Copy a Formula Using Relative References ......................................................... 119

Absolute References .............................................................................................................. 123
10 FUNCTIONS .................................................................................................................................... 132

Introduction ........................................................................................................................... 132
The Parts of a Function .......................................................................................................... 132
Working with Arguments ....................................................................................................... 132

Creating a Function ................................................................................................................ 133
The Function Library .............................................................................................................. 138

Lookup & Reference ............................................................................................................... 139
The Insert Function Command ............................................................................................... 144
Freezing rows and columns .................................................................................................... 147