Spreadsheet Exam
cazalino
Registered Posts: 44 Epic contributor ๐
Hi i have my spreadsheet exam on friday and am going through a preactice exam and cant for the life of me see how to print a document showing formulas.
Can anyone assist please - thanks
Can anyone assist please - thanks
0
Comments
-
Hi,
This is dependent on what version you're using.
Go to the 'Formulas' tab > go to 'Formula Auditing'> Click 'show formulas' > And print
Hope this helps0 -
I don't know if this will be of any use to you but I use Control + ` (the button next to the number 1 button) to show formulas. I believe it works in every version of excel so it might be worth remembering if your using a different version of excel to sit your exam.
Good luck for Friday.0 -
I got my result today for this exam and I'm glad to say that I've finally passed on my 2nd attempt!!! Just click on the button where it says 'show formulae'. You don't actually need to print out the documents, but you need to save it and upload your file/workbook onto the server when complete.0
-
Congratulations on passing Cash Management cazalino~ An investment in knowledge always pays the best interest ~Benjamin Franklin0
-
Erm, probably not the best idea to post that on the AAT forums, you (and your invigilator) could get in a bit of bother! It's still an exam with a time limit, just because there's not a computer enforcing it doesn't mean you can ignore it...I am of course assuming that it is a time LIMIT rather than a guide to how long it SHOULD take.0
-
Erm, probably not the best idea to post that on the AAT forums, you (and your invigilator) could get in a bit of bother! It's still an exam with a time limit, just because there's not a computer enforcing it doesn't mean you can ignore it...I am of course assuming that it is a time LIMIT rather than a guide to how long it SHOULD take.
Agreed. My understanding is that after the alloted time was up the assessment timed out so that you couldn't upload anything so there'd be nothing to mark. I think the time can be extended by the invigilator but only if there have been technical problems along the way and only to allow the documents to be uploaded.0 -
Hi All,
Hope you don't mind me hijacking this thread but I have my Spreadsheets exam on the 19th July (next week).
I have been told to log onto the AAT website and onto the LearnPlus to make sure my AAT account is activated which I have done - but there is no assessment appearing on the screen?
Can anyone give me a step by step instruction as to how to log on as I don't think I'm doing it right :-(
Thanks for any replies :-)
AATchick x0 -
Having just done mine -
Log in to my AAT, then on the right hand side under online services click LearnPlus. That's it, LearnPlus activated (you don't need to do this if you've used LearnPlus before).
Once the assessment is set up, it will appear on the right hand side of the LearnPlus screen under 'Upcoming assessments' or something like that (the title only appears when there's something to put under it). My assessment was only set up the day before, so no need to panic. If it hasn't appeared a couple of days beforehand you may like to give your provider a ring to double check.0 -
Thanks CeeJaySix, youre a star! :-) xx0
-
I've just sat this exam and it was very similar to the practice test on MyAAT. No VLOOKUPs despite concentrating on them quite a lot. I used all the tips on here so fingers crossed. I am a little worried I missed something as I finished the exam in about an hour. I didn't realise it was so early until I was on the train home. It seems ok compared to the practice paper but I have a long wait to find out if it's good enough. Eeek! My first exam so I'm extra nervous anyway.0
-
It is a very straightforward exam if you have basic Excel knowledge. Pretty much all you need to know is how to format,use headers and footers, conditional formatting, SUM, MAX, MIN, AVERAGE, basic IF statements, basic graphs, and very basic pivot tables. In fact my tutor said don't bother with the textbook if you've used Excel before, do the mock, if you have any problems then look at the relevant chapters. I did, I didn't, the exam took 40mins, okay I haven't got the mark back yet but I'd be truly shocked if it's a fail. For anyone comfortable using Excel this is one in the bag.0
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 12.5K For AAT students
- 322 NEW! Qualifications 2022
- 164 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