Answered step by step
Verified Expert Solution
Question
1 Approved Answer
For the data set below, use a VLOOKUP formula to determine the location of the Echo contract. Enter the formula in cell H84. Business Unit
For the data set below, use a VLOOKUP formula to determine the location of the Echo contract. Enter the formula in cell H84. | ||||
Business Unit | Client | Location | Profit | |
Operations & Maintenance | Alpha | DC | $ 30,996.00 | |
Facilities | Bravo | MD | 6,088.80 | |
Facilities | Charlie | VA | 1,195.40 | |
Administrative | Delta | MD | 10,487.00 | |
Service | Echo | DC | 14,229.30 | |
Operations & Maintenance | Foxtrot | DC | 3,078.40 | |
Service | Golf | DC | 9,224.00 | |
Energy Management | Hotel | MD | 37,534.20 | |
Service | India | MD | 1,319.90 | |
Energy Management | Juliett | VA | 20,504.80 | |
Facilities | Kilo | VA | 10,046.50 | |
Total | $ 144,704.30 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started