Page 73 - modular4.0
P. 73
Chapter Profile
3. Explain any three options available in Conditional Formatting.
21 st
F. Competency-based/Application-based questions. Century #Information Literacy
Skills
1. Namita is creating an Excel worksheet to calculate her class results and wants to ensure that the
marks entered in the marks column are within the range of 0 to 100, neither below 0 nor above 100.
Which Excel feature can she use to achieve this?
2. The HR department of a company is tracking the performance of its employees based on quarterly
sales. The data includes Employee Name, Quarter, and Sales Amount. The company wants to quickly
identify employees who have exceeded sales targets, which are set at Rs 5,00,000 per quarter. They
also want to highlight employees with sales below Rs 1,00,000 in red to indicate underperformance.
Which feature of excel can be used for this purpose.
3. Niti, the class teacher of 7D, has the data of her entire class in Excel. She wants to
filter and view the list of students whose names start with the letter "R." How can she
achieve this?
21 st
In the Lab Century #Technology Literacy
Skills
Consider the following worksheet:
a. Use the Filter command to display the data of employees whose department is “Training”.
b. Use the Filter command to display the data of employees whose address is “Mumbai”.
c. Display the data in descending order of Emp Name.
d. Use Conditional Formatting to highlight the cells with Address as Jaipur.
Teacher's Corner
Explain the concept of database to the students.
Do a walk-through of all the topics covered in this chapter.
Excel as Database 71

