Page 106 - Computer - 6
P. 106
Lab Work Computational Skills
A. Create a multiplication table for numbers 2 to 5.
B. The given worksheet contains the data about the monthly household expenditure of a family.
Calculate:
(a) Total expenditure in the various months.
(b) Maximum, minimum, and average expenditure on food, electricity, education, and transportation
respectively.
DISCUSS Communication Skills
DISCUSS
Can all calculations in an Excel worksheet be done using the built-in functions? Discuss with your classmates.
TEACHER’S DESK
TEACHER’S DESK
Explain to the students the categories of built-in functions in Excel 2019, giving examples of where each category
of functions can be used.
104
