Area Chart :- In this type we can represent the data components which are changing. Some of the routine management operations which are frequently required are: Adding of new data to the database Editing and updating of the existing data Sorting of data in any desired manner Searching and retrieving of any type of stored data Printing of selected data SORTING THE DATABASE Sorting on Single Field : Ascending Order Sorting on Multiple Fields CREATING REPORTS :- 1. A database is simply a collection of data or information stored in the computer in a well-defined manner. TODAY() ĭATABASE MANAGEMENT IN EXCEL :- Database is the third component of Microsoft excel, the other two being Worksheet and Graphics. Percentage: Place pointer at cell address H4 and give formula as =G4/4 & then apply the percent format Note : Using Fill Handle, Calculate the total & Percentage for further Records USING FUNCTIONS 7.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |