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
1 player points rebounds assists steals
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 of Jordan, which is 25.

Step2: Locate cell E3

In the table, cell E3 is for the Steals value of Kobe, which is 1.

Step3: Find the cell with 'LeBron'

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

Step4: Find the Rebounds - value 4

The Rebounds value of 4 is in column C, row 5 (for Curry), 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 the header row, column E, so the cell is E1.

Step7: Locate cell C5

Cell C5 corresponds to Curry's Rebounds value, which is 4.

Step8: Find the cell with 'Durant'

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

Step9: Locate cell A1

Cell A1 contains the label 'Player'.

Step10: Find the highest Points value

The highest Points value is 32 (Curry), 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 the range of player names

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

Answer:

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