80.2K

Verified Solution

Link Copied!

30 130 Create a scenario named Ideal-Costs, using Base price per square foot and Lot fee (use cell: references). Enter these values-for the scenario: 80, 102,675.0 Created On: 03/16/2020 Exp19_Excel_Ch06_ML1 - Housing Cost-1.39 Grader-Instructions Excel 2019 Project Stepa Instructions Points Possiblea 140 30 150 30 R Create a scenario named increased-Costs, using Base price per square foot and Lot fee (use- cell references). Enter these values for the scenario: 100, 110,000.c. Create a scenario named Low Costs, using Base price per square foot and Lot fee (use cell references). Enter these values for the scenario: 60, 80,000, a Generate a scenario summary report using the cell-references for Price per square foot and Lot Fee. Add the appropriate formatting to the newly created reporta Save and close Exp19 Excel Ch06_ML1_HW Housing Cost xlsx Exit Excel Submit the file 160 50 170 0 ed States Focus 30 130 Create a scenario named Ideal-Costs, using Base price per square foot and Lot fee (use cell: references). Enter these values-for the scenario: 80, 102,675.0 Created On: 03/16/2020 Exp19_Excel_Ch06_ML1 - Housing Cost-1.39 Grader-Instructions Excel 2019 Project Stepa Instructions Points Possiblea 140 30 150 30 R Create a scenario named increased-Costs, using Base price per square foot and Lot fee (use- cell references). Enter these values for the scenario: 100, 110,000.c. Create a scenario named Low Costs, using Base price per square foot and Lot fee (use cell references). Enter these values for the scenario: 60, 80,000, a Generate a scenario summary report using the cell-references for Price per square foot and Lot Fee. Add the appropriate formatting to the newly created reporta Save and close Exp19 Excel Ch06_ML1_HW Housing Cost xlsx Exit Excel Submit the file 160 50 170 0 ed States Focus

Answer & Explanation Solved by verified expert

See Answer