Quiz: Excel to Solve Equations
Main.ExcelQuiz3 History
Hide minor edits - Show changes to output
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:)
-->%blue%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:)
-->%blue%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:)
-->%blue%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:)
-->%blue%Correct.%%
(:divend:)
->'''B.''' A collection of spreadsheet pages
-->(:toggle hide q2b button show="Select":)
(:div id=q2b:)
-->%red%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:)
-->%red%Incorrect.%%
(:divend:)
->'''B.''' False
-->(:toggle hide q3b button show="Select":)
(:div id=q3b:)
-->%blue%Correct.%%
(:divend:)
(: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:)
-->%blue%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:)
-->%blue%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:)
-->%blue%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:)
-->%blue%Correct.%%
(:divend:)
->'''B.''' A collection of spreadsheet pages
-->(:toggle hide q2b button show="Select":)
(:div id=q2b:)
-->%red%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:)
-->%red%Incorrect.%%
(:divend:)
->'''B.''' False
-->(:toggle hide q3b button show="Select":)
(:div id=q3b:)
-->%blue%Correct.%%
(:divend:)
