← Administration & IT syllabus

ScotlandAdministration & IT

IT Solutions for Administrators: Spreadsheets

3 dot points across 3 inquiry questions. Click any dot point for a focused answer with worked past exam questions where available.

How do you manage multiple worksheets and link data between files in a spreadsheet?

Managing worksheets and workbooks, consolidating data across sheets, creating dynamic links between software applications, and importing and exporting spreadsheet data from and to external sources.
An SQA Higher Administration and IT answer on managing worksheets and workbooks, consolidating data across sheets, creating dynamic links between applications, and importing and exporting spreadsheet data to and from external sources.
10 min answer →

How do you turn spreadsheet data into clear charts and print it correctly?

Creating and formatting charts from spreadsheet data (choosing an appropriate chart type and adding titles, labels and legends), and printing in a range of views and selections (formulae view, gridlines and headings, fit to page, selected ranges).
An SQA Higher Administration and IT answer on creating and formatting charts from spreadsheet data, choosing an appropriate chart type, and printing in a range of views and selections such as formulae view, gridlines, fit to page and selected ranges.
9 min answer →

Which spreadsheet functions and formulae does Higher Administration and IT require, and how are they used?

Using spreadsheet functions, formulae and features at Higher level, including absolute and relative cell references, logical and lookup functions (IF, nested IF, COUNTIF, SUMIF, VLOOKUP), statistical functions, named ranges and conditional formatting.
An SQA Higher Administration and IT answer on spreadsheet functions, formulae and features, covering absolute and relative cell references, logical and lookup functions such as IF, nested IF, COUNTIF, SUMIF and VLOOKUP, statistical functions, named ranges and conditional formatting.
11 min answer →