MFSS 2020 P1

Name: ______________________________ ( ) Class: _______ MONTFORT SECONDARY SCHOOL PRELIMINARY EXAMINATION 2020 Secondary 4 Express COMPUTING Paper 1 Written 8.15 am 7155/01 16 Sep 2020 (Wed) 2 hours READ THESE INSTRUCTIONS FIRST Do not open this booklet until you are told to do so. Write your name, index number and class in the spaces provided at the top of this page. Write in dark blue or black pen. You may use an HB pencil for any diagrams, graphs or rough working. Approved calculators are allowed. Answer all questions. At the end of the examination, fasten all your work securely together. The number of marks is given in brackets [ ] at the end of each question or part question. You should show all your working. The total marks for this paper is 80. For Examiner’s Use Total 80

2 Parent’s Signature: _______________________ This document consists of 13 printed pages and 1 blank page. Setter: Mr Wong Teck Piaw 1 Amanda has a taken a $100,000 study loan from the bank. The loan is to be repaid over 5 years. The interest rate is 6% per year. She has a spreadsheet to keep track of the repayments and the amount she owes. (a) State the type of data that is held in each of the following cells. A1................................................................................................................ A8................................................................................................................ B1................................................................................................................ (b) (i) The cell B4 shows the monthly payment amount. Identify the most appropriate function to use in cell B4, if the interest rate and monthly payment amount remain the same. …...................................................................................................... (ii) The cell E1 shows the total amount that Amanda has paid to date. The payments are entered in cells B8 to B68. Identify the most efficient function to use in cell E1. …...................................................................................................... [3] [1] [1]

3 (iii) The formula in cell E3 calculates the number of payments made. Identify the most appropriate function to use in cell E3. …...................................................................................................... (iv) Cell E2 shows the amount owed to the nearest whole number. Identify the most appropriate function used in cell E2 to convert the value to the nearest dollar. …...................................................................................................... [1] [1] 2 (a) (i) Convert the denary number 232 into a hexadecimal number. Show your working. …...................................................................................................... …...................