Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I'm having trouble using VLOOKUP to find the product price. AutoSave O Off SC5 Dynamite Customer Sales (version 1) - AutoRecovered AutoSave off v SC5
I'm having trouble using VLOOKUP to find the product price.
AutoSave O Off SC5 Dynamite Customer Sales (version 1) - AutoRecovered AutoSave off v SC5 Dynamite Customer File Home Insert Page Layout Formulas Data Review ownload Data File: SC5 Data etail companies with today's online, as well as, in-store sales have a lot of data to keep track of! eeping track of sales, costs, and profits on a daily basis is essential to making the most of a busiess. This exercise illustrates how to use the skills presented in this chapter to generate the data eeded on a daily basis by a retail company. 1. Open the data file SC5 Data and save the file to your computer as SC5 Dynamite Customer Sales. 2. Click the Sales Sheet. Format the data set as a table. Choose a style from the styles gallery. 3. Create the following calculated columns. a) 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. [Hint: The Product Table sheet lists the Price and Cost] If any error messages appear, check the Range Lookup. b) In K4, use a formula to calculate Profit. Hint: Profit =(Product Price-Product Cost)* Units Sold AutoSave O Off SC5 Dynamite Customer Sales (version 1) - AutoRecovered AutoSave off v SC5 Dynamite Customer File Home Insert Page Layout Formulas Data Review ownload Data File: SC5 Data etail companies with today's online, as well as, in-store sales have a lot of data to keep track of! eeping track of sales, costs, and profits on a daily basis is essential to making the most of a busiess. This exercise illustrates how to use the skills presented in this chapter to generate the data eeded on a daily basis by a retail company. 1. Open the data file SC5 Data and save the file to your computer as SC5 Dynamite Customer Sales. 2. Click the Sales Sheet. Format the data set as a table. Choose a style from the styles gallery. 3. Create the following calculated columns. a) 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. [Hint: The Product Table sheet lists the Price and Cost] If any error messages appear, check the Range Lookup. b) In K4, use a formula to calculate Profit. Hint: Profit =(Product Price-Product Cost)* Units SoldStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started