Click on the correct response for each question below.
|
1 | | This is not one of the first four steps involved in producing a workbook. |
| | A) | Enter text, values, and formulas into the worksheet. |
| | B) | Create documentation for the worksheet. |
| | C) | Modify formulas that display incorrect results. |
| | D) | Test the worksheet’s robustness. |
|
|
2 | | Excel is being signaled to write a formula when this is entered into a cell. |
| | A) | Parentheses |
| | B) | Mathematical operator |
| | C) | Equal sign |
| | D) | Smart Tag |
|
|
3 | | Which of the following is not correct with regard to the precedence order rules for the formula =A1\(C1+C4)*D1^E1? |
| | A) | The value of C1+C4 is computed first because it is inside the parentheses. |
| | B) | Excel computes the result of (C1+C4)*D second. |
| | C) | Excel computes D1^E1 after the value of C1+C4 is computed. |
| | D) | Excel divides A1 by the value derived earlier for C1+C4. |
|
|
4 | | Excel would evaluate the formula, =20*10/4*8, and return this answer. |
| | A) | 6.25 |
| | B) | 40 |
| | C) | 400 |
| | D) | 232 |
|
|
5 | | In the formula, =10+5+15+25/5, Excel computes this first. |
| | A) | 10+5 |
| | B) | 5+15 |
| | C) | 25/5 |
| | D) | 15+25 |
|
|
6 | | In the formula, =B1/B2+B3, which of the following is the correct precedence? |
| | A) | Addition higher precedence than division |
| | B) | Equal precedence among the two operators; proceed right to left |
| | C) | Equal precedence among the two operators; proceed left to right |
| | D) | Division higher precedence than addition |
|
|
7 | | In Excel, this is a prerecorded formula that provides a shortcut for complex calculations. |
| | A) | Value |
| | B) | Data Series |
| | C) | Field |
| | D) | Function |
|
|
8 | | This is not a function category in Excel. |
| | A) | Logical |
| | B) | Data Series |
| | C) | Financial |
| | D) | Text |
|
|
9 | | Which of the following is not one of the syntax rules? |
| | A) | The order in which you list the function’s arguments |
| | B) | The precedence of the arguments |
| | C) | Whether or not the function has arguments |
| | D) | Properly spelling the function’s name |
|
|
10 | | In Excel, it is common to see this function with one argument, a cell range. |
| | A) | SUM |
| | B) | NOW |
| | C) | AVERAGE |
| | D) | MIN |
|
|
11 | | When building a worksheet, it is a good idea to create spreadsheet titles prior to creating row and column labels. |
| | A) | True |
| | B) | False |
|
|
12 | | Excel will make assumptions about which group of contiguous cells you want to total and creates a SUM function based on cells adjacent to the current active cell. |
| | A) | True |
| | B) | False |
|
|
13 | | By selecting a range of cells, users can see a quick view of the sum without creating an Excel formula. |
| | A) | True |
| | B) | False |
|
|
14 | | When a formula includes numerous mathematical operators, Excel will evaluate the formula from right to left. |
| | A) | True |
| | B) | False |
|
|
15 | | AVERAGE, MAX, MIN, and NOW are all categorized as statistical functions. |
| | A) | True |
| | B) | False |
|
|
16 | | A function's name describes what action the cell will take. |
| | A) | True |
| | B) | False |
|
|
17 | | The Paste Function button is part of the Standard toolbar. |
| | A) | True |
| | B) | False |
|
|
18 | | When formulas are identical, with the exception of their cell references, it is best to take advantage of Excel's ability to copy formulas. |
| | A) | True |
| | B) | False |
|
|
19 | | When a function or formula is copied vertically, Excel changes the column letters automatically while leaving the row number unchanged. |
| | A) | True |
| | B) | False |
|
|
20 | | A dollar sign placed before both the column and row portions of the cell reference indicate that a cell reference is absolute. |
| | A) | True |
| | B) | False |
|