New game
Download
SCORM download
To be used in an LMS (Moodle, Blackboard...)
Regular download
To be published on a website or blog.
Downloading games is an exclusive feature for users with an Academic Plan or a Commercial Plan.
Get your Academic Plan or your Commercial Plan now and start integrating your games into your LMS, website or blog.
Get Academic Plan
If you wish, you can download a demo game here and test its integration:
Share game
Quiz
Quiz

Excel Solver: Decision-Making Quiz

Integrate it into your platform
G. Classroom M. Teams
You can integrate the game into an LMS compatible with LTI 1.1 or LTI 1.3 such as Canvas, Moodle, or Blackboard. This way, the scores will be automatically saved into the platform’s gradebook.
Download
You have exceeded the maximum number of games you can integrate into Google Classroom with your current Plan.

To integrate as many games as you want in Google Classroom, you need an Academic Plan or a Commercial Plan.

Get Academic Plan
You have exceeded the maximum number of games you can integrate into Microsoft Teams with your current Plan.

To integrate as many games as you want in Microsoft Teams, you need an Academic Plan or a Commercial Plan.

Get Academic Plan
Downloading games is an exclusive feature for users with an Academic Plan or a Commercial Plan.

Get your Academic Plan or your Commercial Plan now and start integrating your games into your LMS, website or blog.

If you wish, you can download a demo game here and test its integration:

Get Academic Plan

Excel Solver: Decision-Making Quiz

Quiz

Played 0
Create copy

About this activity

Solver basics for optimization

Created by

Bedour Ghamdi
Bedour Ghamdi
Saudi Arabia

Download the paper version to play

Make your own free game from our game creator
Compete against your friends to see who gets the best score in this game
Make challenge

Top Games

 %
Anonymous
Anonymous
 %
%
%
You have exceeded the maximum number of games you can print with your current Plan.

To print as many games as you want, you need an Academic Plan or a Commercial Plan.

Get Academic Plan
Print your game
Excel Solver: Decision-Making Quiz
 

Excel Solver: Decision-Making QuizOnline version

Solver basics for optimization

by Bedour Ghamdi
1

1. What is the main purpose of using Solver in Excel?

2

2. Which of the following is an example of a variable cell in Solver?

3

3. What is a 'Shared Resource' in Solver terms?

4

4. When setting the objective cell to improve profits, which option is used?

5

5. Which section of the data table contains selling prices and fixed costs?

6

6. If a constraint value 40000 => 18B is given, what does it imply?

7

7. What is the main purpose of comparing the baseline to the extended scenario?

8

8. For the constraint involving number of balls, which relation is correct?

9

9. Which type of cell represents net income in Solver terms?

10

10. When Solver aims to maximize profit, what value is sought?

Feedback

Solver searches for the best possible solution within defined limits.

Variable cells are the ones Solver can change to optimize the result.

Shared resources affect multiple parts of the model.

To maximize profit, choose the Max objective.

Constants hold data that generally do not change during solving.

Constraints limit the feasible solution space.

Baseline vs extended helps assess impact of changes.

The correct relational constraint is to ensure B3 is not less than B4.

Net income is typically defined as the objective (target) cell.

Profit is optimized by seeking the maximum attainable value.

 
Are you sure you want to leave the page?

If you leave the page, you will lose your game progress.