Question

how will you display only those rows in which the total marks obtained by the students in greater than 500 ?
​

Answer 1

Answer:

Using conditional Formatting

Answer 2

By using the Filter option in excel we can display only those rows in which the total marks obtained by the students greater than 500.  

Explanation:

The following steps will display only those rows in which the total marks obtained by the students is greater than 500.

• Begin with a relevant worksheet that identifies columns using a header row.
• Choose the Data tab, and then identify the Sort & Filter, group.
• Select the Filter command.
• A "drop-down arrow" will be shown in the selected header column.
• Click on the "drop-down arrow" for the column required to filter.
• The Filter menu appears.
• Select Number Filters.
• Choose Greater than or equal to the option.
• The Custom AutoFilter window appears.
• Set Enter/Value 500 in the relevant column.
• Click OK.