Saturday, September 21, 2013

How to Use Microsoft Excel 2010


1. Start Microsoft Excel 2010.
2. Activate Excel over the Internet if prompted.
3. Click the top-left cell on the new blank spreadsheet, and type the number '25.'
4. Press 'Enter' to save the cell contents, and move to the next cell down the column.
5. Type the number '5' and press 'Enter.'
6. Press the 'Equal' sign ('='), and immediately click once on the cell that contains the number '25.'
7. Press the 'Plus' sign (' ') on the keyboard, and immediately click on the cell that contains the number '5' and press 'Enter.' Notice that the third cell now displays the sum of 25 5, or 30. The cell also contains a formula that is shown in the formula bar, which should look like '=A1 A2.'
8. Click in a blank cell.
9. Press the 'Equal' sign ('='), and immediately click once on the cell that contains the number '25.'
10. Press the 'Asterisk' symbol ('*') on the keyboard, and click on the cell that contains the number '5' and then press 'Enter.' Notice that the third cell now displays the answer of 25 x 5, or 125. The cell also contains a formula that is shown in the formula bar, which should look like '=A1*A2.'
11. Click on the cell that contains the number '25.'
12. Type the number '50,' and press 'Enter.' Notice that the two calculated cells automatically updated to reflect the new number.
13. Click on the first cell, and hold down the mouse button.
14. Drag the mouse across the remaining cells until all four cells are highlighted, and release the mouse button.
15. Click the 'Insert' tab on the toolbar, click 'Column' in the 'Charts' group, and to create a column chart of the data, click on the first chart in the context menu that pops up.
16. Click either the cell that contains the '50' or the cell that contains the '5,' and change it to another number and then press 'Enter.' Notice that the cells containing the totals and the chart all update to reflect the new values.

Blogger news