Manipulating Data in a Spreadsheet · CSEC Information Technology

9 past-paper questions on Manipulating Data in a Spreadsheet, part of Spreadsheets, from every CSEC Information Technology paper on Quelpr.

1. 7(b)1 mark· CSEC Information Technology · 2011 · Paper 2What data format has been applied to the data with the number of accounts for each of the banks?
2. 7(c)1 mark· CSEC Information Technology · 2011 · Paper 2The data in the spreadsheet have been sorted. Indicate the name of the field used for the sort.
3. 7(e)1 mark· CSEC Information Technology · 2015 · Paper 2If the spreadsheet is sorted in ascending order by the total sales for each branch, which branch will be at the top of the spreadsheet?
4. 7(d)(i)1 mark· CSEC Information Technology · January 2014 · Paper 2State the criterion to implement the filter to extract all revenue items with a TOTAL greater than 25 000 for the six-month period. (Indicate the column heading and the criterion to be inserted under the column heading.)
5. 7(d)(ii)1 mark· CSEC Information Technology · January 2014 · Paper 2How many revenue items will be extracted by the filter?
6. 7(b)(ii)1 mark· CSEC Information Technology · May/June 2013 · Paper 2If range A4 to F6 was sorted in ASCENDING order by subject, state the cell location of Biology after the sort.
7. Q431 mark · multiple choice· CSEC Information Technology · May/June 2017 · Paper 1Items 43-45 refer to the following spreadsheet. The values in Column B should be formatted using the
8. 8(c)2 marks· CSEC Information Technology · May/June 2019 · Paper 2Explain why the data CANNOT be sorted by the learner's last name.
9. 8(d)1 mark· CSEC Information Technology · May/June 2019 · Paper 2State the name of the feature that allows for the viewing of some rows of data in the spreadsheet.