Page 49 - COMPUTER
P. 49

➢  Uses Of Spread Sheet:-
                       1)  Sales And Cost Analysis
                       2)  Financial Report
                       3)  Sales Forecasting
                       4)  Stock Inventory





                   ➢ Work Book

                       A Work Book Is An Excel File That Store Information
                       You Enter Because Each Work Book Can Contain Many Sheets You Can
                       Organize Various Kind Of Related Information In A Single File.





                   ➢ Work Sheet


                       A Work Sheet Also Commonly Referred To As A Spread Sheet Is A
                       Rectangular Grid Of Rows And Columns Used To Enter Data Work Sheet
                       Are Used To List And Analysis Data You Can Enter And Edit Data

                   ➢ Column Heading


                       The Name Given To Each Column Is Termed As Column Heading. The Work
                       Sheet Actually Contain 256 Columns In Ms Excel 2003 And 16,384 Columns
                       In Ms Excel 2007.

                   ➢ Row Number /Heading


                       The Horizontal Group Of Cells Is Termed As A Row And Each Row Is
                       Assigned A Numbers From 1 To 65,536 In Ms Excel 2003 And From 1 To 10,
                       48,576 In Ms Excel 2007

                   ➢ Name Box


                       The Name Box Displays The Address Of The Active Cell.











                                                                                                                   48
   44   45   46   47   48   49   50   51   52   53   54