.png){kind=logo}
1. What is the meaning of each of the following error messages: • ###### - insufficient width to display value • #NAME? - Unrecognized text in a formula • #N/A No answer • #REF! Invalid cell reference • #VALUE! Wrong argument type of operand • #NUM! Invalid numeric values in a formula or function • #DIV/0! Division by zero 2. The formula =1,100/25 is entered into in a cell exactly as shown. Will Excel be able to calculate a result based on this formula, explain? NO – it cannot interpret this – as the comma is not a legal character within this formula.. it will give you an error message. 3. If you enter =12-1*10 in a cell exactly as shown, what value would result? 2 4. List each of the following operations in order of precedence, from 1 to 4 (first to last): • addition and subtraction (4) • ( ) parentheses (1) • multiplication and division (3) • exponentiation (2) 5. When you write a formula, why should you use cell references rather than typing in values directly into the formula? – If input values are later updated they need only be modified in one place- so that any subsequent formulas that use this value via a cell reference are automatically updated. 6. In the worksheet below, cell A3 contains the formula =A1+A2. Explain the most likely reason the value calculated appears to be incorrect. - Values displayed are not the precise values stored. 7. Referring to the preceding worksheet, if you wrote the formula =B1*5, what value would result, assuming the displayed value is the precise value? .5 or 50% 8. What formula would you write to do each of the following: a. Add a range of numbers in cells B2:B12. =SUM(B2:B12) b. Find the largest value in cells C2:F2. =MAX(C2:F2)
.png)