Hmwk 1 Solutions_1

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

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

View Full Document Right Arrow Icon
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
Background image of page 1

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

View Full DocumentRight Arrow Icon
Background image of page 2
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

Page1 / 2

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

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online