Quiz: Excel to Solve Equations

Main.ExcelQuiz3 History

Hide minor edits - Show changes to markup

May 17, 2022, at 03:12 AM by 136.36.4.38 -
Added line 66:
Restore
April 28, 2022, at 02:54 PM by 10.35.117.248 -
Added lines 1-65:

(:title Quiz: Excel to Solve Equations:) (:keywords quiz, test, Excel, equations, variables, introduction, course:) (:description Learning assessment on solving equations with Excel.:)

1. How are the number of variables and equations related? Select all that are true.

A. # Variables = # Equations: For linear equations, there is either a unique solution or no solution. For nonlinear equations, there may be multiple or no solution.
(:toggle hide q1a button show="Select":)

(:div id=q1a:)

Correct. Nonlinear equations may also require a good initial guess to numerically solve.

(:divend:)

B. # Variables > # Equations: Additional degrees of freedom. This generally requires an objective function (minimize or maximize a function of the variables) or leads to many potential solutions.
(:toggle hide q1b button show="Select":)

(:div id=q1b:)

Correct. Optimization is needed when there are more variables than equations to select the best feasible solution that satisfies the constraints.

(:divend:)

C. # Variables < # Equations: Additional degrees of freedom. This generally requires an objective function (minimize or maximize a function of the variables) or leads to many potential solutions.
(:toggle hide q1c button show="Select":)

(:div id=q1c:)

Correct. More equations than variables is generally an overdetermined system where there is no combination of variables that can satisfy all of the equations.

(:divend:)

2. The Excel function MMULT allows you to multiply two matrices (i.e. A x B) together with dimensions (n x m) (m x p) where the inner dimensions (m) are the same.

A. True
(:toggle hide q2a button show="Select":)

(:div id=q2a:)

Correct.

(:divend:)

B. A collection of spreadsheet pages
(:toggle hide q2b button show="Select":)

(:div id=q2b:)

Incorrect.

(:divend:)

3. To see the results of the MMULT or MINVERSE function, you must select the result cells, select the input matrices, and then click ALT + ENTER to see the answer.

A. True
(:toggle hide q3a button show="Select":)

(:div id=q3a:)

Incorrect.

(:divend:)

B. False
(:toggle hide q3b button show="Select":)

(:div id=q3b:)

Correct.

(:divend:)

Restore