MSIS 3223 - Nord - Okstate -
Exam 1|52 Q’s and A’s
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? - -10^2 *
5^ - 73
- Which of the following is a difference between relative addressing and
absolute addressing when using cell formulas in Excel? - -A 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. - -select 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. - -fx
- The Excel function of ________ is used to find the largest value in a range of
cells. - -MAX(range)
- ________ measures the worth of a stream of cash flows, taking into account
the time value of money. - -Net present value
- Descriptive analytics: - -helps companies classify their customers into
segments to develop specific
marketing campaigns.
- Predictive analytics: - -detects patterns in historical data and extrapolates
them forward in time
- Which of the following questions will prescriptive analytics help a company
address? - -What 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? - -visual model
Exam 1|52 Q’s and A’s
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? - -10^2 *
5^ - 73
- Which of the following is a difference between relative addressing and
absolute addressing when using cell formulas in Excel? - -A 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. - -select 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. - -fx
- The Excel function of ________ is used to find the largest value in a range of
cells. - -MAX(range)
- ________ measures the worth of a stream of cash flows, taking into account
the time value of money. - -Net present value
- Descriptive analytics: - -helps companies classify their customers into
segments to develop specific
marketing campaigns.
- Predictive analytics: - -detects patterns in historical data and extrapolates
them forward in time
- Which of the following questions will prescriptive analytics help a company
address? - -What 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? - -visual model
