Microsoft Excel specialists

The programme and exam

Programme overview
What you get
Programme dates
Assignments
Exam
Sample exam questions

Programme overview

Each paper has a 6-month programme. There are two programmes per year starting in March and September. Each programme has 5 assignments, each a month apart. At the end of the 6-month programme, at the end of August and February, there is a 3-hour exam. The assignments make up 20% of the mark and the exam 80%.

 

When you purchase a paper, you can choose which of the 5 papers you want to study and which programme you want to enrol in. The main paper is a prerequisite for the other 4 papers.

 

Each paper has multiple parts. The main paper has 9 parts (see Agenda for details). The parts needed for the first assignment are released when the programme starts. The remaining parts are released two months before the related assignment is due. See assignment dates below.

Example programme:

Main paper - March-2016 programme dates

Main paper – March 2016 is available for purchase and download in the period shown right. The next programme after that is September 2016 with material available from 1 Aug 2016 to 31-Jan-2017.

 

Assignment 1 – Relates to parts 1A, 1B and 1C

 

Assignment 2 – Relates to parts 1D and 1E

 

Assignment 3 – Relates to parts 1F and 1G

 

Assignment 4 – Relates to part 1H

 

Assignment 5 – Relates to part 1I

 

Exam at venues below: Auckland, Wellington, Christchurch Brisbane, Sydney, Canberra, Melbourne, Adelaide, Perth.

1-Dec-2015 to 31-Jul-2016




 

31-Mar-2016

 

30-Apr-2016

 

31-May-2016

 

30-Jun-2016

 

31-Jul-2016

 

 Monday 29-Aug-2016 8AM-11:30AM

What you get

If the qualification is for you, you get an online account where you download the PDF coursework and assignments. From the account, you upload your completed assignments. With your online account, you also have access to the quizzes that appear at the end of each topic as well as to videos available with certain topics.

 

If you are a manager, you can order papers and allocate them to employees as you see fit. Employees can elect to enrol on the current programme or wait for the next. You can track employee progress on downloads, quizzes, assignments and exams.

Online quizzes help you learn

Work through PDF coursework

Optionally, play videos for some topics

Submit assignments and get feedback

Prove your capability with online verification and with certificate

Programme dates

Main paper – March 2016

Available for purchase and download.

 

Assignment 1 submission– Relates to parts 1A, 1B and 1C

 

Assignment 2 submission – Relates to parts 1D and 1E

 

Assignment 3 submission – Relates to parts 1F and 1G

 

Assignment 4 submission – Relates to part 1H

 

Assignment 5 submission – Relates to part 1I

 

Exam at venues below: Auckland, Wellington, Christchurch Brisbane, Sydney, Canberra, Melbourne, Adelaide, Perth.

1-Dec-2015 to 31-Jul-2016

 

31-Mar-2016

 

30-Apr-2016

 

31-May-2016

 

30-Jun-2016

 

31-Jul-2016

 

 Monday 29-Aug-2016

8AM-11:30AM

Main paper – September 2016

Available for purchase and download.

 

Assignment 1 submission– Relates to parts 1A, 1B and 1C

 

 Assignment 2 submission – Relates to parts 1D and 1E

 

 Assignment 3 submission – Relates to parts 1F and 1G

 

 Assignment 4 submission – Relates to part 1H

 

Assignment 5 submission – Relates to part 1I

 

Exam at venues below: Auckland, Wellington, Christchurch Brisbane, Sydney, Canberra, Melbourne, Adelaide, Perth.

1 Aug 2016 to 31-Jan-2017

 

30-Sep-2016

 

31-Oct-2016

 

30-Nov-2016

 

31-Dec-2016

 

31-Jan-2017

 

Monday 27-Feb-2017

8AM-11:30AM

Speciality paper – Model construction and analysis - September 2016

Available for purchase and download.

 

Assignment dates to be advised but will be similar to that of the main paper.

 

Exam at venues below: Auckland, Wellington, Christchurch Brisbane, Sydney, Canberra, Melbourne, Adelaide, Perth.

1 Sep 2016 to 31-Jan-2017




 

Monday 27-Feb-2017

8AM-11:30AM

Speciality paper – Data extraction and analysis with MS Query, PivotTables and Power BI - September 2016

Available for purchase and download.

 

Assignment dates to be advised but will be similar to that of the main paper.

 

Exam at venues below: Auckland, Wellington, Christchurch Brisbane, Sydney, Canberra, Melbourne, Adelaide, Perth.

1 Sep 2016 to 31-Jan-2017




 

Monday 27-Feb-2017

8AM-11:30AM

Assignments

Assignment files need to be uploaded from your online account. You can submit assignments up to 3 calendar days after the due date, but total marks will be reduced by the number of days late divided by 4. For example, if an assignment consists of 4% of the total marks, a submission that is two days late has that percentage reduced to 2%.

Exam

The exam consists of a 1-hour multiple choice questionnaire on paper followed by a 2-hour practical on computer.

 

You must book your place at an exam venue 4 weeks before the exam date. You can place that booking in your online account. At the time or before, you need to upload a scanned image of your photo ID.

 

You may be permitted to place a booking less than 4 weeks before the exam, but that is at the discretion of the AbleOwl company. Contact AbleOwl by email or phone in such circumstances.

 

You need to bring to the exam venue your own computer that runs an accepted version of Microsoft Excel (currently these are Microsoft Office for Windows versions 2007, 2010, 2013 and 2016).

 

On arrival at an exam venue, the examinee needs to present the invigilator with acceptable photo ID. Acceptable photo ID is: Driver’s license, Passport, Student ID. If you do not have a currently valid version of any of these photo IDs, contact the AbleOwl office to discuss what alternatives you can provide.

 

On arrival at an exam venue, you are required to sign an agreement to the following:

  • You will not disclose in any way, in part or in whole, any contents of the exam.
  • You will not copy, transmit, communicate, publish, post, upload, distribute or otherwise transfer any exam content in any form or by any means, verbal, written, electronic or mechanical, for any purpose.
  • You will return the USB memory stick provided by the invigilator to the invigilator by the end of the exam period.
  • You will not retain any files from the USB memory stick provided.
  • On your computer, by the end of the exam period, you will close all open files from the USB memory stick provided.
  • You are not fraudulently impersonating another.
  • Assignments or any other work submitted is completely your own work.
  • With the exception of your computer used for the practical part of the exam and other permitted personal items, you have no other personal items with you for the duration of the exam.
  • The computer you use will have no connection to the internet for the duration of the exam.
  • You will not communicate with others except the invigilator for the duration of the exam.
  • You will not attempt to see or use answers provided by other examinees.

    On arrival at an exam venue, you will surrender all personal items except permitted items to the invigilator.

     

    Not-permitted items include but are not limited to mobile phones, cameras, calculators, electronic devices except those permitted, paper, booklets and books. All such items must be surrendered to the invigilator before the start of the exam. You can collect your personal belongings when you leave the exam.

     

    Permitted items are: the computer used for the practical part of the exam, pens, drink and a watch that has no capability to connect to the internet.

     

    Food and beverage are not provided. You are permitted to have a drink bottle during the exam.

     

    The invigilator will assign you a desk.

     

    During the exam, the invigilator will note the time elapsed since the start of the exam on a board at the front of the exam room.

     

    You should arrive 15-30 minutes before the exam start which is at 8:30AM. That will give you time for verification with the invigilator, signing of the agreement, handing over personal belongings and setting up of your laptop.

     

    Power for your laptop will be supplied to the desk. You need to bring the power adaptor for your laptop. The laptop is needed solely for the duration of the 2-hour practical.

     

    During the 1-hour multiple choice part of the exam, which is first, your laptop needs to be powered down. Preferably, you would power-down in sleep mode so that it can be restarted quickly.

     

    Between the 1-hour multiple choice and the 2-hour practical, there is a 15-minute break. In that period, you should power up your laptop.

     

    You are permitted to visit the toilet at any time during the exam. Visits to the toilet may be monitored.

     

     If the invigilator believes that you have violated any of the agreement rules, you will be barred from the exam and may be prevented in future from taking any further exams.

     

    Bring your own ink pens, which must be black or blue.

     

    The 1-hour multiple-choice exam is in paper form and will be placed face-down on your desk a few minutes before the exam start time. You may turn the paper over when the invigilator announces the start of that part of the exam.

     

    There are five options for each multiple-choice question. Answer by writing the letter A, B, C, D or E. You may revise an answer by crossing it out and entering another letter.

     

    For the 2-hour practical exam, you will be provided with a USB memory stick several minutes before the start of that part of the exam. You are permitted to insert the stick into a USB port on your laptop at that time. However, you must not open any files until the invigilator announces the start of that part of the exam.

     

    You must not copy any files from the USB stick to another drive. Your completed files must be saved back to the USB stick only. Hand your USB stick back to the invigilator when you finish the exam.

    Checklist of items to bring to the exam

    Photo ID

    Laptop with Windows, Excel 2007 or later version and a USB port for opening and saving files to.

    Power adapter for laptop.

    Pens of black or blue ink.

    Drink as you may need for the duration of the exam

    Sample exam questions

    Multiple-choice questions
    Formulas

    To check whether two numbers in A1 and A2 are effectively the same, which of the following formulas is the simplest, reliable one to do so:

    (a)   =SUM(A1-A2)<0.001

    (b)   =SIGN(A1-A2)<0.001

    (c)   =ROUND(A1-A2,0)<0.001

    (d)   =ABS(A1-A2)<0.001

    (e)   =A1=A2

    To make the total of M22:M33 equal the sum of the formatted values:

    (a)   Enter total formula =SUMPRODUCT(ROUND(M22:M33,0))

    (b)   Enter total formula =ROUND(SUM(M22:M33),0)

    (c)   Enter total formula =SUMROUND(M22:M33,0)

    (d)   Switch on the Precision as Displayed option.

    (e)   A and D

    If the Status Bar Calculate indicator does not disappear after you press F9, the possible reasons are:

    (a)   The number of formula references is beyond a certain limit.

    (b)   There is a circular reference calculation and a certain iteration option is on.

    (c)   There is some other option that has been switched on.

    (d)   A and B

    (e)   A, B and C

    Possible causes of slow calculation include:

    (a)   Lookup functions

    (b)   Volatile functions

    (c)   Array formulas

    (d)   A and C

    (e)   A, B and C

    Practical questions
    Structure and presentation

    (1) Open ExTitlesBorders.xlsm and go to sheet rKey.

    (2) Improve the report shown below, which is in the range K10:R38.

             

    Figure 99 – Sheet to be reformatted.

    File: ExTitlesBorders.xlsm, sheet: rKey

    The side of the report needs to be improved to show how it is divided vertically. The report has financial and physical figures. There are direct and indirect costs.

     

    An additional month will be inserted each month and, so, the sheet needs to be altered so that is quick to do.

     

    Improve the formatting in other ways to make the report as clear and readable as possible.