Page 209 - CA 165 ver 1.0 Class 9
P. 209
Lab Assignment ‘n Activity Subject Enrichment
Complete the following activities and tick on the circle.
ª Make a worksheet with following headings:
Name of Student Maths Science S. St. Total Marks
ª Insert the data of at-least 15 students.
ª Find the following using built-in function:
l Total Marks secured by each student
l Maximum marks obtained in Maths
l Minimum marks obtained in Science
l Average marks scored in S. St.
ª Sort the student list in descending order of ‘Total Marks’.
ª Save the workbook by name ‘Result Analysis’.
ª Evaluate the formulas using spreadsheet given below:
a. =MAX(A1:B4) b. =MIN(B1:C4) c. =SQRT(F4)
d. =AVERAGE(A1 :A4) e. =ABS(F1) f. =ROUND(E2; 1)
FILTER
Filtering is a quick and easy way to get required information from the subset of data in a range of cells.
A filtered range displays only such data that meet the criteria as specified for a field. In ‘Calc’ there are
three options that help in filtering the range of data:
AutoFilter It filters data according to specific value or string.
Standard Filter It filters the data according to a given condition.
Advanced Filter It does more advanced filtering, on the basis of specific criteria.
Unlike sorting, filtering does not rearrange a range of cells. Filtering temporarily hides the rows that
is not required to be displayed. It allows to edit, format and even print the range subset without
rearranging or moving it.
To Filter a range of data:
Step 1: Select range of cells.
Data Analysis 207

