- Submitted By: assignment11
- Date Submitted: 03/08/2016 8:53 PM
- Category: Miscellaneous
- Words: 4144
- Page: 17

DEVRY BIS 155 Week 2 Quiz Data Analysis with Spreadsheets with Lab

Check this A+ tutorial guideline at

http://www.assignmentcloud.com/bis-155/bis-155-week-2-quiz-data-analysis-with-spreadsheets-with-lab

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

- DEVRY BIS 155 Week 4 Quiz Data Analysis with Spreadsheets with Lab
- DEVRY BIS 155 Week 5 Quiz Data Analysis with Spreadsheets with Lab
- DEVRY BIS 155 Week 1 Quiz Data Analysis with Spreadsheets with Lab
- DEVRY BIS 155 Week 5 iLab Data Analysis with Spreadsheets with Lab
- DEVRY BIS 155 Week 4 iLab Data Analysis with Spreadsheets with Lab
- DEVRY BIS 155 Week 1 iLab Data Analysis with Spreadsheets with Lab
- DEVRY BIS 155 Week 3 iLab Data Analysis with Spreadsheets with Lab
- BIS 155 Lab 5 of 7: Bruno's Pizza Analysis
- BIS 155 LAB 2 OF 7 EXCEL’S ADVANCED FORMULAS & FUNCTIONS
- BIS 155 LAB 5 OF 7 BRUNO’S PIZZA ANALYSIS