Page 277 - Trackpad IT-402_Class-IX
P. 277
• Max(): It returns the maximum value out of the given values. Let us find the maximum quantity purchased in the
given worksheet.
=Max(C7:C11)
OR
=Max(C7;C8;C9;C10;C11)
OR
=Max(C7:C9;C10:C11)
OR
=Max(C7:C10;C11)
• Count(): It returns the count of the number of cells that contain numeric values. Let us count the number of articles
in the given worksheet.
=Count(C7;C8;C9;C10;C11)
OR
=Count(C7:C9;C10:C11)
OR
=Count(C7:C10;C11)
OR
=Count(C7:C11)
• Average(): It returns the average of the given values. Let us find the average price of an article in the given worksheet.
=Average(D7:D11)
OR
=Average(D7;D8;D9;D10;D11)
OR
=Average(D7:D9;D10:D11)
OR
=Average(D7:D10;D11)
Let us practice the formula and functions learnt so far using the following spreadsheet.
To open the
Function Wizard:
Short key Ctrl + F2
Electronic Spreadsheet 277

