Excel Scenario and Goal Seek Class Exercises
Simple Scenario and Goal Seek for a Manufacturing Problem
Download the following spreadsheet-
Use the spreadsheet below as a base for determining a
GoalSeek & Scenario Exercise - Grade Problem-Excel Sheet.xlsx
Use the spreadsheet (above) as a basis for creating a final grade calculator like the one below-
Also, use the Scenario Manager to create 3 different scenarios based on a "Bad" (low scores), "OK", and "Great" (high scores) on Quiz 4, Mini-quizzes, and Homework, and the Broadway Cafe project. Save each scenario under the names- Bad, OK, and Great.