Question 2 Not yet answered Marked out of 2.00 Flag question Question 3 Not yet answered Marked out of 2.00 Flag question General Insurance ✓ Choos.. Allocate Apportion Redecorating Moulding Department Choose... Question 2 Not yet answered Marked out of 2.00 Flag question Question 3 Not yet answered Marked out of 2.00 Flag question General Insurance; Choose... Redecorating Moulding Departmen✓ Choore... Allocate Apportion !!! ab esc Question 5 Not yet answered Marked out of 6.00 P Flag question 300 BO 301 ! 1 Q F1 A B 1 Monthly production 2 3 Month 4 Jan 5 Feb 6 Mar 7 Apr 8 May 9 Jun 10 Jul 11 Aug 12 Sep 13 Oct 14 Nov 15 Dec 16 17 Total 18 19 Average (@ 2 Units 298 The information in the table shows a schedule of working for a production department Which of the following would achieve the total in Cell B171 ✔ Choose... Autosum Ctrl + t Ctrl + s F2 F4 What is the best formula to achieve the result in cell B19? Choose... Which of the following statements is true regarding the au of items within a cell, before any editing? Choose... F2 149 247 382 451 300 298 187 361 85 394 322 400 W 3576 #3 3 F3 E S4 FEB 23 Q F4 R % 5 0 m İ F5 T 6 ning F6 Y & esc Question 5 Not yet answered Marked out of 6.00 P Flag question BO ! 1 Q F1 ở A B 1 Monthly production 2 3 Month 4 Jan 5 Feb 6 Mar 7 Apr 8 May 9 Jun 10 Jul 11 Aug 12 Sep 13 Oct 14 Nov 15 Dec 16 17 Total 18 19 Average ✓ Choose... 298 The information in the table shows a schedule of working for a production department Which of the following would achieve the total in Cell B17? What is the best formula to achieve the result in cell B19? =TOTAL (B4:B15) 2 =SUM(B4:$B15)/12 =AVERAGE(B$4:$B15) =SUM(B4:B15) =AVERAGE(C4:C15) =SUM(B4:B15)/12 Units F2 W 149 247 382 451 300 298 187 361 85 394 322 400 #3 3576 80 C ements is true regarding the automatic positioning e any editing? Choose... ◆ F3 E 4 FEB 23 Q F4 R % 175 0 Choose... F5 T < 6 c F6 Y BC Mar 7 Apr 8 May 9 Jun 10 Jul 11 Aug 12 Sep 13 Oct 14 Nov 15 Dec 16 17 Total 18 19 Average O 298 The information in the table shows a schedule of working for a production department Which of the following would achieve the total in Cell B17? What is the best formula to achieve the result in cell B19? Choose... F1 D 382 451 300 298 187 361 85 394 322 400 Which of the following statements is true regarding the automatic positioning of items within a cell, before any editing ✓ Choose... Text is right aligned Numbers are right aligned Text is centre aligned Numbers are centred F2 3576 # 80 F3 FEB 23 ㅇ F4 0/ DI Choose... 3₁ F5 <> 00 F6