Filetype Excel XLS | Posted on 17 Aug 2022 | 3 years ago
Authentication
digital resources
206x Filetype XLS File size 0.03 MB Source: home.adelphi.edu
Sheet 1: fruit sheet
| mango | peach | kiwi | Instructions: | |||
| plum | apple | banana | 1. Click on cell E5 to see the formula | |||
| avocado | pear | lemon | 2. Copy E5 to F6 to see what excel changed the formula to | |||
| 3. Double click on cell E5 to change the formula to =B$2 | ||||||
| apple | 4. Copy E5 to F6 again to see how excel changes the formula this time. | |||||
| 5. Change cell E5 to =$B2 | ||||||
| 6. Copy E5 to F6 again to see how excel changes the formula. | ||||||
| 7. Change cell E5 so that when you copy it to F6 later, it will still show apple. |
| Stocks | current holdings | value if expected increase | Instructions | ||
| GE | $52,323.00 | $57,555.30 | 1. Click on cell C3 to see the formula that calculates the current holdings times 1 plus the hoped for rate of increase. | ||
| I | $22,333.00 | 2. change the rate of 10% (cell D10) to another percentage to see how the formula works. | |||
| AMZN | $5,553.00 | 3. Change the formula in C3 so you can copy it down to all the other stocks to calculate their value if the hoped for rate of increase happens. | |||
| IBM | $40,000.00 | ||||
| JP | $20,000.00 | ||||
| Hoped for rate of increase: | 10% |
| Hello | Amy | Tom | INSTRUCTIONS | ||
| Goodbye | Karen | Bob | 1. Enter a formula in cell A5 to show "Hello Amy", using A1 and B1. | ||
| Good to see you | Mary | Harry | 2. Change the formula in A5 so that you can copy it to A6 & A7 to say everything possible to Amy. It should look like the following: | ||
| 5 | Hello Amy | ||||
| 6 | Goodbye Amy | ||||
| 7 | Good to see you Amy | ||||
| 3. Change that formula in A5 so that you can copy it to C5 - C7 to say Hello to Amy and Tom, Goodbye to Karen and Bog and "Good to See you" to Mary and Harry. |
no reviews yet
Please Login to review.
