{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Hmwk 1 Solutions_1

# Hmwk 1 Solutions_1 - formula =A1 A2 Explain in one sentence...

This preview shows pages 1–2. Sign up to view the full content.

Name __ SOLUTIONS _____________ BUS 220.03 Fall 2010 1. What is the meaning of each of the following error messages: a. ###### insufficient width in cell to display numerical data, or negative date/time b. #NAME? unrecognized text in formula c. #N/A no answer d. #REF! invalid cell reference e. #VALUE! wrong argument type or operand f. #NUM! invalid numeric values in a formula or function g. #DIV/0! division by zero 2. If you enter 2,806+4 in a cell exactly as shown (without an equal sign), what value would result? 2,806+4 3. If you enter =3+2*10 in a cell exactly as shown, what value would result? 23 4. List each of the following operations in order of preference, from 1 to4 (first to last): a. Multiplication and division 3 b. Parentheses ( ) 1 c. Addition and subtraction 4 d. Exponentiation 2 5. When writing formulas, why is it preferable to use cell references rather than typing in values? Everywhere you use a value on worksheet, the calculations will be automatically updated with any changes to that value. 6. In the snapshot of a worksheet below, suppose that cell A3 contains the

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: formula =A1+A2. Explain in one sentence the most likely reason the value calculated appears incorrect. (This is just a snapshot for demonstration, not a real Excel worksheet). The value of “4” was entered in the cell where the formula existed. A B C 1 1 10% 2 2 3 4 4 5 7. Referring to the same worksheet example in 6., if you wrote the formula =B1*120, what value would result (assuming the displayed value is the precise value)? 12 8. What formula would you write to do each of the following: i. Add a range of numbers in cells A2:Z2 =SUM(A2:Z2) ii. Find the largest value in cells B2:B8 =MAX(B2:B8) iii. Find the smallest value in cells B2 through Z12 =MIN(B2:Z12) iv. Find the average value in cells C1 through C10, assuming blank cells will be ignored. =AVERAGE(C1:C10) v. Find the total number of items listed in cells C1 through C10, including any that contain text. =COUNTA(C1:C10)...
View Full Document

{[ snackBarMessage ]}

### Page1 / 2

Hmwk 1 Solutions_1 - formula =A1 A2 Explain in one sentence...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online