Devry bis 155 week 2 quiz

4

3

2

1

4

3

2

1

4

3

2

1

4

3

2

1

4

3

2

1

4

3

2

1

4

3

2

1

4

3

2

1

4

3

2

1

4

3

4

3

1

4

3

2

4

3

2

3

2

1

3

2

1

1

1

DeVry BIS 155 Week 2 Quiz

IF You Want To Purchase A+ Work Then Click The Link Below , Instant Download http://www.hwspeed.com/DeVry-BIS-155-Week-2-Quiz-75847494.htm?categoryId=-1

If You Face

Any Problem E- Mail Us At JOHNMATE1122@Gmail.Com

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

Question 6.6. (TCO 2) Which of the following best describes the COUNT function? (Points : 2) Tallies the number of cells in a range that are not empty.

Tallies the number of blank cells in a range.

Displays the current date.

Tallies the number of cells in a range that contain values.

Question 7.7. (TCO 2) The NOW function would perform which of the following? (Points : 2) Contains another function embedded inside one or more of its arguments.

Evaluates a condition and returns one value if the condition is true and a different value if the condition is false.

Evaluates true or false.

Displays the current date and time.

Question 8.8. (TCO 2) The _____ number is the number of the column in the lookup table that contains the return values. (Points : 2) lookup value

column index lookup table random

Question 9.9. (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) sizing handle pointer fill handle insertion point

Question 10.10. (TCO 2) One benefit of using range names in formulas is that _____ . (Points : 2) it directly or indirectly refers to the cell containing the formula it contains both an absolute and a relative cell reference it identifies the present value of the loan if you copy the formula, you do not have to make the cell reference absolute

Question 11.11. (TCO 2) The PMT function is best described by which of the following? (Points : 2) It is the periodic interest rate, such as a monthly interest rate.

It is the total number of payment periods.

It is the present value of a loan.

It calculates the periodic payment for a loan with a fixed interest rate and a fixed term.

Question 12.12. (TCO 7) Which of the following is NOT an Excel tool used to improve productivity in developing consistently formatted workbooks? (Points : 2) Macros Templates Themes Background

Question 13.13. (TCO 7) Before protecting a worksheet, you should _____ the cells that you want users to be able to edit. (Points : 2) format hide lock unlock

Question 14.14. (TCO 7) By default, a macro records cells as _____ references if they are selected while recording the macro. (Points : 2) absolute relative flexible mixed

Question 15.15. (TCO 7) By default, Excel automatically _____ macros and displays a security warning when a file containing macros is opened. (Points : 2) saves

deletes runs disables Additional Questions to Quiz 2 (TCO 2) In Excel, a function can be defined as a _____.(Points : 2) Predefined formula that performs a calculation Cell reference or a value List of values and defined names as you enter data into a spreadsheet Set of rules that govern the structure and components for a formula (TCO 2) The rules for constructing a function can be referred to as the function's _____.

Synthesis Synergy synchronization syntax (TCO 2) In the arguments to an IF function, the condition that is evaluated to determine if it is true or false is also sometimes called a _____.

Logical test Lookup value Breakpoint Table array action (TCO 2) If you enter an = and the first few letters of a function in the formula bar,

Excel will display a drop-down list of functions beginning with those letters. This feature is called _____.

Syntax Helper Formula AutoComplete Formula Wizard Function Finder (TCO 2) Which of the following best describes the HLOOKUP function?

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 7) Which of the following file formats can store macros?

XLSM CSV XML XLSX (TCO 7) To create a macro button, click the _____ tab, click Insert, then click Button in the Form Controls section of the Insert palette.

View Data Insert

Developer