Advanced Arithmetic Formulae · CSEC Information Technology

9 past-paper questions on Advanced Arithmetic Formulae, part of Spreadsheets, from every CSEC Information Technology paper on Quelpr.

1. 7(c)2 marks· CSEC Information Technology · 2015 · Paper 2It is projected that the 2016 sales for each branch will increase by 10% over the 2015 sales. Write the formula to compute the 2016 projected sales for the BCE branch.
2. 5(a)1 mark· CSEC Information Technology · January 2010 · Paper 1Compute the eight-bit binary representation of the decimal number 17.
3. 5(b)1 mark· CSEC Information Technology · January 2010 · Paper 1Compute the sign-and-magnitude representation for the decimal number NEGATIVE 17.
4. 5(c)1 mark· CSEC Information Technology · January 2010 · Paper 1Compute the result of 55 – 25 using eight-bit, two’s complement representation and express the answer as an eight-bit binary number.
5. 5(d)1 mark· CSEC Information Technology · January 2010 · Paper 1State the decimal equivalent for the binary coded decimal number 0011 0101 1000.
6. Q121 mark · multiple choice· CSEC Information Technology · May/June 2017 · Paper 1Item 12 refers to the following picture. Which of the following types of documents is shown in the picture?
7. Q441 mark · multiple choice· CSEC Information Technology · May/June 2017 · Paper 1Which formula should be placed in Cell E2 to obtain the stock balance?
8. Q351 mark · multiple choice· CSEC Information Technology · May/June 2019 · Paper 1Which of the following are used in a spreadsheet formulae? I. Values II. Cell addresses III. Mathematical operations
9. 8(b)2 marks· CSEC Information Technology · May/June 2019 · Paper 2Write a formula to calculate the number of days that Asmara Royal has had her permit.