Page 205 - IT 402 v2.0 class 10
P. 205
a rite the formula to calculate the otal sales of North one.
b rite the feature used for arranging the Sales from owest to the ighest.
c o find the Maximum Sales in ast one.
d o find the verage Sales in an-Mar in cell .
e o find the difference between the sales in ast one and est one in pr- un.
ns. a S M :
b Multiple operations
c M 5 : 5
d :
e 5
. rint option is available under ............................. menu.
ns. File
. hat do you mean by Free e in Spreadsheet
ns. Free e anes is spreadsheet means to keep specific rows or columns visible when the user scrolls in the worksheet.
It is generally used when the initial rows or columns of the worksheets contain labels.
. adya is working on a spreadsheet. elp her with the solutions for the following:
a Identify the following symbol toolbar:
b enaming a worksheet from sheet to ost Sheet.
c o keep the headings constant visible even if she scrolls down.
ns. a utosum
b ight click on sheet tab Rename
c Free e anes
. iven the following Spreadsheet write the appropriate Formula xpression Function to be used for a to e :
a rite formula to calculate the otal points Sum of oints onus of each player in cell F F .
b rite the feature used for arranging the ank from ighest to owest.
c o find the layer with Maximum O to be written to ell F .
d o find the verage of oints to be written in cell .
e o change the Orientation of the age from andscape to ortrait.
ns. a F
F
F
F5 5 5
F
b Sort escending
c M F : F
d :
e iew Æ orientation Æ Portrait
Advanced Features of Spreadsheet 203

