# BIS 155 Quiz Week 2

$4.75

**BIS 155 Quiz Week 2 **

(TCO 2) In the arguments to an IF function, the condition that is evaluated to determine if it is true…

## Description

**BIS 155 Quiz Week 2 **

BIS 155 Quiz Week 2

**A+**

**(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 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

Absolute

**(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

**(TCO 2) The _____ function returns a result based on a condition. (Points : 2)**

Max

Today

Find

If

**(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

**(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

**(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

**(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

**(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

**(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

**(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

(**TCO 7) ****A _____ is a partially completed workbook that you can use to create other workbooks that have the same structure and purpose.**** (Points : 2)**

Theme

Style

Template

Macro

**(TCO 7) ****To unlock cells, click the _____ tab, then click Format in the Cells group and select Lock Cell.**** (Points : 2)**

Home

page layout

data

view

**(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

**(TCO 7) By default, a macro records cells as _____ references if they are selected while recording the macro. (Points : 2)**

Absolute

Relative

Flexible

Mixed

**(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

BIS 155 Quiz Week 2

DeVry