Steps to Creating a Spreadsheet in Microsoft Excel by mro72277

VIEWS: 0 PAGES: 1

									               Steps to Creating a Spreadsheet in Microsoft Excel

1.  To create a spreadsheet in Microsoft Excel, click on Start.
2.  Click on All Programs
3.  Click on Microsoft Office
4.  Click on Microsoft Office Excel
5.  If the Getting Started task pane is opened, close it by clicking on the X.
6.  In Excel, columns are labeled with letters and rows are labeled with
    numbers. These letters and numbers make up the cell address. (For
    example, A1.)
7. Data may be input into the spreadsheet by clicking in the appropriate cell
    and typing in the data. (The tab key, the arrow keys or the mouse may be
    used to move from cell to cell in a spreadsheet.)
8. To perform calculations (for example, average, sum, etc.) within a
    spreadsheet, click on Insert in the toolbar, click on function, choose the
    appropriate function, and click OK. (Make sure the cell addresses in the
    range are correct.)
9. To apply a function to a number of entries at once, highlight the cell which
    contains the function and drag down to the last entry. Then click on Edit in
    the toolbar, click on Fill, and the click on Down.
10. To format the type of number, highlight the cells containing the numbers to
    be formatted and right click. Click on Format Cells, choose the appropriate
    category and the # of decimal places, and then click OK.
11. To format cells, highlight the cells and use the appropriate buttons in the
    toolbar. (For example - center, bold, etc.)
12. To make a column wider, click on the line between column headings and
    drag.
13. To save the spreadsheet, click on File and save as. Type in a filename and
    click save.
14. To change font type, highlight the cells containing the font and choose the
    font type and size from the toolbar.
15. To close the spreadsheet, click on the X in the top right corner.
16. To close the program, click on the X in the top right corner.

								
To top