ou have an Excel file of 50 orders placed by customers. There are three columns:Column A stores whether a customer is a repeat customer or not. It can only be Yes or NoColumn B stores whether an order was placed on a weekend. It can also only be Yes or NoColumn C stores the order amountWhich of the following is best suited to calculate: the total order amount placed by all repeat customers on a weekend?SUMSUMIFIFSUMSUMIFS

While making a spreadsheet for a delivery service, you notice you need a way to keep track of the number of items that are perishable and are still pending delivery.ABCD1ProductCategoryAmountStatus2Fresh ProducePerishable$70Delivered3TelevisionAppliance$500Delivered4Milk TeaPerishablePending5Cellular phoneAppliance$1000PendingGiven the table above, what will this function return?=COUNTIFS (D2:D5, "Pending", B2:B5, "Perishable")1 pointIt will give an error. The statement should be=COUNTIFS (D2:D5 = "Pending", B2:B5 = "Perishable") .It will return 1. given there is only one item that is both pending and is perishable.It will return 3, given the condition for “Pending” is first in the function, it takes it as a priority.It will return 2, given that there are two occurrences each of “Appliance” and “Pending.”

You are tasked with maintaining a record of daily purchases made by customers. To accomplish this, you need to create a view named daily_purchase_summary. This view will provide a summary of the daily purchases, including the total number of orders placed and the total purchase amount for each day. The purchase amount should be rounded to two decimal places for accuracy.

Use the data shown to answer the questions that follow.Person Minutes Shopping in the Store Amount Spent on Groceries at Checkout1 46.5 140.52 55 1683 78.8 241.44 91.4 209.25 98.9 300.76 96.7 291.17 60.1 182.38 81.4 245.2Copy and paste the above data into Excel and make the most appropriate graph for these data. Make sure the x-axis represents the "Minutes Shopping in the Store" and that the y-axis represents the "Amount Spent on Groceries at Checkout."One of the values in the plot of this data does not fit the pattern of the other values. It would be called an outlier.What is the x-value and y-value of the outlier?Hint: If you hover your mouse over the points in your Excel graph it will show you the exact x-value and y-value of the point.Group of answer choices(46.5, 140.5)(55, 168)(78.8, 241.4)(91.4, 209.2)(98.9, 300.7)(96.7, 291.1)(60.1, 182.3)(81.4, 245.2)

In cell F13 of the Schedule worksheet, enter a formula that will calculate the total number of employees scheduled to work Sunday for all schedules A-G. Begin by multiplying the number of employees for schedule A, in cell D5, by the value representing whether or not employees are working that day in cell F5. Be sure to make the reference to cell D5 an absolute cell reference so that, when finished, the formula can be copied across the row. So far the result of the formula is 0 because schedule A has people scheduled off on Sunday. Next, add to the product, the number of employees scheduled to work Sunday for schedule B. Continue with the formula by adding a similar calculation for schedules C-G, making an absolute cell reference for each cell in column D.

Enter a formula in cell B2 using the VLOOKUP function to find the total sales for the date in cell B1. Use the name DailySales for the lookup table. The total sales are located in column 5 of the lookup table. Be sure to require an exact match.