answer all Q please

7 Apr 394 Monthly production 2 3 Month Units 4 Jan 149 5 Feb 247 6 Mar 382 451 8 May 300 9 Jun 298 10 Jul 187 11 Aug 361 12 Sep 85 13 Oct 14 Nov 322 15 Dec 400 16 Choose 17 Total 3576 F4 18 19 Average 298 Ctrl+t Autosum The information in the table shows a schedule of working for a p tment Ctrl + S Which of the following would achieve the total in Cell B17? Choose F2 What is the best formula to achieve the result in cell B19? -SUM(B4-%B15912 Which of the following statements is true regarding the automatic positioning of items within a cell, before any editiny Choose Choose Text is right aligned =SUM[14:5315)/2 Numbers are right aligned -AVERAGE(CAC16) AVERAGEIB4:15) Text is centre aligned SUM(C4:C15) Numbers are centre =TOTAL(B4:815) AVERAGE(B$4:$815) F Absorb is a company that has two production departments and one service department The company has provided you with budgeted cost data for the year as follows: Indirect Materials 4,000.00 Indirect Labour 6,000.00 Rent and Rates 150,000.00 Building Depreciation 37,500.00 Heat and Lighting 90,000.00 Machine Insurance 25,000.00 Prodcution Supervisor's Salary 50,000.00 Additional data Indirect Materials (E) Indirect Labour () Floor Area (sq metres) Machine Value ('000) No. of employees Machine hours Production Dept 1 Production Dept 2 Service Department 2,000 2,000 3,000 2,000 1,000 40 20 4 16 12 2 8 6 1 10,000 5,000 Prepare a statement showing the budgeted overhead cost for each department. Use the dropdown menu to select the basis of apportionent. Enter all values to the nearest whole number with no E sign Prepare a statement showing the budgeted overhead cost for each department. Use the dropdown menu to select the basis of apportionent. Enter all values to the nearest whole number with no sign Overhead Basis Service Department Production Department 1 Production Department 2 Indirect Labour 3000 0 Indirect Materials (E) Heat and Light Machine Insurance Floor Area (sq metres) 56250 28125 I 5625 No. of employees e 16666.67 Parts of your answer require attention: Input 3 (numeric input) - Please enter an answer. Input 11 (numeric input) - Please enter an answer, Input 12 (numeric input) - Please enter an