Please Help?? Spreadsheets!

Wiggs1311

Hi everyone! I'm resitting my spreadsheet exam/project in 10 days time. I really need to smash it this time, so that I can get my level 3! I've passed every other exam but can't seem to get a grips with this one at all. Any tips/advice would very much be appreciated. I really don't understand how I can't get passed this one!

Adele69

Which areas did you get below requirement? Any particularly tricky areas? Do you use Excel for work?

Most of my class found the creation of a cost analysis layout in Q1 the most difficult and time consuming part of the exam, and few failed it. This was our first L3 exam so it was some time ago that I sat it.

Q1 takes up more time but it is worth allocating only so much of your exam time and moving onto the other questions and coming back to it to get enough marks to pass.

There is a lot of detail in the questions such as save this in one format, colour the tab, mark this text in bold, conditional format this, that if missed mean missing out on a mark here and there which soon addup, and can be messed up, as can formulas when rushing to complete because the Q1 answer didn't come quickly and the rest of the exam suffered for all the time lost at the start.

I think there is some advantage to already being familiar with Excel so you only need to learn how to apply the accounting parts to each question and to follow the question details to the letter.

JoshJ1992

It may be worth looking at youtube for any areas that you may be stuck on. There are literally hundreds of useful videos (I use it as a source of information all the time). Also, there are some tasks as part of the AAT e-learning https://www.aat.org.uk/training/study-support/search which may be worth looking through before your assessment.

RosieJane

My advice would be:

Read the questions thoroughly and pay great attention to detail (i.e. if they want a certain font red, make sure it is red)

If you struggle finding the right formula/function to answer a question, type = in a box and then a word and it brings up a brief description (e.g if you type =count, it will tell you 'counts the number of cells in a range that contain numbers)

For the questions at the end, I was unsure on one and I worked out the answers on the excel sheet by typing the options in a box and seeing what the outcomes were.

Download and read the assessments performance feedback from the study support section on AAT. These guides often explain where students have gone wrong in their exams.