Page 57 - KEC Khaitan C6 Flipbook
P. 57

c.  What type of formatting in Excel changes cell appearance based on conditions?
                     _______________________________________________________________________________

                    d.  Which tab in Excel contains the Insert Function command?
                     _______________________________________________________________________________


                 5.  Think and answer.
                    a.   Sara has recorded the scores of her classmates in a test and wants to highlight the
                       scores that are above 90. Which Excel feature can she use to achieve this?
                     _______________________________________________________________________________

                     _______________________________________________________________________________

                    b.   Raj needs to create a dataset with names and scores of students. Use the IF() function to label each
                       student as “Pass” if their score is 60 or above, and “Fail” if below.
                     _______________________________________________________________________________

                     _______________________________________________________________________________

                    c.   You are given a list of students’ scores. How can you automatically highlight scores below 40 to
                       identify weak students?
                     _______________________________________________________________________________

                     _______________________________________________________________________________

                 6.  Read the instructions carefully and answer the following questions:

                    a.  Given the data in cells C2 to H2 as follows:
                       C2: 10, D2: 15, E2: 20, F2: 25, G2: 30, H2: 35

                       (i)  What will be the result when you apply the SUM() function to this range?
                     _______________________________________________________________________________

                       (ii)  If the AVERAGE() function is applied to the numbers 4, 5, and 6, what will be the output?
                     _______________________________________________________________________________

                    b.  If A1 contains the value 8, what will the function return?
                       =IF(A1 > 10, “Pass”, “Fail”)
                     _______________________________________________________________________________



                           SDG Activity



                    Use Excel to create a budget tracker where you input your weekly savings and
                    expenses. Apply sorting to organise your expenses by amount, and use conditional
                    formatting to highlight any expenses that exceed your budget limits. Analyse the
                    results to see how managing  your finances can lead to better economic stability.






                                                                                         Advanced Features of Excel  55
   52   53   54   55   56   57   58   59   60   61   62