Page 154 - IT_V1.0_Class10
P. 154
Step 7: Click on the Column input cell field of the Multiple Operations dialog box,
Step 8: Select cell B4, as it contains the variable value in the formula, here it is Quantity Sold in a Year.
Step 9: Click on OK button.
8
6
5
7
9
The profits for the different quantities are now visible in column ‘E’.
If you change the values in column D, i.e., Annual Sales Figure, then the Profit in column E will be
automatically updated.
21 st
Lab Assignment ‘n Activity Century #Technology Literacy
Skills
Complete the following activities and tick the circle.
Mr. Laksh is preparing a list of class with 30 students. He enters marks for five different
subjects. Group the students by subject and calculate the subtotals for each subject.
Analyse different scenarios of monthly expenses for a household. Consider three scenarios:
Minimum Expense, Average Expense, and Maximum Expense for categories such as Rent,
Groceries, Utilities, and Miscellaneous.
A store sells three different products (Product X, Product Y, Product Z) with different selling prices and
costs. Calculate the monthly profit using multiple operations, considering different sales volumes.
152 Information Technology Play (Ver 1.0)-X

