Question 3You are working on the sales data for office desks and want to calculate the total profits for the year 2020. What function would you use to calculate the total profits, which are located in the cell range B2 to B220?1 point= TOTAL (B2 : B220)= B2 + B220= B2 : B220= SUM ( B2 : B220)

ou are working on the sales data for office desks and want to calculate the total profits for the first order that was sold.  In this first order, 5 desks were sold (cell D2) and the cost/unit for the desk is $130 (cell E2). What formula would you write to calculate the total profits for this order?1 point= D2 x E2= D2 + E2= D2 * E2= D2 / E2

Enter a formula in the selected cell to calculate the profit projection for 2022: total sales (cell F4) minus the cost of goods sold (cell F5).

Sales=40,000 variable cost=20% Fixed cost=30000 using Goal Seek analysis find the profit when sales is Rs.80000 Options : 34000 30000 22000 32000 do in excel

You have a Google Sheets dataset with columns A (Product Names), B (Sales Amounts), and C (Region). What formula would you use to calculate the total sales amount for a specific product in a specific region?*SUMIF(A:A, "Product Name", B:B)SUMIFS(B:B, A:A, "Product Name", C:C, "Region")SUMPRODUCT(A:A = "Product Name", C:C = "Region", B:B)SUM(B:B, IF(A:A = "Product Name", IF(C:C = "Region", 1, 0)))

Sophie is working on an order and wishes to calculate the total price for the order. She first needs to look up the prices for each item in the order, given the product name and price data. What function would she write in cell E2 to obtain this information without doing it manually?0 / 1 point=VLOOKUP(D3,$A$2:$B$12,3,FALSE)=VLOOKUP(E2,$A$1:$C$20,2,FALSE)=VLOOKUP(A2,$A$2:$B$12,3,FALSE)=VLOOKUP(D2,$A$2:$B$12,2,FALSE)