Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 29 - 2633 Trackpad Pro V5.1 Class 7
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 |