MSIS 3223 (NORD - OKSTATE) EXAM 1 QUESTIONS |GUARANTEED ACCURATE ANSWERS |VERIFIED

MSIS 3223 (NORD - OKSTATE)
EXAM 1 QUESTIONS |GUARANTEED
ACCURATE ANSWERS |VERIFIED

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? -
ACCURATE ANSWERS✔✔ 10^2 * 5^ - 73


Which of the following is a difference between relative addressing and
absolute addressing when using cell formulas in Excel? - ACCURATE
ANSWERS✔✔ 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. - ACCURATE ANSWERS✔✔ 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.
- ACCURATE ANSWERS✔✔ fx


The Excel function of ________ is used to find the largest value in a
range of
cells. - ACCURATE ANSWERS✔✔ MAX(range)


________ measures the worth of a stream of cash flows, taking into
account
the time value of money. - ACCURATE ANSWERS✔✔ Net present
value


Descriptive analytics: - ACCURATE ANSWERS✔✔ helps companies
classify their customers into segments to develop specific
marketing campaigns.


Predictive analytics: - ACCURATE ANSWERS✔✔ detects patterns in
historical data and extrapolates them forward in time


Which of the following questions will prescriptive analytics help a
company


EXAMLINKS
STUDT SMART.