National 5 Admin Question Paper

​Approx. 20 marks

Form
Query
Report - If you are creating a report you will ALWAYS make a query first
Address Labels

​Approx. 20 marks

Some formatting - merge/centre heading, emphasize headings/totals etc, altering formatting etc, wrapping headings
Basic formulas - addition, subtraction, multiplication etc
Basic functions - SUM< MAX, MIN, AVERAGE, COUNT, COUNTA
IF Statements - often with a calculation in it
Charts

Don'ts

Do not use the word SUM in any formula other than adding a range (more than 2 cells)
eg do not do =sum(C6*C7)

If you are asked to use a named cell - MAKE SURE YOU NAME THE CELL AND USE IT!!

Topics

The Admin Assistant
Customer Care
Health and Safety
Legislation
Security of People, Property and Information
Corporate Image
File Management
Methods of Electronic Communication