Radar chart can be used to plot several interrelated series and easily make visual comparison. Radar Chart :- Radar chart shows data changes in relation to centre point to each other. The pie chart is devided into slices depending upon the data item list. Pie Chart :- Pie chart is the collection of arc parts representing percentwise correspondance data item. Line Chart :- The data item or list are represented in line format in increasing or decreasing line vibrated lines. Each bar in chart is a single data series.

Bar Chart :- Bar chart consists of horizontal bars representing the corresponding data item or list.

Column Chart :- A column chart is graphical collection of vertical column representing the corresponding data item or data list. 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.

English typing book pdf