Page 171 - IT 402 v2.0 class 10
P. 171
Step 5: Multiple operations dialog box appears on the screen. lick on the Formulas field of the Multiple
operations dialog box then click the cell 5 . his means that cell 5 contains the result i.e. the
formula for calculation of result.
Step 6: lace the cursor in the olumn input cell field and click cell . his means that content of cell
is variable in the formula.
Step 7: lick on ok button.
7
he profits for the different uantities are now visible in column .
Lab Assignment ‘n Activity I nte r - D is cip l inar y
Complete the following activities and tick on the circle.
reate a student s plan to score greater than aggregate marks in five different sub ects
if he has secured 5 in four different sub ects Sub ect Sub ect Sub ect
Sub ect respectively .
alculate using Scenario how much he needs to secure marks in Sub ect to get
above-mentioned aggregate marks.
sing multiple operations find the profit obtained by the seller in a month days if he
daily sells 5 masks whose selling price is ` 100.
Note:
Manufacturing Cost of each Mask is ` 35.
Fixed cost for a year is ` 12000.
Advanced Features of Spreadsheet 169

