US 18743

Outcome 1:

Produce a spreadsheet from instructions using supplied data.

Evidence requirements

1.1 Data is entered into the spreadsheet, using labels and values, in accordance with instructions.

1.2 Data is formatted in accordance with instructions.

1.3 Spreadsheet cell functions and/or formulas are used in accordance with the instructions.

• Range includes but is not limited to – add, subtract, multiply, divide, sum.

1.4 Two different types of graphs are produced from spreadsheet cell ranges in accordance with instructions.

1.5 The spreadsheet, formulas and graphs are presented in hard or soft copy in accordance with the layout requirements of the instructions.