Page 27 - TP_Prime_V2.2_Class7
P. 27
Let's Revisit
• We can create charts in Excel. A chart is an effective way to display data in a factorial
form.
• Excel provides variety of chart format such as bar, column, pie, line, area, doughnut,
scatter, surface or radar.
• Chart can be created from chart group under Insert tab in Excel.
• We can easily change the style of the chart using change chart type command from type ADVANCED FEATURES OF EXCEL
group under the design tab.
• Sorting of data means to organise the data in ascending or descending order. Excel
allows you to sort both numeric and textual data.
• Filter option in editing group under home tab allows you to see only the required data at
that time
• Conditional formatting in Excel allows you to highlight all the cells that satisfy a particular 25
condition without hiding any row or column.
Mind Drill
Rapid fire
1. Tick (3) the correct option.
a. Which of the following allows you to display data in a pictorial form?
(i) Chart (ii) Data
(iii) Column (iv) None of these
b. Where is the Sort & Filter command present?
(i) Home (ii) Insert
(iii) Formula (iv) View
c. We use Sort A to Z option to sort _______________.
(i) Numbers (ii) Text
(iii) Symbols (iv) Time

