Page 34 - Trackpad_V1_Book 6_Flipbook
P. 34
GROUP DISCUSSION Communication
Divide the students into two groups and discuss the difference between Mathematical Function
and Logical Function.
LAB ACTIVITY Subject Enrichment
Visit your computer lab and perform the following actions:
▶ Open a worksheet, enter your first name in the A3 cell and the last name in the B3 cell. Now
concatenate your first and last name using the text formula in cell E5.
▶ Enter the following data in Excel:
(a) Find the name of the team which has played the most matches by using the MAX() function.
(b) Find the number of matches lost by each team by using the subtraction formula.
(c) Compare the performance of India and Pakistan by checking if India won more matches
than Pakistan.
(d) Calculate the win percentage of each team.
COding Zone COding Zone {} = COding Zone Computational Thinking
{C ding z ne}
[]
</>
COding Zone
1. Calculate the given expression by following the order of precedence.
a. =6*7+9–1 ______________ b. =48/4^2 ______________
2. The following functions have some typing errors. Correct them and then write the result.
a. =’Good’”Morning” ______________ b. MIN(10,6,-2,0) ______________
CAREER HERE
If you are an expert in Microsoft Excel you can pursue your career as a Data Analyst.
FOR THE TEACHER
1. Help students to create simple mathematical formulas to perform day-to-day calculations.
2. Demonstration of cell referencing and using in-built functions would be helpful.
32 Trackpad (Version 1.0)-VI

