Excel Ch. 2 Working with Formulas and Functions

To reference cells in another worksheet, but in the same workbook in which the current formula resides, use a: a. 3D cell reference b. Link c. LOOKUP d. Relative Cell reference e. FINDIF

a. 3D cell reference

This excel feature allows you to view tools, averages, or other statistical information without creating a formula: a. auto calculate b. auto sum c. auto count d. auto funcation e. auto run

a. auto calculate

This excel feature allows users to evaluate values and return a result: a. formulas b. formatting c. filters d. insertions e. components

a. formulas

In excel, the acronym "Please Excuse my dear aunt sally" helps the user remember: a. order of operations b. exponents c. cell references d. macros e. hierarchies of numbers

a. order of operations

When you are creating formulas using a cell location, the default cell reference is: a. relative b. absolute c. constant d. fixed e. mixed

a. relative

This type of cell reference does not change when copied and remains in a fixed position during operations: a. relative b. absolute c. constant d. fixed e. mixed

b. absolute

It it important to remember that Excel calculates these operations before any others are performed: a. exponents b. items in parentheses c. mathematical expressions d. fixed cell references e. mixed cell references

b. items in parentheses

This symbol alerts excel that you are entering a formula ad not text: a. * b. $ c. = d. # e. ^t

c. =

This function calculates loan payment amounts when the borrower makes regular payments and the loan has a constant interest rate: a. STDEV b. AMORLINK c. PMT d. PERCLOAN e. PAYCT

c. PMT

When a formula contains a typographical error, unnecessary or missing punctuation, incorrect order of arguments, or an incorrect cell reference, it returns: a. an error message that begins with an exclamation point (!) b. a blank cell c. an error message that begins with a number sign (#) d. a green alert e. a red alert

c. an error message that begins with a number sign (#)

Excel comes with many built-in formulas called: a. formulas b. factors c. functions d. operations e. calculations

c. functions

This useful Excel function evaluates a specified condition or statement and returns one value if they condition or statement is true and another value if it is false: a. COUNT b. LOOKUP c. HLOOKUP d. IF e. EVAL

d. IF

The excel tool button that allows you to step through each part of a formula is called: a. trace precedents b. trace dependents c. error checking d. evaluate formula e. watch window

d. evaluate formula

A handy keyboard shortcut that turns a cell address entered in a formula into an absolute cell reference, adding the dollar sign in front of the column and row addresses, is: a. F1 b. F5 c. ^$ d. ctrl+* e. F4

e. F4

The color-coded editing tool that applies different colors to each cell or cell range included within a formula is called the: a. rectangular marquee b. shading tool c. format tool d. cell selector e. range finder

e. range finder