Question

excel quiz preview: cell location and range
section 2: chart - based questions
use the chart below to answer questions 5 - 25.

1. what is the value in cell c2?
2. which cell contains bellas english score?
3. what is the range for all of carloss scores?
4. which cell contains danas history score?
5. what is the range that includes all science scores?
6. write the cell reference for elis math score.
7. which range includes all of alexs scores?
8. what is the value in cell d3?
9. which range covers bellas and carloss science and english scores?
10. write the cell reference for danas math score.
11. what is the range that covers rows 2 through 4 in the english column?
12. which cell contains the highest math score?
13. write the range that includes all history scores.
14. which cell contains the lowest science score?
15. what is the value in cell b5?
16. write the range that includes all student names.
17. what is the range for alex and bellas scores in math and science only?

Explanation:

Step1: Locate cell C2

Check the table, cell C2 corresponds to Alex's Science score, which is 90.

Step2: Find Bella's English score

Bella is in row 3 and English is in column D, so the cell is D3 with value 94.

Step3: Determine Carlos's score range

Carlos's scores are in row 4, columns B - E. The range is B4:E4.

Step4: Locate Dana's History score

Dana is in row 5 and History is in column E, so the cell is E5 with value 95.

Step5: Find Science scores range

Science scores are in column C, rows 2 - 6. The range is C2:C6.

Step6: Write Eli's Math score cell reference

Eli is in row 6 and Math is in column B, so the cell is B6.

Step7: Determine Alex's scores range

Alex is in row 2, scores are in columns B - E. The range is B2:E2.

Step8: Find value in cell D3

From the table, the value in D3 is 94.

Step9: Determine the range for Bella's and Carlos's Science and English scores

Bella is in row 3, Carlos is in row 4, Science is in column C and English is in column D. The range is C3:D4.

Step10: Write Dana's Math score cell reference

Dana is in row 5 and Math is in column B, so the cell is B5 with value 89.

Step11: Find the range for English scores rows 2 - 4

English is in column D, rows 2 - 4. The range is D2:D4.

Step12: Locate the cell with highest Math score

Math scores are in column B. The highest score is 95 (Eli's), in cell B6.

Step13: Write History scores range

History scores are in column E, rows 2 - 6. The range is E2:E6.

Step14: Locate the cell with lowest Science score

Science scores are in column C. The lowest score is 80 (Carlos's), in cell C4.

Step15: Find value in cell B5

From the table, the value in B5 is 89.

Step16: Write student names range

Student names are in column A, rows 2 - 6. The range is A2:A6.

Step17: Determine the range for Alex and Bella's Math and Science scores

Alex is in row 2, Bella is in row 3, Math is in column B and Science is in column C. The range is B2:C3.

Answer:

1. 90
2. D3
3. B4:E4
4. E5
5. C2:C6
6. B6
7. B2:E2
8. 94
9. C3:D4
10. B5
11. D2:D4
12. B6
13. E2:E6
14. C4
15. 89
16. A2:A6
17. B2:C3