Page 29 - TrackpadV5.1_class7
P. 29

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”)
                                                                                               21 st
                 7.  Competency-based/Application-based questions.                           Century   #Critical Thinking
                                                                                               Skills
                    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.






                            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.








                                                                                             21 st
                     LAB ACTIVITY                                                          Century   #Technology Literacy
                                                                                            Skills
                     Perform the following tasks in Excel 2021.
                     a.   Following is a list of names entered in Excel. Create the worksheet then use different features of
                        Excel as instructed.


























                                                                                         Advanced Features of Excel  27
   24   25   26   27   28   29   30   31   32   33   34