a provided establish an establish an accounting system to accounting system accounting system record simple and record simple and records transactions transactions transactions, some of which will be complex extracts an income extracts a properly extracts a properly statement and classified income classified income balance sheet from statement and statement and an accounting balance sheet from an balance sheet from package. Some errors accounting package an accounting may occur and identifies errors package, identifies errors and makes corrections uses provided uses spreadsheets tools creates sophisticated spreadsheet templates and techniques to spreadsheets to to prepare prepare accounting prepare accounting accounting report.^. reports^. They are reports^. They are There may be errors accurate and accurate and in terms of accuracy appropriately appropriately and classifications of classified. Formatting classified. Formatting items and functions are and functions such straightforward (e.g. as shading, tabs, add, subtract) date and time formats, text wrap and constructing formulae are required uses a spreadsheet to classifies and enters selects, classifies and calculate ratios for data into a enters data into a decision making spreadsheet to spreadsheet to purposes from calculate ratios using calculate ratios provided, totalled formulae. using formulae and data. Calculations produces charts and are straightforward. graphs for decision making purposes.
a provided accounting system to record simple transactions establish an accounting system and record simple transactions establish an accounting system and records transactions, some of which will be complex extracts an income statement and balance sheet from an accounting package. Some errors may occur extracts a properly classified income statement and balance sheet from an accounting package and identifies errors extracts a properly classified income statement and balance sheet from an accounting package, identifies errors and makes corrections uses provided spreadsheet templates to prepare accounting report.^. There may be errors in terms of accuracy and classifications of items uses spreadsheets tools and techniques to prepare accounting reports^. They are accurate and appropriately classified. Formatting and functions are straightforward (e.g. add, subtract) creates sophisticated spreadsheets to prepare accounting reports^. They are accurate and appropriately classified. Formatting and functions such as shading, tabs, date and time formats, text wrap and constructing formulae are required uses a spreadsheet to calculate ratios for decision making purposes from provided, totalled data. Calculations are straightforward. classifies and enters data into a spreadsheet to calculate ratios using formulae. selects, classifies and enters data into a spreadsheet to calculate ratios using formulae and produces charts and graphs for decision making purposes.