|
1 | | This basic Excel feature allows users to evaluate values and return a result |
| | A) | Formulas |
| | B) | Formatting |
| | C) | Filters |
| | D) | Insertions |
| | E) | Components |
|
|
|
2 | | This symbol alerts Excel that you are entering a formula and not text: |
| | A) | * |
| | B) | $ |
| | C) | = |
| | D) | # |
| | E) | ^t |
|
|
|
3 | | 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 |
|
|
|
4 | | When a formula contains a typographical error, unnecessary or missing punctuation, incorrect order of arguments, or an incorrect cell reference, it returns: |
| | A) | An exclamation point. |
| | B) | A syntax error notice. |
| | C) | A # sign. |
| | D) | A green alert. |
| | E) | A red alert. |
|
|
|
5 | | 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. |
|
|
|
6 | | When you are creating formulas using a cell location, the default cell reference is: |
| | A) | Relative. |
| | B) | Absolute. |
| | C) | Constant. |
| | D) | Fixed. |
| | E) | Mixed. |
|
|
|
7 | | 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 |
|
|
|
8 | | A handy keyboard shortcut that puts dollar signs ($$) around cell and row address in formulas is: |
| | A) | F1. |
| | B) | F5. |
| | C) | ^$. |
| | D) | Ctrl+*. |
| | E) | F4. |
|
|
|
9 | | 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. |
|
|
|
10 | | 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 |
|
|
|
11 | | In Excel, pre-defined formulas with a specific syntax pattern are called: |
| | A) | Formulas. |
| | B) | Factors. |
| | C) | Functions. |
| | D) | Operations. |
| | E) | Calculations. |
|
|
|
12 | | 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 |
|
|
|
13 | | 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) | PAYPCT |
|
|
|
14 | | This useful Excel function evaluates a specified condition and returns one value if the condition is true and another value if the condition is false: |
| | A) | COUNT |
| | B) | LOOKUP |
| | C) | HLOOKUP |
| | D) | IF |
| | E) | EVAL |
|
|
|
15 | | To identify cells in worksheets other than where the current formula resides, use a: |
| | A) | 3D cell reference. |
| | B) | Link. |
| | C) | LOOKUP. |
| | D) | Relative cell reference. |
| | E) | FINDIF. |
|
|