MCS

You can quickly calculate a formula based on a group cells without actually putting the formula into your spreadsheet.  You can quickly see the results of an Average, Count, Numerical Count, Min, Max, and Sum, etc. for a range of cells without writing the formula using a tool called AutoCalculate.

1. Select a range of cells [...]

Tired of squinting to read your screen?  You can change the size of any document, spreadsheet, etc. quickly in Office applications.

1. Hold down your Ctrl key on your keyboard as you roll your trackball on your mouse.
2. Rolling your trackball up will make your screen zoom in, and rolling it down will zoom out.

Â
Click here [...]

Absolute references refer to cells by their fixed position in the worksheet.  This distinction is important because when you start copying and pasting formulas from one location to another in the worksheet, relative references adjust automatically, while absolute references do not.  To identify a cell as an Absolute Reference in a formula, you need to [...]