Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

All done on excel with formulas explained thank you image text in transcribed

(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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Agile Auditing Transforming The Internal Audit Process

Authors: Rick A. Wright Jr. CIA

1st Edition

1634540689, 978-1634540681

More Books

Students also viewed these Accounting questions

Question

13. Identify the refusal of the return in Dances with Wolves.

Answered: 1 week ago

Question

11.1 Explore the role of labor unions.

Answered: 1 week ago

Question

11.3 Discuss laws affecting collective bargaining.

Answered: 1 week ago