Answered step by step
Verified Expert Solution
Question
1 Approved Answer
In Row 1, create a header row with the following labels in bold font: Column A : Vendor Name Column B : Jet Fuel Price
In Row 1, create a header row with the following labels in bold font:
- Column A: Vendor Name
- Column B: Jet Fuel Price
- Column C: Avgas Price
In Column A, Rows 2 through 6, list the following vendors in non-bold font:
- Yellow Plains Fuel
- Okie Stokie Fuel
- Best Ever Fuel
- Smith Bros Fuel
- Wild West Fuel
In Columns B and C, Rows 2 through 6, enter imaginary pricing values for all vendors and both types of fuel, keeping the range of values between $5.00 and $10.00 for each type of fuel.The numerical values for each type of fuel must be different.
Format the cells in Columns B and C, Rows 2through 6 as Currency with TWO decimal places.
- Label the cell in Column A, Row 8, "Best Jet Fuel Price" in bold font.
- Label the cell in Column A, Row 9, "Jet Fuel Vendor" in bold font.
- Label the cell in Column A, Row 11, "Best Avgas Price" in bold font.
- Label the cell in Column A, Row 12, "Avgas Vendor" in bold font.
Using Functions and Formulas
- Using the MIN function, create a formula for the cell located in Column B, Row 8 that calculates the lowest value for the Jet Fuelpricing available from the five vendors.
- Using the MIN function, create a formula for the cell located in Column C, Row 11 that calculates the lowest value for the Avgaspricing available from the five vendors.
- Using nested IF functions, create a formula for the cell in Column B, Row 9 that places the name of the vendor determined to have the "Best Jet Fuel Price."
- Select Align Right for the data in the cell located at Column B, Row 9.
- Using nested IF functions, create a formula for the cell in Column C. Row 12 that places the name of the vendor determined to have the "Best Avgas Price."
- Select Align Right for the data in the cell located at Column C, Row 12.
- Select All Bordersfor the cells in Columns A, B, and C, Rows 1 through 12.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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