Sunday, February 13, 2011

MS Excel Instructions


Putting In Titles
1. Start up Excel. A blank spreadsheet page will appear. Click on the top left cell (rectangle) and type 'Quarterly Expenses.' This cell is cell A1. To the right is cell B1 and below it is cell A2. Note that when you click on a cell, the column letter and row number are highlighted and the cell number shows in the area above column A.
2. Click on cell B2 to create a column title. Type 'Jan.' Click on cell B3 and type 'Feb.' Click on cell B4 and type 'Mar.' Click on cell B5 and type 'Total.' Click on cell B6 and type 'Monthly Average.'
3. Click on cell A3 to create a row title. Type 'Medical.' Click on cell A4 and type 'Utilities.' Click on cell A5 and type 'Other.' Click on cell A6 and type 'Total.'
Adding Data
4. Click on cell B3 and type in the amount of January medical expenses. You do not have to use a dollar sign, just type in an amount like 123.56. Click on cells C3 and D3 and add medical expenses for February and March.
5. Click on cells B4, C4 and D4 and enter utility expenses for January, February and March.
6. Click on cells B5, C5 and D5 and enter Other expenses for January, February and March.
Adding Formulas
7. Click on cell B6 and type the following: =sum(B3:B5) and hit 'Enter.' The total for the January expenses should now show in the cell. If you click on the cell, the formula will show in the white area above the spreadsheet.
8. Click cell B6 and drag your mouse across to cell D6 and type CTRL-R (copy right). This will copy the formula to the other two cells, adjusting the cell references automatically. The totals for February and March should appear.
9. Click cell E3 and type =sum(B3:D3) and hit 'Enter.' The quarterly sum for medical expenses should appear.
10. Click cell E3 and drag the mouse down to cell E6 and type CTRL-D (copy down). The formula will be copied down to the other cells including cell D6 which now shows total quarterly expenses.
11. Click on cell F3 and type =average(B3:D3) and hit 'Enter.' This cell will now show the average monthly medical expenses for the quarter. Click on cell F3 and drag the mouse down to cell F6 and type CTRL-D to copy the average formula down to the other rows.
Formatting Cells
12. Click on cell A1 and drag the mouse to cell F6. This will highlight the whole spreadsheet. From the Format menu select 'Cells...' On the Number tab select 'Currency.' In the Symbol: box select '$.' Click 'OK.' All your numeric cells will now show with a dollar sign and two decimal places.
13. Click the 'A' at the top of Column A to highlight the entire column. From the Format menu select 'Cells...' Select the Font tab. Select 'Bold' under font style and click 'OK.'
14. Click on the '2' at the left of row 2 to highlight the entire row. From the Format menu select 'Cells...' Select the Font tab. Select 'Bold' under font style and click 'OK.' Now your column and row titles are in bold. You can select cell A1 and change the font size and style for the title if you wish.

Blogger news