PLEASE RESPOND ASAP WITH ANSWER AND EXPLANATION. AS WELL AS EXCEL FORMULA!!

THANKS,

G H 1 91 2 92 3 93 B E F use the westbrook data to create an appropriate chart use the westbrook data to create sparkline for each sales person. Present the sparkline on column H Create a column chart for the provided table 4 5 Salesperson 6 Albertson, Kathy 7 Allenson, Carol 8 Altman, Zoey 9 Bittiman, William 10 Brennan, Michael 11 Carlson, David 12 Collman, Harry 13 Counts, Elizabeth 14 David, Chloe 15 Davis, William 16 Dumlao, Richard 17 Farmer, Kim 18 Ferguson, Elizabeth 19 Flores, Tia 20 Ford, Victor 21 Hodges, Melissa 22 Jameson, Robinson 23 Kellerman, Frances 24 Mark, Katharine 25 Morrison, Thomas 26 Moss, Pete 27 Paul, Henry David 28 Post, Melissa 29 Robinson, Betty 30 Shadow, Elizabeth 31 Smith, Harold 32 Thomas, Robert 33 Thompson, Shannon 34 Walters, Chris 35 Zimmerman, Kate May $3,947.00 $4,411.00 $2,521.00 $4,752.00 $4,964.00 $2,327.00 $3,967.00 $4,670.00 $3,379.00 $5,363.00 $3,275.00 $3,860.00 $4,685.00 $4,052.00 $5,541.00 $5,667.00 $4,269.00 $3,502.00 $5,853.00 $2,586.00 $5,714.00 $5,347.00 $4,222.00 $5,929.00 $4,270.00 $5,421.00 $3,259.00 $2,943.00 $5,529.00 $2,380.00 June $557.00 $1,042.00 $3,072.00 $3,755.00 $3,152.00 $4,056.00 $4,906.00 $521.00 $3,428.00 $1,562.00 $2,779.00 $3,470.00 $1,913.00 $2,883.00 $4,931.00 $4,798.00 $4,459.00 $4,172.00 $2,011.00 $2,398.00 $4,960.00 $4,060.00 $3,317.00 $3,127.00 $4,263.00 $4,728.00 $3,679.00 $3,943.00 $4,925.00 $3,247.00 Westbrook Parker Sales Data July Aug. Sept. Oct SPARKLINE $3,863.00 $1,117.00 $8,237.00 $8,690.00 $9,355.00 $1,100.00 $10,185.00 $18,749.00 $6,702.00 $2,116.00 $13,452.00 $8,046.00 $4,415.00 $1,089.00 $4,404.00 $20,114.00 $11,601.00 $1,122.00 $3,170.00 $10,733.00 $3,726.00 $1,135.00 $8,817.00 $18,524.00 $9,007.00 $2,113.00 $13,090.00 $13,953.00 $4,505.00 $1,024.00 $3,528.00 $15,275.00 $3,973.00 $1,716.00 $4,839.00 $13,085.00 $2,945.00 $1,176.00 $9,642.00 $13,714.00 $7,549.00 $1,101.00 $5,850.00 $15,065.00 $3,862.00 $1,040.00 $10,024.00 $18,389.00 $4,596.00 $1,126.00 $5,503.00 $10,686.00 $2,142.00 $2,012.00 $13,547.00 $ 21,983.00 $8,283.00 $1,054.00 $9,543.00 $11,967.00 $8,420.00 $1,389.00 $10,468.00 $12,677.00 $2,248.00 $1,058.00 $6,267.00 $14,982.00 $11,074.00 $1,282.00 $2,365.00 $9,380.00 $3,807.00 $1,348.00 $11,110.00 $18,047.00 $2,453.00 $1,020.00 $4,612.00 $20,525.00 $11,507.00 $1,010.00 $6,599.00 $11,626.00 $7,056.00 $1,555.00 $5,439.00 $15,285.00 $5,849.00 $2,081.00 $10,521.00 $18,979.00 $7,971.00 $1,114.00 $2,686.00 $24,099.00 $4,999.00 $1,052.00 $2,399.00 $8,924.00 $7,158.00 $1,116.00 $4,276.00 $13,907.00 $8,406.00 $2,123.00 $14,697.00 $16,827.00 $11,987.00 $1,183.00 $3,071.00 $11,292.00 $3,122.00 $1,629.00 $14,684.00 $20,871.00 $11,956.00 $1,156.00 $3,098.00 $8,531.00