Creation of spreadsheets

MS Excel

1. CREATION OF SPREADSHEETS Submitted By: Nitish Sadotra

2. Spreadsheet A spreadsheet is an interactive computer application for organization, analysis and storage of data in tabular form . Spreadsheets are developed as computerized simulations of paper accounting worksheets . The program operates on data entered in cells of a table .

3. Design Of Spreadsheets A spreadsheet consists of a table of cells arranged into rows and columns and referred to by the X and Y locations . X locations, the columns, are normally represented by letters, "A", "B", "C", etc., while rows are normally represented by numbers, 1, 2, 3, etc . A single cell can be referred to by addressing its row and column, "C8" for instance.

4. Creation Of Spreadsheet Open MS Excel from Start menu. Click on File option from Menu bar, and select new option. A new blank Sheet with columns will appear on the screen.

5. Click on the cell and write text or numeric or both . We can write as much data as we want in the cells. Some formulas also exist there in spreadsheets . =B3, will assign same value to the other cell as of B3.

6. =Sum(B2,B3,B4), will assign the sum of the cells to the selected cell . = Avrage (B2:B3), will give the average of the numbers in the cell.

7. = IF(cell cell,“True",“ Falce "), it will check and print the value. =MAX(B2,B3,B4,B5 ), gives the maximum of all digits.

8. After the completion of worksheet or spreadsheet we need to save it. For that, Click on File option from Menu bar and choose Save As option. Give the name of file and a storage location. Click on Save option and the work is Done.

9. Features Of Spreadsheet Automatic recalculation. Real-time update. Locked cell. Separate Cell formatting.

10. Creating lists. Accounting. Chart Creation. Contact Details. Exam dates & Results. I nbound call center. F inancial data. Report and graphs. Uses Of Spreadsheet