Create a formula for the cell located in Column B, Row 8 that calculates the lowest value for the Jet Fuel pricing available from the five vendors.

Practical Exercise Due

Using the MIN function, create a formula for the cell located in Column B, Row 8 that calculates the lowest value for the Jet Fuel pricing 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 Avgas pricing 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 Borders for the cells in Columns A, B, and C, Rows 1 through 12.