Page 16 - 2403_Trackpad_V5.1_C6_Fb
P. 16
b. Comparison operators ________________________________________________________________
______________________________________________________________________________________
c. Reference operators ________________________________________________________________
______________________________________________________________________________________
5. Differentiate between the following:
Relative Cell Referencing Absolute Cell Referencing
__________________________________ __________________________________
__________________________________ __________________________________
6. Competency-based/Application-based questions. Experiential Learning
a. Alisha was working on Excel and wanted to compare two data sets to determine the
outcome. She's not sure which operator to use. Inform her about the appropriate
operator she should use to resolve this.
_____________________________________________________________________________________
b. Mansi has made a spreadsheet for the marks obtained by the students of her class in different
subjects. Which feature should she use to keep the spreadsheet updated if she has to change marks
in one of the subjects of any student?
_____________________________________________________________________________________
c. Sonia is creating project information in a spreadsheet, and she wants to estimate an employee's
basic salary using the formula (D2-C2*1.5). However, nothing happens after typing the formula into
the formula bar. What must she have missed in the formula to produce the proper result?
_____________________________________________________________________________________
LAB ACTIVITY Subject Enrichment
Visit your computer lab and perform the following actions:
▶ Enter the following data in Excel:
(a) Find the number of matches lost by each team by using the subtraction formula.
(b) Compare the performance of India and Pakistan by checking if India won more matches than
Pakistan.
(c) Calculate the win percentage of each team.
14 Premium Edition-VI

