Loan / VLookup Assignment
nayo0f033
loan_vlookup_assignment.xlsxShop Loan
| Rubanne Specialties |
| Shop Loan |
| Amount of Loan |
| Period (years) |
| Interest Rate (per year) |
| Payment (per month) |
Order Form
| Rubanne Specialties | ||||
| Order Form | ||||
| Customer Name | Replace with your name | |||
| Customer Number | BA131 | |||
| Order Date | Today's date as a function | |||
| Item | Description | Quantity | Unit Price | Order Amount |
| Total: | $0.00 | |||
Lastname_Firstname_4L_Key_Chains
Product Information
| Rubanne Specialties | ||
| Product List | ||
| Style Code | Description | Unit Price |
| K-M | Pop Culture Keychains | $ 8.50 |
| K-R | Fun and Games Keychains | $ 8.75 |
| K-S | Plush Animal Keychains | $ 6.25 |
| K-T | Carabineer Keychains | $ 8.75 |
| M-KF | Lanyard Keychains | $ 5.25 |
| M-MK | Vintage Keychains | $ 8.50 |
| M-TF | Classic Keychains | $ 7.50 |
Lastname_Firstname_4L_Key_Chains
