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

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)

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).

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)

The financial information of the company is as follows:Sales units: 200Price per unit: $30Fixed cost: $400Variable cost per unit: $20What would be the profit if 400 and 500 units are sold? Create a data table for the same.Options :$2,000 and $3,500$3,600 and $4,600$2,500 and $3,200$4000 and $6,500

If a company's Sales revenue figure is 345,000  and its Gross profit has been calculated has 90,000. Also the figure for other expense has been determined as 63,000What is the figure for Cost of Sales?