| A | B |
|---|
| All formulas begin with which character? | = |
| In order to display all formulas in your worksheet, what do you do? | Click the Show Formulas command button on the Formulas tab. |
| An equation that performs calculations on values in a worksheet is also known as a/an _______________. | formula |
| A value is usually a number or which of the following? | cell address |
| Calculation operators include which of the following? | arithmetic, comparison, text concatenation, reference |
| In order to view the formula in the active cell, what do you do? | Double-click the active cell. |
| Parentheses inside of parentheses are known as which of the following? | nested |
| Which of the following describes the performance of the first calculation of a formula? | on the innermost set of parentheses |
| Which calculation would be performed first in this formula? (((3+1)*((2+2)-2)*(1*1)))* (4+5) | (2+2) |
| During formula modification, you can revert back to the original formula by pressing which key? | Esc |
| When modifying a spreadsheet, to revert back after pressing the Enter key, what do you click? | Undo button |
| Which of the following is the arithmetic operator for addition? | + |
| Which of the following is the arithmetic operator for subtraction? | - |
| Which of the following is the arithmetic operator for multiplication? | * |
| Which of the following is the arithmetic operator for division? | / |
| A/an _______________ is a number or text value that is entered directly into a formula. | constant |
| A/an _______________ is a symbol or name that represents something else, such as a cell address or range of cells. | variable |
| A/an ______________ is an equation that performs calculations on values in a worksheet. | formula |
| In order to enter the editing mode and edit your function, which key do you press? | F2 |
| A cell’s location in the worksheet is known as the ________. | cell reference |
| Any formula that includes cells whose values change should include which of the following? | cell reference |
| When a cell identifier adjusts automatically if you make changes to the worksheet, it is called a/an ________. | relative cell reference |
| Which of the following are method(s) of adding a cell reference into a formula? | pressing the escape key, clicking on the desired cell, & typing |
| Which of the following is true of cells in a formula? | They can be anywhere on a worksheet. |
| A specific cell or range of cells that does not change location regardless of the formulas location is known as a/an ________. | absolute cell reference |
| A/An _________________ uses a specific column or row reference but not both. | mixed cell reference |
| An absolute cell reference requires which symbol? | $ |
| Which of the following is an absolute cell reference? | $A$1 |
| Which of the following is a mixed cell reference? | A$1 |
| When copying a formula, which of the following apply? | The relative reference automatically adjusts. & The absolute reference does not adjust. |
| Cell references in another workbook are considered ______________________. | external references |
| When referencing data in another workbook, you must use which of the following under which conditions? | square brackets ([]) and both workbooks must be open |
| Which of the following descriptors apply to cell ranges? | contiguous, noncontiguous, groups of cells, sizes can be can be changed, can be named, & can be used in formulas |
| How can you view named ranges? | by viewing the Name box next to the formula bar |
| Which of the following is true of naming a range of cells? | It enables you to find the location quickly. |
| Which of the following is a method of naming a range of cells? | On the Formulas tab, select Define Name. |
| Which of the following statements applies to named cell ranges? | They cannot be included in a formula. |
| The Name Manager, where named cell ranges can be edited, is on which tab? | Formulas |
| In the Paste Name dialog box, in order to add all of the named ranges and address data, click ____________. | Paste List |
| Which is the formula to add all cells in a range called SALES? | =Sum(Sales) |
| In the Defined Names group, you can add Named Ranges to formulas by selecting which of the following? | Use in Formula |
| Which is the formula to multiply all cells in a range called DATA? | =product(DATA) |
| Which of the following is not an arithmetic operator? | ] |
| In Excel, what is the result of =1 + 3 * 2 / 2 - 1? | 3 |
| Per the order of operations, which of the following is calculated first | Negative number (-) |
| Which of the following refers to an unnamed range in the current worksheet? | =SUM(C2:E12) |
| Which of the following shows a formula for a reference to another worksheet in the same workbook? | =Q3Expenses!A19 |
| Which of the following shows a formula for a reference to another workbook? | =[Media.xlsx]MasterList!$D$10 |
| Which of the following is an acceptable name for a named range? | subtotal_west |
| Which of the following is an example of an absolute cell reference? | $A$9 |
| Which of the following is an example of a mixed cell reference? | A$9 |
| Which of the following can you not do using the Name Manager? | Enter values into a range |
| To allow Excel to distinguish formulas from data, all formulas begin with an equal sign (=). | True |
| Regarding a named range, the scope of a name is the location within which Excel recognizes the name without qualification. | True |
| Excel recognizes a construct like 3+4= as a legitimate formula. | False |
| Range names may begin with the caret (^) character. | False |
| You cannot use a named range in a formula that references another worksheet. | False |
| Range names cannot be the same as a cell reference, such as C10 or $D$8 | True |
| Once you name a range, you can change the size of the range using the Name Manager. | True |
| You can create a new range by selecting the cells and typing a name in the Name box next to the formula bar. | True |
| The order of operations determines which parts of a formula are calculated before other parts of the formula. | True |
| The formula = 6 * 2 / 3 produces the same result as =6 * (2 / 3). | True |
