Name 23252 Candice Levy Country Congo Product Sold Sales Type SUPASOL Online /9/2016 23263X Central America and the Caribbean DETA200 Online 23254 Lev Sub-Saharan Africa DETABOO Online Units Sold Date Sold - Product Price Product Cost 75 7/8/2016 205/18/2016 23265 Uriel Benton South Africa SUPASO4 Online 14 8/3/2016 23266 Sub-Saharan Africa Gabon PURA200 Online 170 1/5/2016 9 23267 Vance CamposMiddle East and North Africa PURA100 Online 129 7/11/2016 23268 WallCentral America and the C DETADO Online 827/12/2016 23259 Jane Hernande PURA100 Retal 116 6/3/2016 12 23270 Wanda Garc SUPADO 13 23271 Acha Fitzpatrick Sub-Saharan Africa SUPASOS Online 14 23272 HicksCentral and the Caribbean Turks and Caicos Islands Online 15 23273 Isaac Cooper Central America and the Caribbean Netherlands Antil SUPASO Online 16 23274 AsherWeber Macedonia PURAL 17 23275 Ethan GregoryAustralia and Oceania Tuvalu DETABOO Online Nepal PURASOO 23277 Mackerale Mous Middle East and North Africa Oman Online 23278 Aphrodite Brennan Sub-Saharan Africa SUPASOS Online 67 6/7/2016 125 7/27/2016 71 7/31/2016 22/13/2016 153 8/22/2016 141 7/4/2016 8/1/2016 157 7/12/2016 197 8/24/2016 33279 Angria Wie PURA100 Online 10 6/21/2016 12 23280 James Spencer Burkina Faso SUPADO B 33281 Adria KaufmanAustralia and Oceania SUPA502 Online Online 30 6/3/2016 134 7/13/2016 14 23282 Amir Neander Sub-Saharan Africa Liberia DETADO Online 100 /21/2016 15 23283 Lani Sweet SUPASOS Online Sales Product Table 142 6/24/2016 A 1 Product ID 2 PURA100 3 PURA200 4 PURA250 5 PURASOO 6 DETA100 Product Name B Pure Soft Detergent - 100ml Pure Soft Detergent - 200ml Pure Soft Detergent-250ml Pure Soft Detergent - 500ml Detafast Stain Remover Detafast Stain Remover 100ml 200ml Detafast Stain Remover - 800ml Super Soft - Product Sample Super Soft-250ml Super Soft 500ml Super Soft - 1 Litre 7 DETA200 8 DETABOO 9 SUPA101 10 SUPA102 11 SUPA103 12 SUPA104 13 SUPA105 Super Soft Bulk - 2 Litres 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 Sales Product Table C D E F G H Cost Price $ 21.50 $ 33.00 $42.00 $ 53.99 $ 32.30 $ 44.50 $ 33.50 $36.50 $ 53.00 $ 66.00 $ 63.50 $ 76.50 $76.00 $ 89.00 $ 15.30 $ 20.50 $12.50 $24.50 $13.50 $ 26.99 $ 15.00 $ 29.99 $ 18.00 $ 24.50
Name 23252 Candice Levy Country Congo Product Sold Sales Type SUPASOL Online /9/2016 23263X Central America and the Caribbean DETA200 Online 23254 Lev Sub-Saharan Africa DETABOO Online Units Sold Date Sold - Product Price Product Cost 75 7/8/2016 205/18/2016 23265 Uriel Benton South Africa SUPASO4 Online 14 8/3/2016 23266 Sub-Saharan Africa Gabon PURA200 Online 170 1/5/2016 9 23267 Vance CamposMiddle East and North Africa PURA100 Online 129 7/11/2016 23268 WallCentral America and the C DETADO Online 827/12/2016 23259 Jane Hernande PURA100 Retal 116 6/3/2016 12 23270 Wanda Garc SUPADO 13 23271 Acha Fitzpatrick Sub-Saharan Africa SUPASOS Online 14 23272 HicksCentral and the Caribbean Turks and Caicos Islands Online 15 23273 Isaac Cooper Central America and the Caribbean Netherlands Antil SUPASO Online 16 23274 AsherWeber Macedonia PURAL 17 23275 Ethan GregoryAustralia and Oceania Tuvalu DETABOO Online Nepal PURASOO 23277 Mackerale Mous Middle East and North Africa Oman Online 23278 Aphrodite Brennan Sub-Saharan Africa SUPASOS Online 67 6/7/2016 125 7/27/2016 71 7/31/2016 22/13/2016 153 8/22/2016 141 7/4/2016 8/1/2016 157 7/12/2016 197 8/24/2016 33279 Angria Wie PURA100 Online 10 6/21/2016 12 23280 James Spencer Burkina Faso SUPADO B 33281 Adria KaufmanAustralia and Oceania SUPA502 Online Online 30 6/3/2016 134 7/13/2016 14 23282 Amir Neander Sub-Saharan Africa Liberia DETADO Online 100 /21/2016 15 23283 Lani Sweet SUPASOS Online Sales Product Table 142 6/24/2016 A 1 Product ID 2 PURA100 3 PURA200 4 PURA250 5 PURASOO 6 DETA100 Product Name B Pure Soft Detergent - 100ml Pure Soft Detergent - 200ml Pure Soft Detergent-250ml Pure Soft Detergent - 500ml Detafast Stain Remover Detafast Stain Remover 100ml 200ml Detafast Stain Remover - 800ml Super Soft - Product Sample Super Soft-250ml Super Soft 500ml Super Soft - 1 Litre 7 DETA200 8 DETABOO 9 SUPA101 10 SUPA102 11 SUPA103 12 SUPA104 13 SUPA105 Super Soft Bulk - 2 Litres 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 Sales Product Table C D E F G H Cost Price $ 21.50 $ 33.00 $42.00 $ 53.99 $ 32.30 $ 44.50 $ 33.50 $36.50 $ 53.00 $ 66.00 $ 63.50 $ 76.50 $76.00 $ 89.00 $ 15.30 $ 20.50 $12.50 $24.50 $13.50 $ 26.99 $ 15.00 $ 29.99 $ 18.00 $ 24.50
Calculus: Early Transcendentals
8th Edition
ISBN:9781285741550
Author:James Stewart
Publisher:James Stewart
Chapter1: Functions And Models
Section: Chapter Questions
Problem 1RCC: (a) What is a function? What are its domain and range? (b) What is the graph of a function? (c) How...
Related questions
Question
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
4. Format columns I, J, and K as currency with two decimal places.
5. Make a copy of the Sales sheet and rename it Online Sales by Date. Place this sheet to the right
of the Sales sheet.
Answer the following question by filtering the data accordingly.
a) What was the total Profit for Online Sales?
b) Sort the results by Date Sold (A/Z).
* so apparently I need to learn to use the VLOOKUP to find a product on the first page and be able to get the Product Price and Cost from the second page. The following formula is NOT working - =VLOOKUP(D4, ProductTable!A:B, 2,FALSE). I need an EXACT FORMULA that will work. Please Help
Transcribed Image Text:Name
23252 Candice Levy
Country
Congo
Product Sold
Sales Type
SUPASOL
Online
/9/2016
23263X
Central America and the Caribbean
DETA200
Online
23254 Lev
Sub-Saharan Africa
DETABOO
Online
Units Sold Date Sold - Product Price Product Cost
75 7/8/2016
205/18/2016
23265 Uriel Benton
South Africa
SUPASO4
Online
14
8/3/2016
23266
Sub-Saharan Africa
Gabon
PURA200
Online
170 1/5/2016
9
23267 Vance CamposMiddle East and North Africa
PURA100
Online
129 7/11/2016
23268
WallCentral America and the C
DETADO
Online
827/12/2016
23259 Jane Hernande
PURA100
Retal
116 6/3/2016
12
23270 Wanda Garc
SUPADO
13
23271 Acha Fitzpatrick Sub-Saharan Africa
SUPASOS
Online
14
23272 HicksCentral
and the Caribbean Turks and Caicos Islands
Online
15
23273 Isaac Cooper Central America and the Caribbean Netherlands Antil
SUPASO
Online
16
23274 AsherWeber
Macedonia
PURAL
17
23275 Ethan GregoryAustralia and Oceania
Tuvalu
DETABOO
Online
Nepal
PURASOO
23277 Mackerale Mous
Middle East and North Africa
Oman
Online
23278 Aphrodite Brennan
Sub-Saharan Africa
SUPASOS
Online
67 6/7/2016
125 7/27/2016
71 7/31/2016
22/13/2016
153 8/22/2016
141 7/4/2016
8/1/2016
157 7/12/2016
197 8/24/2016
33279 Angria Wie
PURA100
Online
10 6/21/2016
12
23280 James Spencer
Burkina Faso
SUPADO
B
33281 Adria KaufmanAustralia and Oceania
SUPA502
Online
Online
30 6/3/2016
134 7/13/2016
14
23282
Amir Neander
Sub-Saharan Africa
Liberia
DETADO
Online
100 /21/2016
15
23283 Lani Sweet
SUPASOS
Online
Sales Product Table
142 6/24/2016
A
1
Product ID
2
PURA100
3
PURA200
4 PURA250
5 PURASOO
6 DETA100
Product Name
B
Pure Soft Detergent - 100ml
Pure Soft Detergent - 200ml
Pure Soft Detergent-250ml
Pure Soft Detergent - 500ml
Detafast Stain Remover
Detafast Stain Remover
100ml
200ml
Detafast Stain Remover - 800ml
Super Soft - Product Sample
Super Soft-250ml
Super Soft 500ml
Super Soft - 1 Litre
7 DETA200
8 DETABOO
9 SUPA101
10 SUPA102
11 SUPA103
12 SUPA104
13 SUPA105
Super Soft Bulk - 2 Litres
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
Sales
Product Table
C
D
E
F
G
H
Cost
Price
$ 21.50 $ 33.00
$42.00 $ 53.99
$ 32.30 $ 44.50
$ 33.50 $36.50
$ 53.00 $ 66.00
$ 63.50 $ 76.50
$76.00 $ 89.00
$ 15.30 $ 20.50
$12.50 $24.50
$13.50 $ 26.99
$ 15.00 $ 29.99
$ 18.00 $ 24.50
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
Recommended textbooks for you
Calculus: Early Transcendentals
Calculus
ISBN:
9781285741550
Author:
James Stewart
Publisher:
Cengage Learning
Thomas' Calculus (14th Edition)
Calculus
ISBN:
9780134438986
Author:
Joel R. Hass, Christopher E. Heil, Maurice D. Weir
Publisher:
PEARSON
Calculus: Early Transcendentals (3rd Edition)
Calculus
ISBN:
9780134763644
Author:
William L. Briggs, Lyle Cochran, Bernard Gillett, Eric Schulz
Publisher:
PEARSON
Calculus: Early Transcendentals
Calculus
ISBN:
9781285741550
Author:
James Stewart
Publisher:
Cengage Learning
Thomas' Calculus (14th Edition)
Calculus
ISBN:
9780134438986
Author:
Joel R. Hass, Christopher E. Heil, Maurice D. Weir
Publisher:
PEARSON
Calculus: Early Transcendentals (3rd Edition)
Calculus
ISBN:
9780134763644
Author:
William L. Briggs, Lyle Cochran, Bernard Gillett, Eric Schulz
Publisher:
PEARSON
Calculus: Early Transcendentals
Calculus
ISBN:
9781319050740
Author:
Jon Rogawski, Colin Adams, Robert Franzosa
Publisher:
W. H. Freeman
Calculus: Early Transcendental Functions
Calculus
ISBN:
9781337552516
Author:
Ron Larson, Bruce H. Edwards
Publisher:
Cengage Learning