Computer Science

Class-VIII

Chapter-3 Advanced features of MS Excel

A. Fill in the blanks:

1. Be careful while sorting if there are _____ in the cells.

Answer: Formulas

2. Sorting means to arrange the given data according to a ________.

Answer: Ascending or descending order

3. _______ formatting allows you to present numeric data in different colours.

Answer: Conditional

4. MS-Excel usually assumes you have a ___________.

Answer: Header row

5. _______ only temporarily hides rows you do not want displayed.

Answer: Filtering

B. Tick the correct option:

1. The default setting for sorting in ascending or descending order is by

a. column                    b. row

Answer: Row

2. Numerical values, including date and time, are sorted from the 

a. lowest to the highest            b. highest to the lowest

Answer: lowest to the highest

3. A quick and easy way to find and work with parts of data in a range is 

a. Sorting                       b. Filtering

Answer: Filtering

4. A feature in MS-Excel that sets a cell's format according to conditions that you specify is 

a. Conditional formatting        b. Custom filtering

Answer: Conditional formatting

C. Can you write the steps:

1. To sort data

Answer: Steps to sort data:

1. Select any cell in the worksheet.

2. Select data on the menu bar and from the drop-down menu select sort.

3. MS -Excel placed the first field name in the sort by box automatically.

4. You can change the field name by selecting one from the drop down list.

5. Click on the OK button.

2. To use auto filter

Answer: Steps to auto filter:

1. Click on any cell.

2. Click data on the menu bar, select auto filter.

3. You can click on any one of the drop-down controls to apply a filter to that particular field.

4. If you have selected the number 15 in the total field, only those cells that contain the number 15 in the total field would be visible.

3. To remove auto filter

Answer: Steps to remove auto filter:

 1. Select data ---> filter

2. If there is a tick mark beside the auto filter command, it indicates that auto filter is active.

3. Click on auto filter again to remove all filters and display all the data.

D. Answer the following questions:

1. Explain the sorting of data.

Answer: Sorting means to arrange the given data according to a particular field, either in ascending or descending order. 

2. What do you mean by data filtering?

Answer: The filter command allows you to view only those records that meet certain specified conditions.

3. Explain the two options provided in MS-Excel for filtering data.

Answer: There are two commands for filtering: 

1. Auto filter: Auto filter, which includes filter by selection, for simple criteria.

2. Advanced filter: Advanced filter, for more complex criteria. We will take up only the auto filter feature here.

4. What are the conditional operators provided in Custom Auto filter?

Answer: Auto-filters provide users an interactive way to put constraints on how data is displayed. A custom expression can use the AND or OR logical operator to combine two conditions.

5. What do you understand by conditional formatting? How is it considered useful?

Answer: Conditional formatting is a feature in MS Excel that sets a cell's format according to conditions that you specify. It allows you to present numeric data in different colors.

You may Like:

CBSE Computer-Science Class-VIII Exercise-1(2022-23):

CBSE Computer-Science Class-VIII Exercise-2(2022-23):