Question

name: ____________ date: ________ class period: ________ instructions: answer the following 20 questions. read carefully — scenarios are different from previous quizzes. reference chart a b c d e 1 product q1 q2 q3 q4 2 laptops 120 135 150 160 3 tablets 90 100 110 105 4 smartphones 200 220 210 230 5 headphones 75 85 95 100 6 monitors 60 70 80 90 1. what is the cell reference for the q2 sales of laptops? __________ 2. which cell contains the number 230? __________ 3. write the range that covers all q1 sales. __________ 4. what is the value in cell d3? __________ 5. which range includes all sales data for tablets? __________ 6. write the range that contains all product names. __________ 7. what is the cell reference for monitors’ q4 sales? __________ 8. which range covers smartphones’ q2 through q4 sales? __________ 9. what number is in cell c5? __________ 10. write the range for all sales in q3. __________ 11. which cell contains the lowest sales figure in q1? __________ 12. what is the value in cell b6? __________ 13. write the range that includes all q2 and q3 sales for all products. __________ 14. which cell contains headphones’ q4 sales? __________ 15. write the range covering all sales for laptops and tablets. ____________

Explanation:

Step1: Identify cell for Laptops Q2 sales

The cell reference for Q2 sales of Laptops is C2.

Step2: Locate cell with 230

The number 230 is in cell E4.

Step3: Determine range for Q1 sales

All Q1 sales are in the range B2:B6.

Step4: Find value in D3

The value in cell D3 is 110.

Step5: Define range for Tablets sales

The range for all sales data of Tablets is B3:E3.

Step6: Find range for product names

The range that contains all product names is A2:A6.

Step7: Identify cell for Monitors Q4 sales

The cell reference for Monitors' Q4 sales is E6.

Step8: Determine range for Smartphones Q2 - Q4 sales

The range for Smartphones' Q2 through Q4 sales is C4:E4.

Step9: Find number in C5

The number in cell C5 is 85.

Step10: Define range for Q3 sales

The range for all sales in Q3 is D2:D6.

Step11: Locate cell with lowest Q1 sales

The lowest sales figure in Q1 is 60 in cell B6.

Step12: Find value in B6

The value in cell B6 is 60.

Step13: Determine range for Q2 and Q3 sales

The range that includes all Q2 and Q3 sales for all products is C2:D6.

Step14: Identify cell for Headphones Q4 sales

The cell that contains Headphones' Q4 sales is E5.

Step15: Define range for Laptops and Tablets sales

The range covering all sales for Laptops and Tablets is B2:E3.

Answer:

1. C2
2. E4
3. B2:B6
4. 110
5. B3:E3
6. A2:A6
7. E6
8. C4:E4
9. 85
10. D2:D6
11. B6
12. 60
13. C2:D6
14. E5
15. B2:E3