Exam 49: Functions

Only values can be copied from one cell to another.

When you copy and paste a formula one cell below its current spreadsheet location,the cell range in the formula changes to reflect its new location.This is an example of a(n)____.

By default,the SUM function is applied when you click the AutoSum button in the Editing group.

It is possible to refer to the same cell reference in multiple worksheets.

When creating a VLOOKUP formula,the table range entry should be based on relative references so the formula produces correct results when copied to a new location.

In the function =VLOOKUP(C1,A1: B9,2,False),the A1: B9 assignment indicates the ____.

A formula in cell Z10 references values found in cells A1,B1,and C1.The cursor is situated in cell C1.Clicking Excel's Trace Dependents button creates red arrows pointing from cell ____.

Once you have completed a payment analysis calculation using the PMT function,you may want to perform a(n)____ analysis to predict future changes.

Which of the following items is NOT needed in order to calculate the cost of a car loan?

Which of the following functions determines the number of times the word "No" appears in a range of cells?

When an auto loan's terms are an 8%-per-year interest rate,seven years in length,and a purchase price of $20,000,what value should be entered in the Rate field?

Which of the following selections is a valid formula using relative references?

To define the average score in a range of test scores,you should use the ____ function.

The VLOOKUP function refers to the same cell or range of cells on multiple worksheets.

An absolute reference doesn't change when the formula referencing it is copied to another cell.

In an Excel calculation result,an expense will appear in red.

The first piece of information that the VLOOKUP function requires is the ____.

One purpose of the PMT function is to help you calculate the payment for a mortgage loan that has a fixed rate of interest.

The ____ function examines whether a certain condition in a spreadsheet could be true or false.

In the Error Checking dialog box,clicking the "Help on this Error" button requires an Internet connection so that you can access Microsoft's online help.