Page 47 - ThinkGPT_V2.1_C6_Flipbook
P. 47
The sorting can also be done through the Sort & Filter group under the Data tab
by selecting and buttons for sorting in ascending and descending order,
respectively. To create a custom sort, click on button.
REFRESH
Charts make it easier to draw comparisons, analyse growth and relationships among the values.
Excel can arrange the selected data in either ascending or descending order. This is called sorting
of data.
TeCh Ready
A. Tick ( ) the correct option.
1. Which of the following is also known as a vertical axis?
(i) Bar (ii) Value axis
(iii) Data (iv) Category axis
2. Under which tab is the Sort & Filter button present?
(i) Home tab (ii) Formula tab
(iii) Insert tab (iv) View tab
3. What can be sorted by using the Sort A to Z option?
(i) Numbers (ii) Symbols
(iii) Text (iv) All of these
B. Fill in the blanks using the words given below.
Plot area Column Scatter charts
1. The chart usually displays the data in the form of vertical bars.
2. are also known as XY scatter plot charts.
3. is the rectangular area bounded by the two axis.
C. State whether these statements are true or false.
1. Excel can arrange selected data in ascending order only.
2. We cannot create a Bar chart in Excel.
3. You cannot sort more than one column at a time in a selected range of cells.
4. 'My data has headers' checkbox needs to be selected if columns have a heading
at the top.
More on Excel 45

