Page 23 - Code Craft Computer-7

B. Consider the given worksheet data and calculate the following based on the given
worksheet data.

a. Amount for all the items. (Amount = Price Per Unit * Quantity)
b. Total amount payable after adding amount for all the items.

Competency-Based Questions
1. Do the formulas in MS Excel follow BEDMAS rule while doing a long calculation? Do you
need to enclose operations in brackets if more than one operation has to be done?

2. Consider the worksheet and answer the questions.
a. What will be the result in cell B4 if you press Enter?
b. If the formula in cell B4 is copied and pasted to cell D2,
what will be the formula and the resultant value?
c. Which type of cell reference is this?

Stretch Your Mind #Problem Solving

Can we use Excel to calculate your weekly or monthly expenses?

Join the Discussion #Communication

Discuss the different cell references in the class, in detail.

Mental Processing #Life Skills and Values

Your friend wants to learn formula and functions in MS Excel. He copies the notes from you and
simply starts mugging them up. Is he doing the right thing? Justify your answer.

Teacher’s Corner

Demonstrate the use of some commonly used functions with appropriate examples.

23