dsfdsf dsf sf fd
dsf ds
dsf f
dsfd fds
sf ds

8. Spreadsheets

Candidates should be able to:

8. 1           Create a spreadsheet

  • create structure
  • explain the purpose of cells, rows, columns, ranges, worksheets and multiple worksheets in a sing!' data file
  • insert a row and a column, delete a row and a column, resize a row and a column, hide a row and a column
  • manipulate cells and their content (including: date and time functions; extracting numeric values from strings, concatenating cell content, protecting: cells, rows, columns, worksheets and multiple worksheets in a single data file)
  • adjust cell, row and column width and height
  • create formatting
  • format cells (including: date, time, text, numeric, currency, percentage, fractions, text orientation, alignment, conditional formatting)
  • format cell emphasis (including: colour, shading, merge, borders, comments)
  • format page (including: page setup, fit to page, margins, header, footer)
  • create formulae and functions explain the difference between a formula and a function
  • use formulae (including: add, subtract, multiply, divide, indices) use absolute reference, relative reference, nested formulae, named cells, named ranges
  • explain why absolute and relative referencing are used
  • use functions (including: sum, average, minimum, maximum, integer, rounding, counting, IF, nested IF, lookup (including: vertical, horizontal) conditional formulae to include counting, sum, average)
  • use validation rules (see 1.5)
  • test validation applied to a spreadsheet
  • test a spreadsheet model and evaluate the effectiveness of test plans for a spreadsheet model
  • verify and validate data entry
  • extract data
  • search using: text, numeric, date, time, Boolean operators (AND, OR, NOT). >, <, =, >=, <=, contains, starts with, ends with
  • sort data lincludina: ascendina. descendina) on multiple columns

8.2 Graphs and charts

  • analyse and select the most appropriate type of graph or chart (including: bar chart, pie chart, line graph, comparative bar chart, comparative line graph)
  • create a graph or chart (including: appropriate data series, from contiguous data, from noncontiguous data. specified range(s))
  • label a graph or chart (including: title, legend, segment labels, segment values, percentages, category axis labels, series labels, value axis labels, scales, set axis scale maximum, set axis scale minimum)

8..3      Modelling

  • describe the characteristics of modelling software
  • analyse the need for computer models
  • evaluate the effectiveness of spreadsheet models (including for: financial forecasting)

8.4      Simulations

    • describe the advantages and disadvantages of using a model to create and run simulations
    • evaluate the use of simulation (including for: natural disaster planning, pilot training, car driving, nuclear science research)


fd sf