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

