2021 TSS Computing P1

1 Jennifer has loaned $200,000 from the bank to buy a house. She has set up a spreadsheet to tabulate the instalments to be paid each month. In the spreadsheet shown below, rows 12 to 244 are hidden. (a) State the data formats used in cell B1 and cell B2. ………………………………………………………………………………… [2] (b) Identify the function used in cell B4 to determine the monthly instalment to be paid. …………………………………………………………………………………. [1] (c) Identify the function used in cell C8 to determine the amount of interest to be paid for that month. …………………………………………………………………………………. [1] (d) Evaluate the following spreadsheet formulas: =ROUND(B4,0) ………………………… [1] =CEILING(B8,-10) ………………………… [1] =SUM(B8:B247) ………………………… [1] =LARGE(C8:C247,2) ………………………… [1]

2 (e) Jennifer wants to calculate the number of months where the interest paid is above $100. Write a spreadsheet formula to perform this calculation. …………………………………………………………………………………. [2] (f) Jennifer wants to calculate the amount she will owe the bank after 20 years assuming that she did not pay for any instalments at all. Suggest a spreadsheet function that will help her in this calculation. …………………………………………………………………………………. [1] 2 (a) Convert the binary number 1100 1001 into a positive whole denary number. Show your working clearly. …………………………………………………………………………………. …………………………………………………………………………………. …………………………………………………………………………………. [2] (b) Convert the denary number 148 into an 8-bit binary number. Show your working clearly. …………………………………………………………………………………. …………………………………………………………………………………. …………………………………………………………………………………. …………………………………………………………………………………. …………………………………………………………………………………. …………………………………………………………………………………. …………………………………………………………………………………. …………………………………………………………………………………. …………………………………………………………………………………. [2]

3 (c) Convert the hexadecimal number AE into an 8-bit binary number. …………………………………………………………………………………. …………………………………………………………………………………. …………………………………………………………………………………. [1] (d) In representing RGB codes , hexadecimal numbers are used rather than binary numbers. State two reasons to explain why. …………………………………………………………………………………. …………………………………………………………………………………. …………………………………………………………………………………. [2] (e) The size of computer data are commonly represented as bytes. (i) Describe what is meant by a byte and how it is related to a bit. …………………………………………………………………………… …………………………………………………………………………… [1] (ii) Convert 32 KB into bits. …………………………………………………………………………… …………………………………………………………………………… [1] (iii) Convert 4 GiB into bytes. …………………………………………………………………………… …………………………………………………………………………… [1]

4 3 Amidst the COVID-19 pandemic, people are discouraged from visiting the bank in person and are advised to use online bankin