In June, for all products sold, what was the total profit earned? Sort the results by Country, then Name both in (A/Z).ħ. Answer the following question by filtering the data accordingly. Place this new sheet to the right of the Online Sales by Date sheet. Make a copy of the Sales sheet and rename it June Sales by Country.
What was the total Profit for Online Sales? Sort the results by Date Sold (A/Z).Ħ. Place this sheet to the right of the Sales sheet. Make a copy of the Sales sheet and rename it Online Sales by Date. Format columns I, J, and K as currency with two decimal places.ĥ. Hint: Profit =(Product Price-Product Cost)*Units SoldĤ. If any error messages appear, check the Range Lookup.ī) In K4, use a formula to calculate Profit. Create the following calculated columns.Ī) In I4, and J4, use a VLOOKUP function that will look up the Product Price and Product Cost based on the Product Sold column which lists an ID number. Choose a style from the styles gallery.ģ. Open the data file SC5 Data and save the file to your computer as SC5 Dynamite Customer Sales.Ģ. This exercise illustrates how to use the skills presented in this chapter to generate the data needed on a daily basis by a retail company.ġ. Retail companies with today’s online, as well as, in-store sales have a lot of data to keep track of! Keeping track of sales, costs, and profits on a daily basis is essential to making the most of a business. 5.5 Scored Assessment Tables for a Retail Company
0 kommentar(er)
