Quelpr

Tabulations, Data Management, and Integration · CSEC Electronic Document Preparation and Management

30 past-paper questions on Tabulations, Data Management, and Integration, part of Use of Application Software, from every CSEC Electronic Document Preparation and Management paper on Quelpr.

Practise Tabulations, Data Management, and Integration
  1. 2(a)2 marks· CSEC Electronic Document Preparation and Management · 2014 · Paper 2Produce the main document and the data file following all given instructions.
  2. 2(e)2 marks· CSEC Electronic Document Preparation and Management · 2014 · Paper 2Print one copy of the main document showing the merge fields.
  3. 2(f)4 marks· CSEC Electronic Document Preparation and Management · 2014 · Paper 2Create the data file from the four recipient addresses provided.
  4. 2(h)3 marks· CSEC Electronic Document Preparation and Management · 2014 · Paper 2Sort the data file by last name.
  5. 2(j)3 marks· CSEC Electronic Document Preparation and Management · 2014 · Paper 2Print one copy of each data file, 'data1' and 'data2', displaying the records.
  6. 2(k)4 marks· CSEC Electronic Document Preparation and Management · 2014 · Paper 2Merge the documents ('letter' and 'data2') and print the FIRST and LAST letters.
  7. 3(a)8 marks· CSEC Electronic Document Preparation and Management · 2014 · Paper 2Type the registration data in a spreadsheet using landscape orientation, following all layout and formatting instructions.
  8. 3(b)(i)3 marks· CSEC Electronic Document Preparation and Management · 2014 · Paper 2Calculate the Balance Owed for each participant.
  9. 3(b)(ii)2 marks· CSEC Electronic Document Preparation and Management · 2014 · Paper 2Calculate the Total Fee.
  10. 3(b)(iii)2 marks· CSEC Electronic Document Preparation and Management · 2014 · Paper 2Calculate the Total Amount Paid.
  11. 3(b)(iv)2 marks· CSEC Electronic Document Preparation and Management · 2014 · Paper 2Calculate the Average Fee.
  12. 3(b)(v)2 marks· CSEC Electronic Document Preparation and Management · 2014 · Paper 2Calculate the Average Amount Paid.
  13. 3(d)9 marks· CSEC Electronic Document Preparation and Management · 2014 · Paper 2Create a column chart titled 'Payments to Date' displaying total fees and total payments to date, labelling all axes.
  14. 1(b)(i)6 marks· CSEC Electronic Document Preparation and Management · May/June 2010 · Paper 2Type the document shown using a spreadsheet program.
  15. 1(b)(iv)3 marks· CSEC Electronic Document Preparation and Management · May/June 2010 · Paper 2Insert Sheet1 into the letter after the first paragraph.
  16. 1(a)6 marks· CSEC Electronic Document Preparation and Management · May/June 2013 · Paper 2Create a datafile containing specified fields (<Title>, <First Name>, <Last Name>, <Address 1>, <Address 2>, <Address 3>, <Course>, <Date>, <Fees>) using the provided recipient details.
  17. 1(d)2 marks· CSEC Electronic Document Preparation and Management · May/June 2013 · Paper 2Print a copy of the standard letter showing the merge fields.
  18. 1(e)2 marks· CSEC Electronic Document Preparation and Management · May/June 2013 · Paper 2Merge the datafile with the standard letter.
  19. 1(f)2 marks· CSEC Electronic Document Preparation and Management · May/June 2013 · Paper 2Print the merged letters for Mr Ronaldo Morris and Mrs Silvia Finestre.
  20. 2(a)16 marks· CSEC Electronic Document Preparation and Management · May/June 2013 · Paper 2Type the spreadsheet in landscape orientation following all instructions: header, Algerian font size 14, 'output' cell style for headings, formula to calculate average marks, tutor's signature, today's date, and…
  21. 2(b)10 marks· CSEC Electronic Document Preparation and Management · May/June 2013 · Paper 2Type the memorandum to The Registrar from the Dean of Faculty, Business Studies (reference MJC/(your initials) and today's date), copy the table from the spreadsheet, fill in the count of regular students achieving over…
  22. 2(a)4 marks· CSEC Electronic Document Preparation and Management · May/June 2016 · Paper 2Produce the main document and the data file following all given handwritten instructions and formatting rules.
  23. 2(e)6 marks· CSEC Electronic Document Preparation and Management · May/June 2016 · Paper 2Merge the documents (ICT1 and schools) and save as ICT2.
  24. 2(g)4 marks· CSEC Electronic Document Preparation and Management · May/June 2016 · Paper 2Print the FIRST and LAST letters of ICT2.
  25. 3(a)4 marks· CSEC Electronic Document Preparation and Management · May/June 2016 · Paper 2Type the provided tabular document in a spreadsheet following all instructions.
  26. 3(b)2 marks· CSEC Electronic Document Preparation and Management · May/June 2016 · Paper 2Use the names of the schools as created in the data file in Question 2.
  27. 3(c)4 marks· CSEC Electronic Document Preparation and Management · May/June 2016 · Paper 2Insert four columns to the right of the last column shown, naming them TOTAL STUDENTS, MEALS, TRAVELLING, and SCHOOL TOTAL, respectively.
  28. 3(d)2 marks· CSEC Electronic Document Preparation and Management · May/June 2016 · Paper 2Apply MEALS cost at 15.00 per student and TRAVELLING cost at 200.00 per school.
  29. 3(e)6 marks· CSEC Electronic Document Preparation and Management · May/June 2016 · Paper 2Determine the entries for the added columns using the necessary calculations.
  30. 3(h)2 marks· CSEC Electronic Document Preparation and Management · May/June 2016 · Paper 2Save the pie chart on the same page as the spreadsheet.

Related topics in Use of Application Software