Excel Chapter 2 Multiple Choice
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
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
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 totals, averages, or other statistical information without creating a formula: a. AutoCalculate b. AutoSum c. AutoCount d. AutoFunction e. AutoRun
a. AutoCalculate
this excel feature allows users to use common arithmetic operations to perform a calculation: 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
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 is 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 parenthesis
This symbol alerts Excel that you are entering a formula and not text: a. * b. $ c. = d. # e. ^t
c. =
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 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. PERLOAN e. PAYPCT
c. PMT
This useful Excel function evaluates a specified condition or statement and returns one value if the condition or statement is true and another value if it is false: a. COUNT b. LOOKUP c. HLOOKUP d. IF e. EVAL
d. IF
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
