MGMT 221 Module 2.4 Practical Exercise.docx - MGMT 221...

This preview shows page 1 out of 1 page.

MGMT 221 Module 2.4 Practical ExerciseFont Times New Roman 12ptFor the Formulas enter:=MIN(B2:B6) into cell B8 (this gives you the min value in the column set B2 through B6)=MIN(C2:C6) into cell C11 (this gives you the min value in the column set C2 through C6)=IF(B8=5.35,"Yellow Plains Fuel",IF(B8=5.4,"Okie Stokie Fuel",IF(B8=6.2,"Best Ever Fuel",IF(B8=6.35,"Smith Bros Fuel",IF(B8=6.4,"Wild West Fuel"))))) into cell B9, now your prices and

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture