# 139187 Level 3 Unit 19 Spreadsheet Mode Essay

3515 Words Dec 18th, 2014 19 Pages
Cambridge
TECHNICALS

OCR LEVEL 3
CAMBRIDGE TECHNICAL
CERTIFICATE/DIPLOMA IN

IT
Y/601/6637
LEVEL 3 UNIT 19
GUIDED LEARNING HOURS: 60
UNIT CREDIT VALUE: 10

Y/601/6637
LEVEL 3 UNIT 19

AIM OF THE UNIT
The success of a business relies on its methods of recording business transactions. With the use of complex spreadsheets this task is made relatively easy for businesses. A business therefore requires employees to have knowledge of how to create a spreadsheet and how to use formulae and functions effectively. This unit will provide the learner with the skills to enable them to create and use a complex spreadsheet model. The aim of this unit is to help the learner understand how spreadsheets can be
+, -, /, *)
• simple functions (e.g. SUM, AVERAGE, COUNT, MIN, MAX)
• logical functions (e.g. IF, nested IF, AND, OR, NOT, SUMIF)
• financial functions (e.g. ISPMT, PMT, PV)
• text functions (e.g. UPPER, LOWER, CONCATENATE)
• date and time functions (e.g. TODAY, DAY, HOUR)
• lookup and reference functions (e.g. LOOKUP, VLOOKUP,
HLOOKUP)
• math & trig functions (e.g. ROUND, CEILING, RAND)
• data ranges.

Automation
• macros
• activeX controls
• control Toolbox
• visual basic.
Summary tools
• sub-totals
• filtering
• sorting and multiple sorts
• pivot tables.

Presenting data
• user interface
• formatted charts and graphs
• forms and reports.

LO4 Be able to test and document spreadsheet models Testing
• create test table/plans
• against clients requirements
• formulae and functions

Formatting
• fonts
• page orientation

www.ocr.org.uk

header and footer colour conditional formatting formatting of cells (e.g. integer, date, currency, text) charts and graphs (e.g. labels, axes, scales and colour) text styles (e.g. bold, italics, underline) borders and shading column alignment.

4

Spreadsheet Modelling Level 3 Unit 19

data validation error messages automation layout.

Export formats
• exporting data in different formats (e.g. xls, csv, txt, xms, xml, html).
User documentation
• purpose and target audience
• hardware and software requirements