Excel Assignment ACCTG 333- Professor Perols a specific order header row and a specific item. Each row also shows the quantity, unit price, and discount for the sale of the item. Recall that in the Systems Understanding Aid (SUA) assignment, the top part of orders contained OrderID, date, customer information, and supplier information while the bottom part contained rows with information about the actual items sold (this structure of storing the header portion and the detail portion is very common for different accounting objects, e.g., purchase orders, receiving reports, invoices, sales orders, and sales invoices). Also note that the other tables contain master tables, e.g., Suppliers, Customers, and Products, where each row contains information related to a single Supplier, Customer, Product, etc. Recall how tables such as Customers and OrderHeaders are associated via the primary and foreign key relationship. No action/answer is required for exercise 2 (just an overall understanding of the data). 3. Cell References and Calculations - In the OrderDetails worksheet, in cell F2, calculate the Lineltem Total as UnitPrice * Quantity * (1-Discount) using cell references. Format this cell as currency with two decimal places and copy down cell F2 to the bottom of the table, i.e., F2 through F2156, using short cut keys: CTRL+C, ARROW LEFT, CTRL+ARROW DOWN, Next < Previous