Page 71 - Viva ICSE Computer Studies 7 : E-book

LEARNING IS FUN

A Fun with Excel

Draw an image of the worksheet in your scrapbook and label it properly. Also, describe it in a
few lines.

B Making an Excel Sheet

Given below is the data of fi ve students. Enter it in Excel 2016 and answer the questions given
below.

Arnold Ruhaan Utkarsha Akshita Zikra

English 78 80 92 81 80

Hindi 64 61 78 70 85.5

Maths 95 92 85 82 87.5

Science 90 84 89.5 88.5 92.5

Social studies 62 80 72 71.5 80

1. Who has the highest score out of 500?
2. How much marks does Arnold require to reach the highest score?

3. How much marks does Utkarsha require to have a perfect score of 500?
4. Arrange the scores out of 500 in an ascending order.

5. Find out the percentage of students.

C Unscrambling the Letters

Unscramble the letters to write the correct words. Defi ne these words in your notebook.

1. SRIMCOOTF EXECL ________________________

2. KBOWORKO ________________________
3. SAPSERDEHTE ________________________

4. LECL ________________________

5. NARGE ________________________

6. BIROBN ________________________

59