• Enter a formula in cell I5 using the VLOOKUP function to calculate the discount amount based on the value in the Account Type column. (Hint: The Lookup table for the VLOOKUP function is found in range R8:S12). Use a structured reference for the Lookup value and an absolute value to reference the cells in the Lookup table. You will also need to enter FALSE as the range_lookup argument. Excel should automatically copy the formula from cell I5 to all cells in the Discount column; if it does not, you will need to copy the formula from cell I5 to the remaining column cells.

 

Flex Cab CompanyCorporate AccountsAreaRidesAverage FareTotal Receipts3PlatnumDownTown935Err:509$54,5291PlatnumDownTown760Err:509$43,5022PlatnumNorTh of DownTown1125Err:509$63,7206GoldDownTown556Err:509$33,9995GoldDownTown301Err:509$17,6878GoldEasT of DownTown476Err:509$29,5837GoldEasT of DownTown345Err:509$21,8974GoldSouTh of DownTown377Err:509$29,0789SilverDownTown243Err:509$15,98510SilverDownTown126Err:509$7,29814SilverNorTh of DownTown179Err:509$11,95912SilverSouTh of DownTown221Err:509$13,23613SilverSouTh of DownTown143Err:509$10,10311SilverWesT of DownTown202Err:509$12,99115SilverWesT of DownTown232Err:509$11,86017BronzeDownTown75Err:509$5,02918BronzeDownTown75Err:509$5,02920BronzeDownTown57Err:509$4,20819BronzeEasT of DownTown77Err:509$5,57716BronzeNorTh of DownTown57Err:509$3,78522BronzeSouTh of DownTown57Err:509$4,14623BronzeWesT of DownTown64Err:509$4,43821BronzeWesT of DownTown36Err:509$2,776±oTalErr:508Err:509Err:508CustomerIDAccountType

• 1496369903-question.xlsx

ComputerScienceExpert

(11)

Status NEW Posted 02 Jun 2017 02:06 AM My Price 8.00

-----------

Attachments

file 1496369906-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer