Basic Pre-defined System Functions · CSEC Information Technology

9 past-paper questions on Basic Pre-defined System Functions, part of Spreadsheets, from every CSEC Information Technology paper on Quelpr.

1. 7(d)2 marks· CSEC Information Technology · 2011 · Paper 2Write the function that should be used to find the HIGHEST number of loan accounts in a bank.
2. 7(b)2 marks· CSEC Information Technology · 2015 · Paper 2Write the function to find the maximum YEARLY Total for the period 2013-2015.
3. 2(c)(iv)2 marks· CSEC Information Technology · 2022 · Paper 2Write the formula/function to be inserted in Cell B8 to calculate the total number of books sold on Monday.
4. 7(a)3 marks· CSEC Information Technology · January 2014 · Paper 2State the cell address and the function required in the cell to compute the total revenue collected from sponsors.
5. 7(b)(i)4 marks· CSEC Information Technology · May/June 2013 · Paper 2Write the formula used to calculate the total number of students who passed Chemistry.
6. 7(c)(i)1 mark· CSEC Information Technology · May/June 2013 · Paper 2State the name of the function that should be used to find the number of subjects listed in the spreadsheet.
7. 7(c)(ii)1 mark· CSEC Information Technology · May/June 2013 · Paper 2State the name of the function that should be used to find the LEAST number of passes with Grade I.
8. Q451 mark · multiple choice· CSEC Information Technology · May/June 2017 · Paper 1The function to display the text 'LOW' in cell G2 is
9. Q451 mark · multiple choice· CSEC Information Technology · May/June 2019 · Paper 1Given that E2 < F2, which of the following functions will display the text 'LOW' in cell G2?