Answered step by step
Verified Expert Solution
Question
1 Approved Answer
All done on excel with formulas explained thank you (2pt) 2. MATCH AND INDEX| a. Write a formula that returns the sales amount, according to
All done on excel with formulas explained thank you
(2pt) 2. MATCH AND INDEX| a. Write a formula that returns the sales amount, according to what the user inputs in Product and Month January March April February 189 158 165 Product 1 2 114 131 170 3 103 182 160 172 180 108 194 142 114 157 115 184 129 194 138 146 157 4 119 5 142 143 6 141 153 May 114 Napoleon (piece) 144 Chocolate clair 135 Caramel clair 145 Vanilla clair 169 Petits fours, per 12 173 Fresh fruit tart--berry 105 Fresh fruit tart--tropical 27 Orange-passion flan 39 Pear Charlotte 30 Raspberry Charlotte 39 Pralin torte 28 Sacher torte 25 Opra torte 33 Tahiti (vanilla-rum) cake 7 27 40 31 8 30 36 33 9 20 32 28 27 29 37 10 32 40 20 33 11 37 34 30 26 12 24 34 39 13 26 32 22 20 33 14 Product Month Sales In Cellss A17 - 017, Write a formula that returns the sales amount, according to what the user inputs in Product and Month You may use Match and Index or Vlookup and Nested IF Statements In Product (Cell A18) include a list of products for the user of the form to select from In Month (CellB18) include a list of months (From Jan - Dec) (2pt) 2. MATCH AND INDEX| a. Write a formula that returns the sales amount, according to what the user inputs in Product and Month January March April February 189 158 165 Product 1 2 114 131 170 3 103 182 160 172 180 108 194 142 114 157 115 184 129 194 138 146 157 4 119 5 142 143 6 141 153 May 114 Napoleon (piece) 144 Chocolate clair 135 Caramel clair 145 Vanilla clair 169 Petits fours, per 12 173 Fresh fruit tart--berry 105 Fresh fruit tart--tropical 27 Orange-passion flan 39 Pear Charlotte 30 Raspberry Charlotte 39 Pralin torte 28 Sacher torte 25 Opra torte 33 Tahiti (vanilla-rum) cake 7 27 40 31 8 30 36 33 9 20 32 28 27 29 37 10 32 40 20 33 11 37 34 30 26 12 24 34 39 13 26 32 22 20 33 14 Product Month Sales In Cellss A17 - 017, Write a formula that returns the sales amount, according to what the user inputs in Product and Month You may use Match and Index or Vlookup and Nested IF Statements In Product (Cell A18) include a list of products for the user of the form to select from In Month (CellB18) include a list of months (From Jan - Dec)Step 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