BVSS 2019 P1

Name: ________________________________ ( ) Class: __________________ COMPUTING 7155/01 2 September 2019 PAPER 1 Written 2 hours Candidates answer on the Question Paper. No Additional Materials are required. ------------------------------------------------------------------------------------------------------------------------------------ READ THESE INSTRUCTIONS FIRST Write your Name, Register Number and Class on the top of this page. Write in dark blue or black pen. You may use a soft pencil for any diagrams, graphs or rough working. Do not use staples, paper clips, highlighters, glue or correction fluid. Answer all questions. No marks will be awarded for using brand names of software packages or hardware. 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. Setter: Mr Low Chee Wah Parent’s signature : __________________ This question paper consists of 16 printed pages. 80 BUKIT VIEW SECONDARY SCHOOL PRELIMINARY EXAMINATION Secondary 4 Express BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL

2 1. A company uses spreadsheet software. Match each description to the correct spreadsheet function. [4] Description Returns number rounded up to an exact multiple of significance. l Returns the future value of a loan given the interest rate, number of periods and the present value. l Returns the number of non-empty cells in the given range references. l Returns the interest payment in the specified period for a loan of the present value with an interest rate over the number of periods. l Function l Ceiling l Counta l Count l Floor l FV l IPMT l PPMT l PV l Round

3 2. (a) Convert the binary number 1010 1011 into a denary number. Show your working. …………………………………………………………………