complete the Solver Parameters dialog box NOTE: The value displayed in the Value of: box must be the constant on the right-hand side of the equation (80).

complete the Solver Parameters dialog box.

complete the Solver Parameters dialog box Click on cell B13.

NOTE: The cell displayed in the Set Target Cell: box must contain the formula for the left-hand side of the equation (cell B13) Using Solver

enter formula NOTE: The function AVERAGE entered in cell B13 returns the average of the values in cells B2:B11 blank cells are ignored.

enter formula Variable values in cells B10 and B11 Left-hand side of equation in cell B13 NOTE: These cells will be colored to indicate that they are essential for Solver.

RememberР В Р вЂ Р В РІР‚С™Р вЂ™Р’В¦ 90 + 88 + 78 + 68 + 84 + 82 + 66 + 74 + x + y = 80 10 x y Preparing the Worksheet for Solver

enter labels and constants Enter constants in cells B2:B9.

enter labels and constants NOTE: These labels are not essential for the use of Solver.enter labels and constants Enter labels in cells A1:A13 and B1.obtain equation to be solved You are looking for x = score on 9th quiz (0Р В РЎвЂ”Р Р†Р вЂљРЎв„ўР В РІвЂљВ¬ x Р В РЎвЂ”Р Р†Р вЂљРЎв„ўР В РІвЂљВ¬100) y = score on 10th quiz (0Р В РЎвЂ”Р Р†Р вЂљРЎв„ўР В РІвЂљВ¬ y Р В РЎвЂ”Р Р†Р вЂљРЎв„ўР В РІвЂљВ¬100) so that NOTE: When using Excel Solver to solve an equation make sure the right-hand side is a constant.What scores do you need to earn on the 9th and 10th final quizzes in order to meet your goal average of 80 points? * from FCL Excel Notes by Joyce Gordon, Babson College, 1998.Your quiz scores on the first eight quizzes are given in the table below.You would love to have a quiz average of 80 points (or better) in the QTM1300 course by the end of the semester.Solving Equations with Excel Solver for Microsoft Excel 2000

Solver for excel 2000