Page 128 - 2622_Delhi Police Public School_C-6

#Excel

1. Using Excel, prepare a calculator that can calculate the total marks of a student and also calculate the
percentage of the marks they have obtained. Here is an example.

2. Create a worksheet as shown: 21 st Century #Technology Literacy
Skills
#Critical Thinking

a. Find the name of the team which has played the most matches by using the MAX() function.

b. Find the number of matches lost by each team by using the subtraction formula.

c. Compare the performance of India and Pakistan by checking if India won more matches than Pakistan.

d. Calculate the win percentage of each team.

#Python

Write a Python program to print the following:

a. Five famous landmarks of your city
b. Name of any five countries that you wish to visit
c. Your five favourite cars

126 Premium Edition-VI