MSIS 3223 - Nord - Okstate - Exam 1
Questions With Correct Answers!!
Which of the following ways would 10 raised to the power of 2 × 5 raised to
the power of 3/ 100 - 73 be represented in an Excel spreadsheet? - ANSWER10^2 * 5^ - 73
Which of the following is a difference between relative addressing and
absolute addressing when using cell formulas in Excel? - ANSWERA relative address uses just the row
and column label in the cell reference; an
absolute address uses a dollar sign before either the row or column label.
To copy a formula from a single cell or range of cells down a column or
across a row, first________, click and hold the mouse on the small square in
the lower right-hand corner of the cell, and drag the formula to the "target"
cells which you wish to copy. - ANSWERselect the cell or range
The easiest way to locate a particular function is to select a cell and click on
the Insert function button represented by ________ on the Excel ribbon. - ANSWERfx
The Excel function of ________ is used to find the largest value in a range of
cells. - ANSWERMAX(range)
________ measures the worth of a stream of cash flows, taking into account
the time value of money. - ANSWERNet present value
Descriptive analytics: - ANSWERhelps companies classify their customers into segments to develop
specific
marketing campaigns.
Predictive analytics: - ANSWERdetects patterns in historical data and extrapolates them forward in
time
, Which of the following questions will prescriptive analytics help a company
address? - ANSWERWhat is the best way of shipping goods from their factories to minimize costs?
The demand for coffee beans over a period of three months has been
represented in the form of an L-shaped curve. Which form of model was
used here? - ANSWERvisual model
Decision variables: - ANSWERcan be selected at the discretion of the decision maker
Descriptive decision models: - ANSWERdescribe relationships but do not tell a manager what to do.
Prescriptive decision models help: - ANSWERdecision makers identify the best solution to decision
problems.
To select a chart type in Excel from the Charts group, which tab has to be
accessed? - ANSWERInsert tab
Roger wants to compare values across categories using vertical rectangles.
Which of the following charts must Roger use? - ANSWERClustered column chart
Which decision model incorporates the process of optimization? - ANSWERprescriptive
Which of the following is the first phase in problem solving? - ANSWERrecognizing the problem
During which phase in problem solving is a formal model often developed? - ANSWERstructuring the
problem
________ is a logical function that returns one value if the condition is true
and another if the condition is false. - ANSWERIF(condition, value if true, value if false)
Questions With Correct Answers!!
Which of the following ways would 10 raised to the power of 2 × 5 raised to
the power of 3/ 100 - 73 be represented in an Excel spreadsheet? - ANSWER10^2 * 5^ - 73
Which of the following is a difference between relative addressing and
absolute addressing when using cell formulas in Excel? - ANSWERA relative address uses just the row
and column label in the cell reference; an
absolute address uses a dollar sign before either the row or column label.
To copy a formula from a single cell or range of cells down a column or
across a row, first________, click and hold the mouse on the small square in
the lower right-hand corner of the cell, and drag the formula to the "target"
cells which you wish to copy. - ANSWERselect the cell or range
The easiest way to locate a particular function is to select a cell and click on
the Insert function button represented by ________ on the Excel ribbon. - ANSWERfx
The Excel function of ________ is used to find the largest value in a range of
cells. - ANSWERMAX(range)
________ measures the worth of a stream of cash flows, taking into account
the time value of money. - ANSWERNet present value
Descriptive analytics: - ANSWERhelps companies classify their customers into segments to develop
specific
marketing campaigns.
Predictive analytics: - ANSWERdetects patterns in historical data and extrapolates them forward in
time
, Which of the following questions will prescriptive analytics help a company
address? - ANSWERWhat is the best way of shipping goods from their factories to minimize costs?
The demand for coffee beans over a period of three months has been
represented in the form of an L-shaped curve. Which form of model was
used here? - ANSWERvisual model
Decision variables: - ANSWERcan be selected at the discretion of the decision maker
Descriptive decision models: - ANSWERdescribe relationships but do not tell a manager what to do.
Prescriptive decision models help: - ANSWERdecision makers identify the best solution to decision
problems.
To select a chart type in Excel from the Charts group, which tab has to be
accessed? - ANSWERInsert tab
Roger wants to compare values across categories using vertical rectangles.
Which of the following charts must Roger use? - ANSWERClustered column chart
Which decision model incorporates the process of optimization? - ANSWERprescriptive
Which of the following is the first phase in problem solving? - ANSWERrecognizing the problem
During which phase in problem solving is a formal model often developed? - ANSWERstructuring the
problem
________ is a logical function that returns one value if the condition is true
and another if the condition is false. - ANSWERIF(condition, value if true, value if false)
