Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Provide the trend between Feb 04 and Dec 04 Insert Page Layout Data Review View . .. = Menu Home Formulas Special features Unsynchronized

image text in transcribed

1. Provide the trend between Feb 04 and Dec 04

image text in transcribedimage text in transcribed
Insert Page Layout Data Review View . .. = Menu Home Formulas Special features Unsynchronized Share A % Cut Arial 10 A A E General Format as Table E Y AL Paste . Copy Format Merge and Wrap 3 % 090 8 08 Conditional Cell Style AutoSum AutoFilter * Sort Fill Format ROV Painter Center Text Formatting Col H6 @ fx B C D E F G H K M N O P Q R MARKET REGION CODE MARKET REGION 05388 United States 05388 United States 05440 Canada 05440 Canada 05440 Canada 05440 Canada 05440 Canada 05440 Canada 10 05440 Canada 11 05451 MSAC =IF(A3="05388","United States",IF(AND(A3="05440"),"Canada",IF(AND(A3="05451"),"MSAC", IF(AND(A3="05454"),"EMEA",IF(AND(A3="05457"),"Asia Pacific","NA"))))) 12 05451 MSAC IF(A3="05388","United States", If A3 = 05388 Then "United States" 13 05454 EMEA IF (AND(A3="05440"),"Canada", If A3 = 05440 Then "Canada" 14 05454 EMEA IF(AND(A3="05451"),"MSAC" 15 05454 EMEA IF(AND(A3="05454"),"EMEA" 16 05457 Asia Pacific IF(AND(A3="05457"),"Asia Pacific" 17 05457 ia Pacific "NA" Else 18 05457 Asia Pacific 19 05457 Asia Pacific 20 05457 Asia Pacific 01111 02222 23 03333 24 25 27 28 29 30 31 32 8 898628 40 41 >1 Questions Q9 Raw Data trend if then auto payment auto payment (2) + . Local backup on 110% +AutoSave ON . A $3 6 - 6 0 - MGS4020_Project_01_20230608 - Saved Q Home Insert Draw Page Layout Formulas Data Review View Data Mining . Tell me Share Comments Arial 10 B Wrap Text v General Insert v ZY- O. Ex Delete Paste BIUV Merge & Center v $ ~ % " $68 08 Conditional Format Cell Sort & Find & Analyze Sensitivity Formatting as Table Styles Format v Q v Filter Select Data

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_2

Step: 3

blur-text-image_3

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

Essentials Of Strategic Management

Authors: J. Hunger, Thomas Wheelen

5th Edition

0136006698, 9788120348615

More Books

Students also viewed these General Management questions

Question

What were the processes that caused the outcomes?

Answered: 1 week ago

Question

7. How can an interpreter influence the utterer (sender)?

Answered: 1 week ago