BVSS 2018 P1

Name: _______________________________ ( ) Class: Sec ______ COMPUTING 7155/01 13 September 2018 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 PRELIM 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) A company uses spreadsheet software. Draw a line between the description and the correct spreadsheet function. Description Function AND It is one of the logical functions to determine if all conditions in a test are TRUE AVERAGE Returns number rounded up, away from zero, to the nearest multiple of significance CEILING Returns the mean of the given numbers ROUND Search the data in column and use associated data in the same row VLOOKUP [4]

3 2. (a) Convert the binary number 11101001 into a denary number. Show your working. ……………………………………………………………………………… ……………………………………………………………………………… ……………………………………………………………………………[2] (b) Convert the denary number 121 int