5. In cell G5, insert the formula using an appropriate LOOKUP function to find the House...

Transcribed Image Text:

5. In cell G5, insert the formula using an appropriate LOOKUP function to find the House Points rewarded for each student (Hint: Specify the range_lookup). Apply absolute reference to the formula. AutoSave off り MS EXCEL CHALLENGE crystal Search File Home Insert Draw Page Layout Formulas Data Review View Automate Help Acrobat X Calibri Paste BIU v く v く Clipboard G5 X✓ fx く 11 Α' Α' Insert 22 General Delete く %" % 5808 .00 000 Conditional Format as Cell Formatting Table Styles Format Font Alignment Number Styles Cells A - 2 1 3 W ż Ą Sort & Find & ✓ Filter Select Editing Analyze Data Analysis B C D E F G H | J K L 1/10/2023 Hogwarts House Points Calculation Student Name House Quidditch Points Spellcasting Points Potion Brewing Points Total House Points Total House Points 4 reward 5 Harry Gryffindor 20 85 90 195 6 Cedric Hufflepuff 30 78 30 138 7 Luna Ravenclaw 25 92 84 201 8 Draco Slytherin 15 70 95 180 9 Hermione Gryffindor 22 95 89 206 10 Total 112 420 388 11 Highest Points 30 95 95 12 Lowest Points 15 70 30 13 14 15 Points Table 16 Total Points Range House Points 17 Lesser than 150 10 18 Between 150 to 189 30 19 Greater than or equal to 190 50 20 21 22 5. In cell G5, insert the formula using an appropriate LOOKUP function to find the House Points rewarded for each student (Hint: Specify the range_lookup). Apply absolute reference to the formula. AutoSave off り MS EXCEL CHALLENGE crystal Search File Home Insert Draw Page Layout Formulas Data Review View Automate Help Acrobat X Calibri Paste BIU v く v く Clipboard G5 X✓ fx く 11 Α' Α' Insert 22 General Delete く %" % 5808 .00 000 Conditional Format as Cell Formatting Table Styles Format Font Alignment Number Styles Cells A - 2 1 3 W ż Ą Sort & Find & ✓ Filter Select Editing Analyze Data Analysis B C D E F G H | J K L 1/10/2023 Hogwarts House Points Calculation Student Name House Quidditch Points Spellcasting Points Potion Brewing Points Total House Points Total House Points 4 reward 5 Harry Gryffindor 20 85 90 195 6 Cedric Hufflepuff 30 78 30 138 7 Luna Ravenclaw 25 92 84 201 8 Draco Slytherin 15 70 95 180 9 Hermione Gryffindor 22 95 89 206 10 Total 112 420 388 11 Highest Points 30 95 95 12 Lowest Points 15 70 30 13 14 15 Points Table 16 Total Points Range House Points 17 Lesser than 150 10 18 Between 150 to 189 30 19 Greater than or equal to 190 50 20 21 22

Answer rating: 100% (QA)

Solution of the question The question in the image is asking for the formula to be used in cell G5 to find the House Points rewarded for each student using the VLOOKUP function and specifying the rang... View the full answer