ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Order IDCustomer NameCategorySalesDiscountSale price after discountProfitSale price after discount - ProfitSales - ProfitProfit PercentageTry these: (enter and label your answers to questions 3-5 in this spreadsheet in an organized way). Cheat Sheet
2
OD1HarishOil & Masala$1,254.00$0.12$401.281. Select a cell
3
OD2SudhaBeverages$749.00$0.18$149.802. Move between cells using keyboard arrows
4
OD3HussainFood Grains$2,360.00$0.21$165.203. Calculate the MIN, MAX, AVERAGE of "Sales" column
5
OD4JacksonFruits & Veggies$896.00$0.25$89.604. Calculate the SUM of "Profit" column
6
OD5RidheshFood Grains$2,355.00$0.26$918.455. Calculate SUM of "Discount" using absolute cell references ($)
7
OD6AdavanFood Grains$2,305.00$0.26$322.706. Select the "Sales" column and create a named range for the column from the selected cells. Repeat with the "Discount", “Sale price after discount” (use Sale_Price), and "Profit" columns.
8
OD7JonasFruits & Veggies$826.00$0.33$346.927. Calculate the "Sale price after discount" (Column F) by subtracting the named ranges of Sales and Discount using Arithmetic operators.
9
OD8HafizFruits & Veggies$1,847.00$0.32$147.768. Use "Undo", "Redo" buttons
10
OD9HafizBakery$791.00$0.23$181.939. Calculate the first cell in "Sale price after discount-Profit" (H2) by subtracting the cell locations of "Sale price after discount" column and "Profit" column using Arithmetic operators.
11
OD10KrithikaBakery$1,795.00$0.27$484.6510. Drag the formula in H2 to calculate all the values in column H using the fill handle
12
OD11GaneshSnacks$1,903.00$0.13$437.6911. Apply conditional formatting for the "Sale price after discount - Profit" column.
Make values in Column H that are > 1000 green and values < 1000 red.
13
OD12YadavEggs, Meat & Fish$701.00$0.10$308.4412. Enter an Array formula into "Sales - Profit" to subtract "Profit" column from "Sales" column.
14
OD13SharonSnacks$1,659.00$0.19$315.2113. Calculate what percentage of the sale price is profit using this formula: "(Profit/Sale_Price)".
15
OD14PeerFruits & Veggies$1,277.00$0.25$63.85
16
OD15SundarEggs, Meat & Fish$831.00$0.22$207.75
17
OD16RameshOil & Masala$1,440.00$0.11$100.80
18
OD17AlanBakery$1,678.00$0.28$318.82
19
OD18ArutraBeverages$1,617.00$0.19$113.19
20
OD19HaseenaEggs, Meat & Fish$1,757.00$0.35$386.54
21
OD20VermaBeverages$692.00$0.29$159.16
22
OD21HafizBeverages$522.00$0.19$208.80
23
OD22AlanFood Grains$948.00$0.13$47.40
24
OD23HaseenaBeverages$707.00$0.34$148.47
25
OD24AlanFruits & Veggies$969.00$0.29$77.52
26
OD25SharonEggs, Meat & Fish$1,100.00$0.11$495.00
27
OD26KrithikaSnacks$2,022.00$0.11$202.20
28
OD27MuneerSnacks$541.00$0.12$43.28
29
OD28JacksonBakery$979.00$0.22$401.39
30
OD29VeronicaBeverages$1,988.00$0.22$874.72
31
OD30ShahOil & Masala$989.00$0.17$69.23
32
OD31RameshBeverages$1,845.00$0.24$166.05
33
OD32MathewSnacks$1,400.00$0.11$420.00
34
OD33AkashOil & Masala$2,163.00$0.26$670.53
35
OD34AnuOil & Masala$1,689.00$0.34$337.80
36
OD35AnuBeverages$809.00$0.32$80.90
37
OD36SabeelaEggs, Meat & Fish$1,265.00$0.22$569.25
38
OD37JamesBeverages$934.00$0.35$56.04
39
OD38WillamsFruits & Veggies$1,354.00$0.16$446.82
40
OD39JonasFruits & Veggies$1,751.00$0.19$280.16
41
OD40SabeelaEggs, Meat & Fish$2,045.00$0.23$879.35
42
OD41MalikBeverages$660.00$0.19$92.40
43
OD42ArutraBeverages$1,868.00$0.18$616.44
44
OD43SharonSnacks$1,017.00$0.25$345.78
45
OD44MathewSnacks$2,311.00$0.20$1,039.95
46
OD45AmrishBakery$1,663.00$0.17$731.72
47
OD46VinceEggs, Meat & Fish$1,420.00$0.19$355.00
48
OD47SureshFruits & Veggies$1,415.00$0.31$509.40
49
OD48MathewSnacks$1,488.00$0.30$610.08
50
OD49RidheshSnacks$726.00$0.18$43.56
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100