| 0417 Information and Communication Technology Past Paper Resources
BUY / View this Course
Paper 1 Topic Questions and Mark Schemes / Topic 20 Spreadsheets
  • 20-IGCSE-Data-analysis-Mark-Scheme-Paper-1-Set-1.pdf
  • 20-IGCSE-Data-analysis-Mark-Scheme-Paper-1-Set-2.pdf
  • 20-IGCSE-Data-analysis-Mark-Scheme-Paper-1-Set-3.pdf
  • 20-IGCSE-Data-analysis-Topic-Questions-Paper-1-Set-1.pdf
  • 20-IGCSE-Data-analysis-Topic-Questions-Paper-1-Set-2.pdf
  • 20-IGCSE-Data-analysis-Topic-Questions-Paper-1-Set-3.pdf
  • 20.1-IGCSE-create-a-data-model-Mark-Scheme-Paper-1-Set-1.pdf
  • 20.1-IGCSE-create-a-data-model-Mark-Scheme-Paper-1-Set-2.pdf
  • 20.1-IGCSE-create-a-data-model-Mark-Scheme-Paper-1-Set-3.pdf
  • 20.1-IGCSE-create-a-data-model-Topic-Questions-Paper-1-Set-1.pdf
  • 20.1-IGCSE-create-a-data-model-Topic-Questions-Paper-1-Set-2.pdf
  • 20.1-IGCSE-create-a-data-model-Topic-Questions-Paper-1-Set-3.pdf
  • 20.2-IGCSE-test-the-data-model-Mark-Scheme-Paper-1-Set-1.pdf
  • 20.2-IGCSE-test-the-data-model-Topic-Questions-Paper-1-Set-1.pdf
  • 20.4-IGCSE- present-data-Mark-Scheme-Paper-1-Set-1.pdf
  • 20.4-IGCSE- present-data-Topic-Questions-Paper-1-Set-1.pdf
Note:

Spreadsheets IGCSE ICT Topic Questions


20.1 Create a data model Candidates should be able to: Create and edit a spreadsheet model Notes and Guidance Insert cell(s), row(s) and column(s), delete cell(s), row(s) and column(s), merge cells Create formulae using cell references Replicate formulae using absolute and relative cell references where appropriate Use arithmetic operators in formulae including add, subtract, multiply, divide, indices Use named cells and named ranges Use functions including sum, average, maximum, minimum, integer, rounding, counting, LOOKUP, VLOOKUP, HLOOKUP, XLOOKUP, IF Use external data sources within functions Use nested functions Candidates should know and understand: Formulae and functions The difference between a formula and a function Order of operations The order in which mathematical operations are performed including the use brackets to make sure that formulae work Cell referencing Characteristics and use of absolute and relative cell referencing


20.2 Manipulate data Candidates should be able to: Sort data Notes and Guidance Using a single criterion, or multiple criteria sort data into ascending or descending order Search and select data Using a single criterion, or multiple criteria, select subsets of data Perform searches using a variety of operators including AND, OR, NOT, >, <, =, >=, <=, <> Perform searches using wildcards

20.3 Present data Candidates should be able to: Adjust the display features Notes and Guidance Display either formulae or values Adjust row height, column width and cell sizes so that all data, labels, and formulae is fully visible Wrap text within cells so that all data is fully visible Hide and display rows and columns Format a spreadsheet Enhance a spreadsheet including text colour, cell colour, bold, underline, italic, shading Format numeric data appropriately including to display the number of decimal places, different currency symbols, percentages Use conditional formatting to change the display format depending on the contents of a cell Set page layout Set the orientation to portrait or landscape Control the page layout to print including specified number of pages, print area, display or hide gridlines, display or hide row and column headings








Course content