2. GLZ 10 11 12 13 14 15 16 17 Answere 1. What is the last column heading in an Excel workbook? 2. P The button displays the sum of the selected cells directly after the selected cells. 3.2 What is the result when changing the number -589 to "Accounting" a format? 4. With reference to the following diagram, what will be displayed in cell D7 if it has the formula -B7&"."&C7&"@hkcc.edu.hk"?e BCD 7 Mike Chan 5.e What is the result after transposing B3:C5 in the following figure? B C D 6. Which Chart Type is the following diagram? Page 1 of 2 AaBbcode ASSCODE AaBb Aa 2016 First Quarter Expenses Analysis 920% 83.3% 827% (Highest Spont) (Average % Spert) lowed Spent) Budget 120 000 00 Spent 2 Romaining 2120000 Above Mean 15 000 00 0 000 00 00 00 00 00 00 120491059567 20000 10000 0 0 100000 Yes Yes Yes No 00 00 SO5.000.00 1605110% 40000 350.00 Unities Insurance Fees Wapes Other Rent 30 000 Subtotal 10.00000 10000 36.000.00 10000 8 Date 20161 2016/1/23 2015/4/30 201621 20152 201521 2016215 2016223 20162/29 Payment Type Autopay PayPal Cheque Cash Cedit Card Autoay The Party C Card Cheque 8 8 Description January Ofice Rent Annual Dinner Lucky Draw Ws Sanary-AP Healthcare form at Fourwy Ocean Professional Services of Account Electricity Wages Cost of Stone March Oficent Telephone and Services Charges for Business Registration Renewal LED Lights 8 8 8 8833 8 8 8 2016315 2016/3/18 2016/321 Autopay Credit Card Credit Card Alipay 3 * Expense Total 8.30000 3.800.00 1820000 25000 Answer 7. Which button in Home - Alignment Group (Alignment Group of el the Home Tab) can be used to display the title "2016 First Quarter Expenses Analysis across cells B2 to K3? 8. Write down what will be typed EXACTLY in cell B6, which show the average value of "% Spent" among the cell range E6 to 36.2 9. The values of "Above Mean in cells E8 to K8 are determined by the value of cell B6. If the % Spent of a specific category (row 6) E e Answer 7.2 Which button in Home - Alignment Group (Alignment Group of the Home Tab) can be used to display the title "2016 First Quarter Expenses Analysis" across cells B2 to K3? 8. Write down what will be typed EXACTLY in cell B6, which shows the average value of % Spent" among the cell range E6 to J62 9. The values of "Above Mean" in cells E8 to K8 are determined by the value of cell B6. If the "% Spent" of a specific category (row 6) is higher than the "Average % Spent" in cell B6, "Yes" will be displayed; otherwise "No" will be displayed. Write down what will be typed EXACTLY in cell E8 by using RELATIVE and ABSOLUTE cell referencing, so that it can be used to autofill the content of the cells F8 to K8. 10. If you want to freeze the top 10 rows and first 4 columns of the above worksheet, which cell should be selected before using the DI Freeze Panes Panes" tool? End of Paper