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
- Addition, Meaning of life, Elementary arithmetic, cells C1