Spreadsheets: Unit Standard 2785

Spreadsheets: Unit Standard 2785

Create workbooks that include date, time, financial and logical functions. You will learn how to link worksheets with 3-D references, create macros and work with templates. This manual covers:

  • Creating formulas with absolute cell references
  • Working with and printing large worksheets
  • Date, time, financial and logical functions
  • Linking worksheets and workbooks
  • Charts, sorting, macros and templates
  • Creating a spreadsheet that solves a business problem


ISBN: 1-877350-62-1
Total pages: 160+
Qualification: NZQA Unit Standard 2785

Table of Contents