Spreadsheets are one of the most beneficial computer applications that we have ever seen. Spreadsheets also help ease the task of business proprietors. The integration of a spreadsheet in almost all office productivity suite could be indisputable.
The leading names of Productivity Suites would incorporate Microsoft Office and Open Office. They will have Microsoft Excel and OpenOffice Calc as spreadsheet programs. Inexperienced persons normally obtain a rough start with spreadsheets. That is why we will aim to show how to make a spreadsheet.
For you to know the idea more fast, let us utilize Microsoft Excel in generating a fundamental financial report. Comprehend on the next ways on how to make a spreadsheet:
1. Open MS Excel.
2. The following thing you will observe is a spreadsheet comprised of cells with:
a. Columns with letters (A, B, C...) labels
b. Rows possessing numbers (1, 2, 3...) as labels.
3. Keep in mind that a cell is addressed by the column and row where it is found.
a. For instance, cell A1 is the most primary cell you will observe quickly beneath column A and row 1.
4. Enter the word Item in cell A1.
5. Key in Cost to cell B1.
6. Enter Printing to cell A2.
7. Accordingly, input 100.00 to cell B2. (Tip: Automatically, whatever thing that you enter in a cell is saved once you click anywhere outside that cell.)
8. Select cell A3 and then type Postage.
9. Transfer to cell B3 and then enter 85.00.
10. Enter the word Envelopes in cell A4.
11. Input the value 42.00 in cell A4.
12. Key in the word Total in cell A5.
13. Key in =SUM(B2:B4) to cell A5.
14. 227.00 will pop out if you happen to click on any cell inside similar spreadsheet.
15. Save and youre done.
The latest version of MS Excel available is 2010. The same course of action can be in use on how to make a spreadsheet even for earlier versions. If you ever wondered how to make mailing labels from excel, spreadsheets are as well serviceable as well. Discover how to make a spreadsheet by way of this video: http://www.youtube.com/watch?v=1Sm8uVX-mFE&feature=youtu.be.
No comments:
Post a Comment