Page 34 - TP_Pro_V5.1_Class6
P. 34
21 st #Technology Literacy
LAB ACTIVITY Century
Skills #Productivity & Accountability
Visit your computer lab and perform the following actions:
▶ Enter the following data in Excel, then perform the tasks in the cells listed below.
a. C2- =(A2*B2) b. C3- =(A5=B3)
c. C4- =(A2:A6) d. E2- =AVERAGE (A2:A6)
e. E3- =(D2&D4) f. E4- =MID(D5, 4, 3)
g. C5- =(A3<>B5) h. C6- =(B6^2)
i. E5- =MAX(A2:B6) j. E6- =COUNT(A2:B5)
21 st
COding Zone COding Zone {} = COding Zone
#Productivity & Accountability
{C ding z ne}
Century
#Critical Thinking
Skills
</>
The following formulas have some typing errors. Correct them and then write the result.
a. =’Good’”Morning” b. MIN(10,6,-2,0) c. =ADD(65+45) d. =RGHT(1256,2)
CAREER HERE
People who are experts in Microsoft Excel may pursue their careers as Data Analysts.
FOR THE TEACHER
1. Help students create simple mathematical formulas to perform day-to-day calculations.
2. Demonstration of cell referencing and using in-built functions would be helpful.
32 Pro (V5.1)-VI

