Task 5 - Create and use a simple business spreadsheet
Choose your scenario:
Downloadable Tunes
- - - - Estate Agents
Pass
Help sheet
A1 - Enter simple formulae that work.
A2 - Add basic row and column headings.
A3 - Add some cell borders or colour
A4 - Change some data to obtain different results.
The owner has noticed that order number 1001 has been entered incorrectly.
The amount of £15 should be £20 and the VAT should be 3.50. Change these entries.
A5 - Print out the spreadsheet in normal view
Example
Merit
B1 - Created an effective business spreadsheet displaying accurate figures.
B2 - Added a title and appropriate row/column headings.
B3 - Used several different formulas and at least one function
B4 - Added cell borders, colour and formatted some cell data types.
B5 - Edited the spreadsheet by inserting rows.
Order 1014 has now been paid and needs to be entered in an appropriate place in the spreadsheet
| Order No | Date Received | Amount | Vat |
| 1014 | 28-Jul | 16 | 2.80 |
B6 - Print the Spreadsheet in Normal View
Print out the spreadsheet in Normal view using print preview and suitable page orientation to minimise the paper used.
B7 - Print out the spreadsheet in Formulae View
Print out the spreadsheet in Formulae View using print preview and suitable page orientation to minimise the paper used.
Distinction
C1 - Use formulas efficiently and use at least two functions appropriately.
Suggested functions:
=SUM, =AVERAGE, =MAX, =MIN, =IF
C2 - Format the spreadsheet effectively using a range of format options:
- cell borders
- cell colour
- cell data types
- text wrap
- text direction
C3 - Print both normal and formulae view displaying:
-appropriate headers and footers
- row and column headings
- grid lines.