This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.
View Full 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
 Fall '08
 drexel

Click to edit the document details