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
   118   119   120   121   122   123   124   125   126   127   128