APY 201 Lecture 5: Functions vs Formulas.doc

• School: University of Miami
• Department: Anthropology
• Course: APY 201
• Professor: no

Document Summary

Create the following spreadsheet and complete steps 1 - 8 below: In cell a6 enter the function =sum(a1:a4) and in cell b6 enter the formula =b1+b2+b3+b4: select row 2, then insert a blank row. Notice that what was in a2 is now in a3, what was in a3 is now in a4, etc. If so, what is the new formula: undo the actions from step 2 or recreate the original spreadsheet, entering the function and formula specified in step 1, select cells a3 and b3 and erase (clear) their entries. If so, what is the new formula: undo the actions from step 4 or recreate the original spreadsheet, entering the function and formula specified in step 1, select row 3, then delete it. If so, what is the new formula: undo the actions from step 6 or recreate the original spreadsheet, entering the function and formula specified in step 1, enter the text entry hello in both a3 and b3.