# PDF Archive

Easily share your PDF documents with your contacts, on the Web and Social Networks.

## DEVRY BIS 155 Week 2 Quiz Dat .pdf

Original filename: DEVRY BIS 155 Week 2 Quiz Dat.pdf
Author: LENOVO

This PDF 1.5 document has been generated by Microsoft® Office Word 2007, and has been sent on pdf-archive.com on 02/03/2017 at 12:21, from IP address 43.224.x.x. The current document download page has been viewed 117 times.
File size: 326 KB (3 pages).
Privacy: public file ### Document preview

DEVRY BIS 155 Week 2 Quiz Data Analysis

Check this A+ tutorial guideline at
For more classes visit

http://www.assignmentcloud.com
(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
(TCO 2) In Excel, an Argument would be best described by which of the following
statements? (Points : 2)
Calculates the total of values contained in two or more cells.
Displays a list of functions and defined names as you enter a function.

Is an input, such as a cell reference or a value needed to complete a function.
Is a small pop-up description that displays the results of the cell.
(TCO 2) The MIN function would identify the _____. (Points : 2)
The highest value in a range.
Tallies the number of blank cells in a range.
The lowest value in a range.
The midpoint value in a range
(TCO 2) The NOW function would perform which of the following? (Points : 2)
FIND
SEARCH
HLOOKUP
VLOOKUP
(TCO 2) To copy a formula, you may use the _____, which is found in the bottom righthand corner of an active cell. (Points : 2)
The periodic interest rate, such as a monthly interest rate.
Calculates the periodic payment for a loan with a fixed interest rate and fixed term.
Looks up a value in a lookup table where the first column contains the values to
compare with the lookup value.
Looks up a value in a lookup table in which the first row contains the values to
compare with the lookup value.
(TCO 2) One benefit of using range names in formulas is that _____ . (Points : 2)
A cell reference
A function
A formula
A range name

(TCO 2) The PMT function is best described by which of the following? (Points : 2)
It is a set of range names.
It is a word or a string of characters that represent one or more cells.
It is the present value of the loan.
It is why you do not have to make the cell reference absolute in the formula.
(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
(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   