Devry Bis 155 Week 2 Quiz - Updated

DeVry BIS 155 Week 2 Quiz - Updated

IF You Want To Purchase A+ Work then Click The Link Below For Instant Down Load

http://www.acehomework.net/?download=devry-bis-155-week-2-quiz-updated

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...