Hiding Rows and Columns

1. Click to highlight the row(column) you would like to hide.
2. Go to Format, row(column) and click hide.
3. Notice how the row(column) is hidden.

Unhide Row or Column

Using Functions - Ready to use formulas

• A function always begins with an equal sign.
• The data Excel will use to calculate the function is enclosed in parenthesis.

• When there is a comma (,) between cell references, in a function, Excel uses each cell to perform the calculation.

Example: =Sum(A1,A3) is the same as =A1+A3

• When there is a colon : between cell references in a function, Excel uses the displayed cells and all the cells between them to perform the calculation.

Example: =Sum(A1:A3) is the same as =A1+A2=A3

Function Wizard

1. Click the cell you want to place the function.
1. Click the Function Wizard button on the toolbar.
1. Click the function category and function name.
1. At the next dialog box, move the window so that you can see the worksheet.
1. Click the cell that contains the first number to calculate. Press tab to select second number and so forth. Click finish when all numbers are used and see your calculation in the cell you place your function.

Using Autocalculate

1. Select the cells that contain the number you would like to calculate.
1. The area at the bottom automatically displays the number that you have calculated.
1. Right click to display the result of a different calculation. Move the mouse over this area and press the right button to make the selection.