Chapter - 4: Sorting, Charts and its types- Excel of Questions & Answer

for chap-ter4

Sorting, Charts and its types- Excel – EVALUATION SHEET

I. Tick (✔) the correct option:

1. To view some particular text while hiding the rest is known as
   a. Sorting
   b. ✔ Filtering
   c. Custom Filtering
   
2. Which combination of keys is pressed on the keyboard to switch on filtering?
   a. Ctrl+F
   b. Ctrl + Shift + F
   c. ✔ Ctrl + Shift + L
   
3. The Filter button is present on the
   a. Home
   b. ✔ Data
   c. Insert
   
4. The rectangular area enclosed within the axes of the chart where the data is plotted is known as
   a. Chart area
   b. ✔ Plot area
   c. Both (a) and (b)
   
5. The Print option can be found in/on the
   a. ✔ File menu
   b. Quick Access Toolbar
   c. Status bar
   

II. Fill in the blanks using the given words:

1. ________ means arranging the data of a spreadsheet either in increasing or decreasing order. Sorting
2. When you select a numeric column or field for sorting, the Sort A to Z option changes to Sort Smallest to Largest.
3. The Conditional Formatting helps you to set certain conditions to a range of cells.
4. You can find the Chart button on the Insert tab.
5. The set of data values with the help of which the chart is drawn is known as the Data Series.

III. Write 'T' for True and 'F' for False statements:

1. In an increasing or ascending order, the data is arranged alphanumerically. – T
2. To highlight a pattern in the data, you can use the conditional formatting option. – T
3. The axes title is the heading given to a chart. – T
4. A chart can represent the data pictorially. – T
5. The All Charts tab is active when you open the Insert Chart dialog box. – F

IV. Answer the following questions:

1. How can you clear the filter conditions from the data in your spreadsheet?

Go to the Data tab, click the Filter button to turn it off or select 'Clear Filter' from the dropdown in the filtered column.

2. What is the basic difference between sorting and filtering the data in Excel?

Sorting rearranges all data in a particular order, while filtering hides non-matching data and displays only specific values.

3. Explain the different types of charts read in the chapter.

The different types of charts include Column Chart, Bar Chart, Line Chart, Pie Chart, Area Chart, and Doughnut Chart. Each chart type represents data in a unique visual format.

4. How can you change the chart type and layout?

Click on the chart → go to the Chart Tools Design tab → choose Change Chart Type or Quick Layout to modify type or layout respectively.

5. Write down the steps to print an Excel spreadsheet.

Click on File → Print → Select printer and settings → Click on the Print button.

V. Define the following terms:

1. Custom Filtering

Custom filtering allows setting specific conditions to filter data, like values greater than a number or containing a certain text.

2. Chart

A chart is a graphical representation of data using symbols like bars, lines, or slices to show trends and comparisons.

3. Value Axis

Value Axis is the vertical or Y-axis in a chart that displays the range of values used in the data.

4. Legend

A legend is a key that identifies the colors, patterns, or symbols used in a chart to represent different data series.

🔔 Subscribe to My Channel