excel sheet
Syedameer98
IL_EX19_EOM2-1_SyedAmeer_1.xlsxDocumentation
| Illustrated Excel 2019 | Module 2: End of Module Project 1 | |
| Hargrove Home Improvement | |
| FORMATTING A WORKSHEET | |
| Author: | syed ameer |
| Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website. | |
Inventory
| Lawn and Garden Department | markup -> | 1.35 | |||||
| Store 124 | |||||||
| Item | Price Paid | Sold By | On Hand | On Hand Valwe | Sale Value | ||
| Rose bush | 10.5 | each | 20 | 210.00 | 283.5 | ||
| Hydrangea | 15.1 | each | 10 | 150.90 | 203.715 | ||
| Day lily | 5.9 | each | 15 | 88.35 | 119.2725 | ||
| Petunia | 30.6 | flat | 13 | 397.67 | 536.8545 | ||
| Daisy | 1.2 | each | 15 | 18.60 | 25.11 | ||
| Geranium | 32.6 | flat | 12 | 391.08 | 527.958 | ||
| Impatiens | 24.6 | flat | 15 | 369.00 | 498.15 | ||
| Lavender | 4.4 | each | 15 | 65.70 | 88.695 | ||
| Hosta | 5.2 | each | 25 | 130.75 | 176.5125 | ||
| Peony | 10.0 | each | 10 | 99.50 | 134.325 | ||
| Pansy | 24.3 | flat | 12 | 292.08 | 394.308 |
