Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help to solve it with explanation. Regional Expense Data JAY February March April MAY June July August September October November December Region South

I need help to solve it with explanation. image text in transcribed
image text in transcribed
image text in transcribed
Regional Expense Data JAY February March April MAY June July August September October November December Region South East astern Centre North Eastern North West South West Midwest $133,555 510432 3129,760 5137,491 5136,400 $129.561 5140,990 $111.21 5133,907 5116,331 5151561 5115151 5164,914 399,292 5155,133 $100.450 $150.057 5130 200 $116,439 5116,684 $100,648 5158,635 $109,123 5127.999 5104.932 $122.966 $170,706 5154 840 5170680 5154,505 5160 GST $172.500 S100384 $90,00 5101,730 3115 380 5116,505 5148,180 $137.100 5134 30 5135.589 $168.420 5128,592 5127.155 $102.300 $90.602 $117.150 $160,402 5168076 5127.537 $185.290 $94.95 598,235 5111,239 5161 900 5142.067 5117558 5134.400 5119,850 $172,000 5167 463 5101.611 5108210 S1975 5114071 $107.09 5127 Month June March 5133110 Regional Revenue Data North Eastern Eastern Central Region South East Midwest North West South West January 3103, 100 St48 149 5144337 5159330 585 517120 February 3133 541 $117.37 $104.733 $100,094 $152,405 April 5961 5138,300 $150 a 5142770 5102100 Sales Data for 2010 May July August September October November December 555 032 5150057 5119.800 5111230 5180.004 $99.1003130,496 5127.50 511100 $109 023 5114.071 5172.900 5152.405 31560515150 312753 590108 5170600 5127 510720 $160,057 5122017 5112.709 5161736 5129 561 5110,561 513,170 594903 110. 310151 512800 $135.500 5115151 3103 104 $152 5134400 170.00 511156 199 200 5140 749113792516093E 513730 5156827 5533370 5100830 Profitability (Revenue Expense) Analysis December Eastern Central The only cells you are allowed to change are the yellow and blue els Chart This sheet contains monthly revenue and expense data for 2019 for the six sales regions in a company. Develop a query that will allow you to observe the profitability of a particular region in a particular month in cell G32 (the yellow cell) by selecting the region name in cell F32 and the month in cell G31. Use the MATCH and OFFSET commands to create a single formula in cell G32 that computes the profitability (Revenue minus Expense) of the region and month specified in cells F32 and G31 respectively. Use Data Validation to provide a drop-down list of permissible entries for the cells F32 and G31. Notes: you will need to subtract the results of two OFFSET/MATCH functions in the same formula Observe that the tables refer to the same regions and months, but the orientations of the tables differ and the regions in the two tables are not in the same sequence. You are not able to change the orientation or sequence of either table. All your work must be done in the single yellow cell no other modifications to the workbook are allowed except the data validation changes. Make sure the answer is in correct currency format (with dollar sign and parenthesis il the value is negative)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Accounting questions