EXCEL PRACTICAL QUESTIONS - 2

EXCEL PRACTICAL QUESTIONS
CONDITIONAL FORMATTING

WORKSHOP - 1
Create the following data sheet in excel.

1. Highlight all the marks, those are <33 by Conditional formatting tool.

2. Highlight the students, who got distinction by Conditional formatting tool.

3. Highlight the students, who got marks between 50 - 70.

LEARN CONDITIONAL FORMATTING



WORKSHOP - 2
Create the following data sheet in excel.

1. Find the top three highest scorer from the 'Total' column with the help of Conditional formatting tool.  

2. Find the three lowest scorer from the 'Avg' column with the help of Conditional formatting tool.





PRACTICE QUESTION (SET - 1)

PRACTICE QUESTION (SET - 2)

PRACTICE QUESTION (SET - 3)

PRACTICE QUESTION (SET - 4)

PRACTICE QUESTION (SET - 5)

HOME