Page 123 - TP_V5.1_C7_fb
P. 123
4. A teacher wants to highlight all students who scored less than 40 marks in Science. Which feature
of Excel can help her achieve this?
5. You are a school administrator who needs to organise a student data sheet to make it easier for
teachers to review student details. The data sheet includes columns for Student Name, Class, and
Section. The principal has asked you to sort the data so that it first arranges students by their
class and section, and then within each section, sorts them alphabetically by their names.
Using the data sheet below, demonstrate how you would apply multiple levels of sorting:
Student Name Class Section
Ravi 7 B
Aarti 7 A
Priya 8 B
Arjun 7 A
Mohit 8 A
Neha 7 B
Sita 8 A
Raj 7 A
6. School Administrator has prepared list of all students of school. Some students have left in middle
of session, she wants to temporarily hide these students, which feature of Excel should she use?
Chapter 3: Functions in Excel
1. In a school science project, students need to check if their scores meet the pass mark of 50.
Ramesh scored 45 and Sita scored 55. Use the IF() function in Excel to determine who passed and
who didn’t. How can you set up the formula to show “Pass” or “Fail” for each student?
2. After receiving your math test scores, you decided to calculate your average to see how you
performed overall. Your scores are 78, 92, 85, and 95. Which function in Excel will help you achieve
the same?
3. Your teacher is reviewing the results of a recent science quiz for 20 teams. She needs to determine
the highest score to reward the top performer. How can you use Excel to find this highest score?
4. Devika is creating a list of participants for a sports event. She wants to write their first and last
names in a single cell. The first name is in cell A1, and the last name is in B1. What should she write
in cell C1 if she wants full name to be displayed there?
5. Danish has recorded the daily temperatures for the given days: Monday- 34°C, Tuesday- 32°C,
Wednesday- 30°C, Thursday- 28°C, and Friday- 29°C. How can he find which is the coldest day
of all?
6. You’re organising a birthday party with the following expenses:
• Decorations: 10 items at `400 each
• Catering: 5 meals at `1,200 each
• Party favours: 20 items at `80 each
• Entertainment: 1 package costing `2,400
Calculate the total expenditure for the party. How much did you spend in total?
Assignments 121

