Question: In the file named Baseballproblem7.xlsx, you are given Major League Baseball teams statistics. Enter a teams name in cell I2 and a statistic in cell

In the file named Baseballproblem7.xlsx, you are given Major League Baseball teams’ statistics. Enter a team’s name in cell I2 and a statistic in cell J2. Write a formula in cell K2 that returns the value of the statistic for the selected team.


A 5 Transaction Amount 6 7 8 9 10 11 12 13

A 5 Transaction Amount 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 1 $ 2 $ 3 $ 4 $ 5 $ 6 $ 7 $ 8 $ 9 $ 10 $ 11 $ 12 $ 13 $ 14 $ 15 $ 16 $ 17 $ 18 $ 19 $ 20 $ 21 $ 22 $ 23 $ 24 $ 25 $ 26 $ 27 $ 28 $ 29 $ 30 $ B 1,175.00 842.00 C Cumulative $1,175.00 $2,017.00 1,204.00 $3,221.00 752.00 $3,973.00 840.00 $4,813.00 620.00 $5,433.00 1,380.00 $6,813.00 1,440.00 $8,253.00 580.00 $8,833.00 1,344.00 $10,177.00 1,480.00 $11,657.00 921.00 $12,578.00 593.00 $13,171.00 810.00 $13,981.00 914.00 $14,895.00 999.00 $15,894.00 642.00 $16,536.00 596.00 $17,132.00 789.00 $17,921.00 547.00 $18,468.00 602.00 $19,070.00 697.00 $19,767.00 1,401.00 $21,168.00 1,349.00 $22,517.00 991.00 $23,508.00 514.00 $24,022.00 741.00 $24,763.00 836.00 $25,599.00 1,205.00 $26,804.00 761.00 $27,565.00 D

Step by Step Solution

3.33 Rating (162 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

To retrieve the value of a statistic for a selected team in the ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Microsoft Excel Data Analysis 7th Questions!