OMGT 3223 QUESTIONS AND ANSWERS
2026 NEWEST UPDATED 100% CORRECT
QUIZ 1 : The result of entering the formula = -4^2+1 in Excel is - ANSWER>17
: In EXCEL, if cell A3 contains the value 50, then the calculated result for the EXCEL formula =IF(A3>=50,) is -
ANSWER>0
: An HR analyst has developed an analytical model to calculate the staffing cost associated with different HR
policies. The model uses a probability distribution for employee turnover. This model can best be categorized as a: -
ANSWER>Stochastic descriptive model
: Deterministic models assume the independent variable(s) are known with certainty while stochastic models
assume the independent variable(s) contain uncertainty. - ANSWER>True
: Stochastic or Probabilistic models assume that some inputs are not known with certainty. - ANSWER>True
, : Typing =A$2 in a cell would: - ANSWER>fix row 2.
: Which of the following Excel tools is the best choice to solve optimization problems? - ANSWER>Solver
: A cell reference: - ANSWER>represents a cell (or a group of cells) on a worksheet
: If the EXCEL formula =A3+B$2 is copied from one cell to another cell located three rows down and two columns to
the right, the resulting formula will be ... - ANSWER>=C6+D$2
: If the EXCEL formula =A$3+$B2 is copied from one cell to another cell located 3 rows down and two columns to
the right, the resulting formula will be ... - ANSWER>=C$3+$B5
: In order for an analytical model to be useful, all the assumptions must be an accurate representation of reality. -
ANSWER>False
: Deterministic models: - ANSWER>Assume the values of independent variables are known with certainty.
2026 NEWEST UPDATED 100% CORRECT
QUIZ 1 : The result of entering the formula = -4^2+1 in Excel is - ANSWER>17
: In EXCEL, if cell A3 contains the value 50, then the calculated result for the EXCEL formula =IF(A3>=50,) is -
ANSWER>0
: An HR analyst has developed an analytical model to calculate the staffing cost associated with different HR
policies. The model uses a probability distribution for employee turnover. This model can best be categorized as a: -
ANSWER>Stochastic descriptive model
: Deterministic models assume the independent variable(s) are known with certainty while stochastic models
assume the independent variable(s) contain uncertainty. - ANSWER>True
: Stochastic or Probabilistic models assume that some inputs are not known with certainty. - ANSWER>True
, : Typing =A$2 in a cell would: - ANSWER>fix row 2.
: Which of the following Excel tools is the best choice to solve optimization problems? - ANSWER>Solver
: A cell reference: - ANSWER>represents a cell (or a group of cells) on a worksheet
: If the EXCEL formula =A3+B$2 is copied from one cell to another cell located three rows down and two columns to
the right, the resulting formula will be ... - ANSWER>=C6+D$2
: If the EXCEL formula =A$3+$B2 is copied from one cell to another cell located 3 rows down and two columns to
the right, the resulting formula will be ... - ANSWER>=C$3+$B5
: In order for an analytical model to be useful, all the assumptions must be an accurate representation of reality. -
ANSWER>False
: Deterministic models: - ANSWER>Assume the values of independent variables are known with certainty.
