Spreadsheet exam
hyperseven
Registered Posts: 4
Has anyone sat this recently, if so it's it similar to the test assessment that is on AAT?
0
Comments
-
Fairly similar, but as many people in class moaned the details in question 1 - designing a spreadsheet - is deliberately confusing.
Otherwise yes, it's the same format: 5 questions, the 1st is usually the longest and sometimes it can be easy, generally a income cash forecast. The others include a formulas, lookups, charts or graphs and multiple choice.1 -
Cheers. I am fairly competent at spreadsheets, but fear the wording of the questions will be a hindrance.0
-
The best advice that my tutor gave to our class before the exam was to take our time and read everything carefully. EVERYTHING.
He said that in the exam, there's 17 marks in total. 1 of those marks is for doing a vlookup (in task 4), and another 1 or 2 marks are for creating a PivotTable.
But there's also 1 mark for making sure that column headings are formatted correctly, 1 mark for making sure all monetary amounts are listed in Currency format, 1 mark for adding your name and AAT number in the page header, 1 mark for colouring individual cells if it mentions that at some point (it usually asks somewhere for you to highlight cells by colouring the text and/or cell background), and a couple of other similar basic things.
So don't worry so much about the more complex parts (like Vlookups and PivotTables), and just focus on following every single instruction to the letter. The basic stuff - highlighting cells, formatting number types, etc; is really basic, and carries enough marks to pass the whole exam.Accounts Executive, ғɪᴀʙ ᴍᴀᴀᴛ
QBO & Xero certified advisor
AAT
Level 2 Certificate in Accounting - 17 Jun 2015
Level 3 Diploma in Accounting - 22 Jan 2016
Level 4 Diploma in Accounting - 19 Dec 2017
MAAT - 27 Mar 2018
ACCA
Advanced Diploma in Accounting and Business...
F4 Corporate and Business Law - 4 Jun 2019
F5 Performance Management - 15 July 2019
F6 Taxation (United Kingdom) - 3 Dec 2019
F8 Audit and Assurance - 2 Mar 20200
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 12.5K For AAT students
- 323 NEW! Qualifications 2022
- 165 General Qualifications 2022 discussion
- 11 AAT Level 2 Certificate in Accounting
- 56 AAT Level 3 Diploma in Accounting
- 88 AAT Level 4 Diploma in Professional Accounting
- 8.8K For accounting professionals
- 23 coronavirus (Covid-19)
- 272 VAT
- 92 Software
- 273 Tax
- 135 Bookkeeping
- 7.2K General accounting discussion
- 200 AAT member discussion
- 3.8K For everyone
- 38 AAT news and announcements
- 345 Feedback for AAT
- 2.8K Chat and off-topic discussion
- 582 Job postings
- 16 Who can benefit from AAT?
- 36 Where can AAT take me?
- 42 Getting started with AAT
- 26 Finding an AAT training provider
- 48 Distance learning and other ways to study AAT
- 25 Apprenticeships
- 66 AAT membership