Select the category you are sorting (i.e. budget category). Selecting ascending and my data range has a header row.
Move the cursor to the cell that you would like the formula in and hit enter.
| To calculate the sum of the numbers in a column or row: | |
|
| To sort items in a spreadsheet: | Highlight all of the entries in your spreadsheet.
Click Data on the tool bar and then select sort. Select the category you are sorting (i.e. budget category). Selecting ascending and my data range has a header row. |
|
| To automatically calculate the total with sales tax: | Enter the following formula into cell D2: C2*1.0925 and hit enter | |
| To copy formulas into other cells | Click on the cell with the formula you would like to
copy and Click Edit from the toolbar and then copy. Move the cursor to the cell that you would like the formula in and hit enter. |
|