BIS 155 Week 2 Quiz (New)

Order ready-to-submit essays. No Plagiarism Guarantee!

Note:  All our papers are written from scratch by human writers to ensure authenticity and originality.

Question 1. Question : (TCO 2) In Excel, a relative cell reference

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. Question : (TCO 2) Which of the following best describes a mixed cell reference?

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. Question : (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.

abstract

relative

mixed

absolute

Question 4. Question : (TCO 2) In Excel, an argument would be best described by which of the following statements?

Calculates the total of values contained in two or more cells

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

Question 5. Question : (TCO 2) Which of the following describes the AVERAGE function?

Calculates the arithmetic mean of values in a range

Identifies the midpoint value in a set of values

Identifies the highest value in a range

Displays the lowest value in a range

Question 6. Question : (TCO 2) The MIN function would identify the _.

highest value in a range

Tallies of the number of blank cells in a range

lowest value in a range

midpoint value in a range

Question 7. Question : (TCO 2) The NOW function would perform which of the following?

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. Question : (TCO 2) The _ number is the number of the column in the lookup table that contains the return values.

lookup value

column index

lookup table

random

Question 9. Question : (TCO 2) Arithmetic operations, cell references, and _ can be used in Excel formulas.

constants

macros

programs

procedures

Question 10. Question : (TCO 2) To simplify entering ranges in formulas, you can use _.

range names

a cell’s relative location

both an absolute and a relative cell reference

a cell’s specific location

Question 11. Question : (TCO 2) When calculating a PMT function, the RATE would be described best by which of the following?

It is the periodic interest rate, such as a monthly interest rate.

It is the total number of payment periods.

It is a word or a string of characters that represent one or more cells.

It is the present value of the loan.

Question 12. Question : (TCO 7) A _ helps to ensure consistency and standardization for similar workbooks, such as detailed income statements for all 12 months in a year.

template

macro

web query

function

Question 13. Question : (TCO 7) To unlock cells, click the _ tab, then click Format in the Cells group and select Lock Cell.

home

page layout

data

view

Question 14. Question : (TCO 7) You must _ the recording of the macro when you have completed the tasks it was designed to do.

begin

stop

copy

paste

Question 15. Question : (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