#### Words of Wisdom:

"The best way to fail is to never try." - Eac1687

# Devry Bis 155 Week 2 Quiz - Updated

• Date Submitted: 03/21/2016 04:19 AM
• Flesch-Kincaid Score: 65.7
• Words: 1008
• Report this Essay
DeVry BIS 155 Week 2 Quiz - Updated
IF You Want To Purchase A+   Work then Click The Link Below For Instant Down Load
IF You Face Any Problem Then E Mail Us At   JOHNMATE1122@GMAIL.COM
DeVry BIS 155 Week 2 Quiz

Quiz
Question 1.1. (TCO 2) In Excel, a relative cell reference: (Points : 2)
indicates a cell's specific location and the reference does not change when you copy the formula.
contains both an absolute and a relative cell reference.
indicates a cell's relative location from the cell containing the formula; the reference changes when you copy the formula.
occurs when a formula directly or indirectly refers to the cell containing the formula.

Question 2.2. (TCO 2) Which of the following best describes a mixed cell reference? (Points : 2)
Occurs when a formula directly or indirectly refers to the cell containing the formula.
Causes a potential error.
Contains absolute or relative cell references, but not both.
Contains both an absolute and a relative cell reference.

Question 3.3. (TCO 2) You have a cell that contains the formula =A1*2. When you copy this formula to other cells, you want it to always reference column A, but you want the row number to change automatically. You should make the A1 in this formula a(n) _____ cell reference. (Points : 2)
abstract
relative
mixed
absolute

Question 4.4. (TCO 2) Which of the following describes the SUM function? (Points : 2)
Identifies the midpoint value in a set of values.
Calculates the total of values contained in two or more cells.
Calculates the arithmetic mean or average of values in a range.
Displays the lowest value in a range.

Question 5.5. (TCO 2) The _____ function returns a result based on a condition. (Points : 2)
MAX
TODAY
FIND
IF...