design and create a business
spreadsheet for a given purpose using at least two different
calculations
-
contain sufficient
row / column headings to make the spreadsheet reasonably easy to
understand
-
at least two
different calculations, but must work some formatting will be
applied to improve the appearance of the spreadsheet
-
print out
spreadsheet (PDF)
-
print out
spreadsheet (PDF) in formula view
-
change some of the
numeric data in the spreadsheet to model the expected outcome for
scenario 1
-
change some of the
numeric data in the spreadsheet to model the expected outcome for
scenario 2
-
print-out
spreadsheet showing changes
-
print out
spreadsheet in formula view
|
design and create an effective business
spreadsheet for a given purpose displaying accurate figures
- contain a title and appropriate
row / column headings
- several different formulas,
including at least one function and at least one arithmetic operator
will have been used
- range of formatting
- preview and print out
spreadsheet using appropriate page orientation and number of pages
- note and explain the results
(screen-prints)
- note and explain the results
(screen-prints)
|
design and create an effective business
spreadsheet for a given purpose displaying accurate figures
- use appropriate headers and /
or footers and will set at least one further print layout feature
appropriately
- used efficiently and include
the appropriate use of at least two functions and at least two
different arithmetic operators
- formatted effectively using a
range of format options
|