DEVRY BIS155 week 2 quiz

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) In Excel, a function can be defined as a _____.

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

Question 3. Question :

(TCO 2) The rules for constructing a function can be referred to as the function’s _____.

synthesis

synergy

synchronization

syntax

Question 4. Question :

(TCO 2) Which of the following describes the SUM function?

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

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

Student Answer: MAX

TODAY

FIND

IF

Question 6. Question :

(TCO 2) Which of the following best describes the COUNT function?

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

(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

Question 8. Question :

(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

:

Question 9. Question :

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

Question 10. Question :

(TCO 2) One benefit of using range names in formulas is that _____ .

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

(TCO 2) The PMT function is best described 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 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. Question :

(TCO 7) Which of the following is NOT an Excel tool used to improve productivity in developing consistently formatted workbooks?

Macros

Templates

Themes

INCORRECT Background

Question 13. Question :

(TCO 7) Before protecting a worksheet, you should _____ the cells that you want users to be able to edit.

format

hide

lock

unlock

:

Question 14. Question :

(TCO 7) Which of the following file formats can store macros?

xlsm

csv

xml

xlsx

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

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.