Question

excel reading practice worksheet (redesigned data)
name: __________ date: ________ class period: __________
instructions: below is a redesigned sample excel worksheet (shown as a table). answer the questions that follow by identifying the correct cell location (e.g., b3), the figure that appears in a given cell, or the correct cell range (e.g., b2:d2).

a	b	c	d	e
2	jordan	25	8	6	2
3	kobe	30	5	4	3
4	lebron	28	9	8	1
5	curry	32	4	7	2
6	durant	27	7	5	2

answer the following questions:

1. what number is in cell b2?
2. what is the value in cell e3?
3. which cell contains the player lebron?
4. which cell contains the rebounds value of 4?
5. what are the assists for jordan (cell location and value)?
6. write the cell location where steals is located.
7. what is the value in cell c5?
8. which cell contains durant?
9. what is in cell a1?
10. which cell contains the highest points value?
11. what is the range for all of kobes stats?
12. what is the range that contains all player names?

Explanation:

Step1: Locate cell B2

In the table, cell B2 corresponds to the Points value for Jordan, which is 25.

Step2: Locate cell E3

In the table, cell E3 corresponds to the Steals value for Kobe. But there is an error in the written answer of 30 as the correct value is 3.

Step3: Find 'LeBron'

'LeBron' is in column A, row 4, so the cell is A4.

Step4: Find Rebounds value of 4

The Rebounds value of 4 is in column C, row 5, so the cell is C5.

Step5: Find Jordan's Assists

Jordan's Assists value is 6 and it is in cell D2.

Step6: Locate 'Steals'

'Steals' is in cell E1.

Step7: Value in cell C5

The value in cell C5 (Rebounds for Curry) is 4.

Step8: Find 'Durant'

'Durant' is in column A, row 6, so the cell is A6.

Step9: Value in cell A1

The value in cell A1 is 'Player'.

Step10: Find highest Points value

The highest Points value is 32 (Curry's Points), and it is in cell B5.

Step11: Find Kobe's stats range

Kobe's stats are in row 3, columns B - E, so the range is B3:E3.

Step12: Find player names range

All player names are in column A, rows 2 - 6, so the range is A2:A6.

Answer:

1. 25
2. 3
3. A4
4. C5
5. D2, 6
6. E1
7. 4
8. A6
9. Player
10. B5
11. B3:E3
12. A2:A6