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.
Pages to are hidden for
"Steps to Creating a Spreadsheet in Microsoft Excel"Please download to view full document