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
   68   69   70   71   72   73   74   75   76   77   78