a) Use SUMIF to summarize total lunch, dinner, delivery for the DAY of the week b) Use Day of the Week and TYPE (Lunch,Dinner,Delivery) to display $$ in part a using VLOOKUP c) Use FORMS Control to restrict input in part b Date Day Lunch Sales $ Dinner Sales $ Delivery Sales $ 1 Saturday 542 1467 884 2 Sunday 873 1344 489 4 Tuesday 289 645 321 5 Wednesday 354 781 289 6 Thursday 403 804 276 7 Friday 442 1288 1242 8 Saturday 449 1651 782 9 Sunday 697 1208 341 11 Tuesday 307 578 328 12 Wednesday 387 663 301 13 Thursday 412 890 243 14 Friday 508 1177 1068 15 Saturday 503 1580 714 16 Sunday 741 1136 326 18 Tuesday 298 571 365 19 Wednesday 419 620 278 20 Thursday 345 912 294 21 Friday 467 1331 1254 22 Saturday 622 1731 636 23 Sunday 846 1323 319 25 Tuesday 233 522 411 26 Wednesday 341 730 243 27 Thursday 426 939 350 28 Friday 379 1408 1143 29 Saturday 592 1855 601 30 Sunday 779 1228 398

The Answer is in the image, click to view ...

Question: a) Use SUMIF to summarize total lunch, dinner, delivery for the DAY of the week b) Use Day of the Week and TYPE (Lunch,Dinner,Delivery) to

a) Use SUMIF to summarize total lunch, dinner, delivery for the DAY of the week b) Use Day of the Week and TYPE (Lunch,Dinner,Delivery) to display $$ in part a - using VLOOKUP c) Use FORMS Control to restrict input in part b

Date	Day	Lunch Sales $	Dinner Sales $	Delivery Sales $
1	Saturday	542	1467	884
2	Sunday	873	1344	489
4	Tuesday	289	645	321
5	Wednesday	354	781	289
6	Thursday	403	804	276
7	Friday	442	1288	1242
8	Saturday	449	1651	782
9	Sunday	697	1208	341
11	Tuesday	307	578	328
12	Wednesday	387	663	301
13	Thursday	412	890	243
14	Friday	508	1177	1068
15	Saturday	503	1580	714
16	Sunday	741	1136	326
18	Tuesday	298	571	365
19	Wednesday	419	620	278
20	Thursday	345	912	294
21	Friday	467	1331	1254
22	Saturday	622	1731	636
23	Sunday	846	1323	319
25	Tuesday	233	522	411
26	Wednesday	341	730	243
27	Thursday	426	939	350
28	Friday	379	1408	1143
29	Saturday	592	1855	601
30	Sunday	779	1228	398

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

In this exercise, we look at how software techniques can extract instruction-level parallelism (ILP) in a common vector loop. The following loop is the so-called DAXPY loop (double-precision aX plus...

I have attached the data and the worksheet. Date Day Lunch Sales $ Dinner Sales $ Delivery Sales $ 1-Apr Saturday $542.00 $1,468.00 $884.00 2-Apr Sunday $873.00 $1,345.00 $489.00 4-Apr Tuesday...

02. North Beach Knickpoint (NBK) North Beach Knickpoint resort was located about 10 minutes northwest of the Bruce Peninsula National Park in the harbour village of lobermory oversetine Laie Hnon...

I want a case study on Hasen Restaurant to include summary, 3 long and 5 short term issues, SWOT analysis, PORTERS FIVE analysis, 3 short and 2 long term alternatives, implementation, monitor and...

supply chain mangment case study answer the qustions Industrial Engineering and Engineering Management Department 0405433: Supply Chain Management Spring 2021/2022 Instructor: Dr. Ridvan Aydin Date:...

7. The United States has food service distributors that also replenish convenience stores. What are the pros and cons to having a distributor replenish convenience stores versus a company like...

6. Seven-Eleven is attempting to duplicate the supply chain structure that has succeeded in Japan and the United States with the introduction of CDCs. What are the pros and cons of this approach?...

Case Study Seven-Eleven Japan Co. Established by Ito Yokado in 1973, Seven-Eleven Japan convenience stores in Japan. After rejecting his initial set up its first store in Koto-ku, Tokyo, in May 1974....

Welcome! Please read this page very carefully. Instructions You need to understand how to send your assignments (deliverables) to your instructor. The tabs (bottom of each sheet) in this document...

REVISION QUESTIONS MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 1) Which of the following is a generic term that covers a broad range of...

What is the correct decision for a test of the difference in two proportions if the test statistic is 1.99, n1 = 150, n2 = 225, and = .05? a) Reject H0 b) Don't Reject H0 c) Reject HA d) Don't...

What must Ua be for a three-dimensional square-well potential (attractive) so that the scattering cross section is zero at zero bombarding encrgy. (This is the Ramsauer-Townsend effect)

Accurate answer Maria's net income was $1,240, and her gross income was $1,750. What was the total amount of deductions

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...