Spreadsheets Fetac Level 4

Course details

Learning Outcomes of Level 4 Spreadsheet Methods 4N1120

Learners will be able to:

• Outline typical spreadsheet functions including document creation
• State the primary functions and processes involved in creating a spreadsheet document
• Use the language associated with spreadsheet applications
• Use with confidence a spreadsheet application to enter and edit text, numbers and dates, and insert and delete columns and rows
• Use arithmetic operators to add, subtract, multiply and pide
• Use formulae and functions within a spreadsheet including sum, average, max, min and count
• Use a range of formatting commands including font size, font colour, background colours, bold, alignments, borders, numbers, decimals and dates
• Modify a spreadsheet document by adding repeating column or row titles, page numbers, date or text to headers and footers, and adjusting to fit on to one page
• Produce a range of basic charts and graphs including pie, column, bar and line with titles and labels