Page 79 - Code & Click - 6

Mind Stretching

1. Give the result of the following formulas and functions in Excel. Logical Thinking
(a) = 9 ^ 2 + 10 – 4 = __________
(b) = 3 * (5 + 4) – 11 + 13 = __________

(c) = 4 + 6^2 – 5 = __________
(d) = PRODUCT (AVERAGE (54, 65, 78, 90, 45), 5) = __________

(e) = SUM (MAX (45, 23, 67, 54), MIN (73, 67, 42, 56)) = __________
2. Ruchi has a list of numbers in cells A1 to A5 in an Excel worksheet. She wants to calculate
110% of each number. She types 1.1 in cell D2 and the formula =A4*C2 in cell B1. She copies
the formula from cell B1 down to cell B5. But, she gets the result 0 in all cells except cell B1.
Help her correct the formula to get desired result. Computational Skills

Computational Skills
Lab Work

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.

77