Question 2

Each constraint contains a cell reference to a cell in a worksheet, a ____, and a cell reference or a constraint value.

formula

comparison operator

physical limit

function

Question 5

In Solver, if you select the Value of option button, you also must enter a(n) ____.

specific value

name of the worksheet

range name

option name

Question 6

The _______________ function sums a series of products in ranges of identical sizes, called arrays, that are parallel to each other in a worksheet.

SUMPRODUCT

SUMPROD

ADDPRODUCT

ADDPROD

Question 9

By including the constraints in your worksheet, you will have ____.

a record of them for later use

a data-entry reference when you set up Solver

both a and b

neither a nor b