Excel Assignment # 7 - Homework (Empty)

Chapter 7: Advanced Formula Instructions: Complete the below steps as instructed. Once you are done, kindly Task Again, she wants to apply the same formatting across all the worksheets. 1 2 - 3 - 4 - 5 - 6 - 7 - 8 - - 9 - - 10 - - 11 - - 12 - - 13 - Lia wants to prepare a quarterly report for the next 3 months April, May, and June). Once aga The identical worksheets from all three locations (Boston, Natick, and Amherst) are then sent Group the worksheets: Boston, Natick, and Amherst. Bold the name of the months in all worksheets ( rang Enter the text " Total Sales " in cell A15. (No periods) Enter the formula that sums up "Total Sales" for the Enter the formula that sums up "Total Sales" for the Enter the formula that sums up "Total Sales" for the Go to the Summary Sheet. The Sales Summary in this sheet sums up th locations for the month of April. Use 3-D references to fill the range B7:D16 with the Use a VLOOKUP to find the total amount of Hot Dr Fill in the formula Use an HLOOKUP function to find out May Sales fo Fill in the formula Use an XLOOKUP function to find out the amount o Fill in the formula Use an XLOOKUP function to find out the June Sale Fill in the formula Use an XLOOKUP function to find out the name of Fill in the formula Use an XLOOKUP function to find out the Location

- 14 - - 15 - - 16 - - 17 - - Go to the Soups Info Sheet: 18 - - If C4 is less than 6 - If C4 is less than 9 - If C4 is greater tha 19 - - The formula adds M - The information is 20 - - Items with a quant 21 - - The items with the - The information is 22 - - Items with the qua 23 - - The average amoun - The information is 24 - - Fill in the formula Use an XMATCH function to find out the Rank for B Fill in the formula Enter a Filter Function to list chefs working in Amhe Fill in the formula Enter a Filter Function to list chefs working in Newto Fill in the formula Enter a UNIQUE Function to extract a unique list of Fill in the formula In the range E4:E12 , enter an IFS function, such that In cell D16 , enter a SUMIF function that adds the sal In cell G16 , enter a SUMIFS function that adds the s In cell D18 , enter a COUNTIF function that counts: In cell G18 , enter a COUNTIFS function that counts In cell D20 , enter an AVERAGEIF function to calcu Trace the cell precedents for cell D16 . Trace the cell dependents for cell E5 .

as and Functions - Homework y upload this Excel Workbook to ExPrep by using the side menu. ain, she sends all restaurant managers an Excel worksheet and asks them to fill in information ab t over to Lia. She consolidates the data and to make some final analysis. ge B1:D1 ). ). month of April in cell B15. month of May in cell C15. month of June in cell D15. he numbers from all locations. For example, cell B7 sums up the Appetizers of all three e correct sum formulas. rinks sold in April. in cell B22. or Soups. in cell B24 . of Noodle Dishes sold in June. in cell B26. es for Desserts. in cell B28. the chef with ID 783. in cell H24. n and Day Off for ID 788.

grity violation. Both parties are identified even if they are in different sections, courses, or schools. In such a case, d’s project instead of your own is not an excuse. You and your friend will both receive grades of zero. Leaving a use a shared computer, it is advisable to learn how to save your work to your UMass OneDrive.

5 5 5 5 5 5 5 5 5 5

83954 59629

April May Appetizers $ 7,896 $ 3,600 Soups $ 5,745 $ 280 Beef and Lamb Dishe $ 8,214 $ 9,200 Poultry Dishes $ 4,742 $ 700 Seafood Dishes $ 9,200 $ 4,300 Rice Dishes $ 700 $ 1,800 Noodles Dishes $ 600 $ 100 Desserts $ 5,467 $ 800 Cold Drinks $ 280 $ 3,500 Hot Drinks $ 369 $ 2,200