Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 122 - 2607_Trackpad_Pro_5.1_flipbook_C7
P. 122

    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

| 117 118 119 120 121 122 123 124 125 126 127 |