Page 223 - CA_165_V2.0_C9_Flipbook
P. 223
2
3
1
Step 4: In the Sort by section, select the
column to be sorted from the 4 5
drop-down list.
Step 5: In the Sort by section, select the
Ascending or Descending radio
button to sort accordingly.
Step 6: Click the OK button. The selected
column or range of cells will be sorted.
6
21 st
Lab Assignment ‘n Activity Century #Technology Literacy
Skills
Complete the following activities and tick on the circles:
ª 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)
Data Analysis 221

