Page 38 - Viva ICSE Computer Studies 8 : E-book

Linking Knowledge

Mathematics: Create your daily expense chart for a week in Excel 2016. Also calculate the total
expenses made by you daily and the average of your expenses.

Lab Fun

1. Enter the following data and perform the given tasks using the formulae and functions.
Computer
Name English Math GK
Studies
Shazia 45 45 45 90
Taranuum 67 88 43 67
Aditi 54 67 52 66

Vidit 78 54 62 65
Paarth 87 56 51 77
Samson 65 69 77 88

Aryan 77 34 67 90

(a) Find out the minimum, maximum and average marks in English, Math, GK and Computer
Studies.
(b) Calculate the sum total for all the students along with their percentages.

2. Monica typed the following data in MS Excel worksheet.

A B C D E
S. No. Roll No Marks Name
1 101 450 Anubhav

2 102 645 Gaganpreet
3 103 446 Saumya

She typed marks in column C instead of column E. How can she place the data properly?
R

26