To ensure the success of your business, it is important to keep track of your customers' orders so you will not miss an opportunity to earn. Create a Purchase Order Inventory using an electronic spreadsheet that contains the data below. Make sure to use Function Arguments to help you generate information. Table 1: Purchase Order Inventory

1. A column for Customers' Names (at least 5 names)

2. A column for products they ordered (3 products)

3. A column for prices (to save you time for encoding, a VLOOKUP Function)

4. A column for order quantity

5. A column for the total amount per order

6. A column for [remarks] which will indicate if the order is (Retail) or (Bulk) uses the IF Function for this. Set the number of orders for Retail or Bulk)
Table 2: Summary of Order

1. A column for products

2. A column for the total number of orders per product 3. Two columns that will generate the count [Bulk) and (Retail] orders. Taane