MSIS 3223 Exam 1 – Okstate Questions
& Answers(RATED A+)
Addition in excel - ANSWER+
Subtraction in Excel - ANSWER-
Multiplication in Excel - ANSWER*
Division in Excel - ANSWER/
Raised to the power (exponentiation) - ANSWER^
How 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^3/100-73
relative address - ANSWERA relative address uses just the row and column label in the cell reference
(for example A4 or C23)
absolute address - ANSWERAn absolute address uses a dollars sign ($) before either the row or
column or both (for example $A2, C$23, or $B$15)
How do you keep JUST a row fixed, but not the column? - ANSWERUsing a dollar sign ($) before a
row label (for example B$4) keeps the reference fixed to row 4 but allows the column reference to
change if the formula is copied to another cell.
How do you keep both the column and row fixed? - ANSWERA dollar sign before both the row and
column (for example $B$4) will keep the reference fixed for both the row and column.
How do you copy a formula down a column and across a row? - ANSWERfirst select the cell or range,
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
, What is the alternate way to copy a formula only using your keyboard? - ANSWERAnother way to
copy a formula in Excel is to select the cell with the formula to be copied, and then press Ctrl-C on
your Windows keyboard, click on the cell you wish to copy to and then press Ctrl-V in Windows. With
a MAC, use the Command key rather than Ctrl
What is the easiest way to locate a particular function? - ANSWERselect a cell and click on the Insert
function button (fx) which can be found under the ribbon next to the formula bar
MIN(range) - ANSWERfinds the smallest value in a range of cells
MAX(range) - ANSWERfinds the largest value in a range of cells
SUM(range) - ANSWERfinds the sum of values in a range of cells
AVERAGE(range) - ANSWERfinds the average or mean of the values in a range of cells
COUNT(range) - ANSWERfinds the number of cells in a range that contains numbers
COUNTIF(range, criteria) - ANSWERfinds the number of cells within a range that meet a specified
criterion
Net Present Value (NPV) - ANSWERmeasures the worth of a stream of cash flows, taking into account
the time value of money.
Discount Rate - ANSWERreflects the opportunity costs of spending funds now versus achieving a
return through another investment, as well as the risks associated with not receiving returns until a
later time.
Positive NPV? - ANSWERmeans that the investment will provide added value because the projected
return exceeds the discount rate
Descriptive analytics - ANSWERthe most commonly used and most-well understood type of analytics.
Descriptive analytics summarizes data into meaningful charts and reports, for example, about
budgets, sales, revenues, or cost
& Answers(RATED A+)
Addition in excel - ANSWER+
Subtraction in Excel - ANSWER-
Multiplication in Excel - ANSWER*
Division in Excel - ANSWER/
Raised to the power (exponentiation) - ANSWER^
How 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^3/100-73
relative address - ANSWERA relative address uses just the row and column label in the cell reference
(for example A4 or C23)
absolute address - ANSWERAn absolute address uses a dollars sign ($) before either the row or
column or both (for example $A2, C$23, or $B$15)
How do you keep JUST a row fixed, but not the column? - ANSWERUsing a dollar sign ($) before a
row label (for example B$4) keeps the reference fixed to row 4 but allows the column reference to
change if the formula is copied to another cell.
How do you keep both the column and row fixed? - ANSWERA dollar sign before both the row and
column (for example $B$4) will keep the reference fixed for both the row and column.
How do you copy a formula down a column and across a row? - ANSWERfirst select the cell or range,
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
, What is the alternate way to copy a formula only using your keyboard? - ANSWERAnother way to
copy a formula in Excel is to select the cell with the formula to be copied, and then press Ctrl-C on
your Windows keyboard, click on the cell you wish to copy to and then press Ctrl-V in Windows. With
a MAC, use the Command key rather than Ctrl
What is the easiest way to locate a particular function? - ANSWERselect a cell and click on the Insert
function button (fx) which can be found under the ribbon next to the formula bar
MIN(range) - ANSWERfinds the smallest value in a range of cells
MAX(range) - ANSWERfinds the largest value in a range of cells
SUM(range) - ANSWERfinds the sum of values in a range of cells
AVERAGE(range) - ANSWERfinds the average or mean of the values in a range of cells
COUNT(range) - ANSWERfinds the number of cells in a range that contains numbers
COUNTIF(range, criteria) - ANSWERfinds the number of cells within a range that meet a specified
criterion
Net Present Value (NPV) - ANSWERmeasures the worth of a stream of cash flows, taking into account
the time value of money.
Discount Rate - ANSWERreflects the opportunity costs of spending funds now versus achieving a
return through another investment, as well as the risks associated with not receiving returns until a
later time.
Positive NPV? - ANSWERmeans that the investment will provide added value because the projected
return exceeds the discount rate
Descriptive analytics - ANSWERthe most commonly used and most-well understood type of analytics.
Descriptive analytics summarizes data into meaningful charts and reports, for example, about
budgets, sales, revenues, or cost
