Home For AAT student members AQ 2013 AAT Level 3 (Level 6 in Scotland)
Current updates regarding coronavirus (Covid-19) and the precautions AAT are taking will be continually updated on the below page.

Please check this link for the latest updates:
We hope you are all safe and well and if you need us we will be here. 💚

Excel Test

What happens if you use alternative formulas in the exam? Or do extra formatting. I have been using excel for years, then chose to do AAT. Got lots of habits on excel that i need to nullify. Would you be penalised or not?


  • Adele69Adele69 CambridgeAAT Student Posts: 320
    There are multiple ways to sum a row or column and they would all be valid. It's a year since I did this and I had years of Excel. The main thing is attention to detail, if a subtotal has to be boxed or conditional formatted in another way or tab coloured it has to be the way they describe or you won't get all the marks.
  • JoshJ1992JoshJ1992 Registered Posts: 75
    Hi Romili,

    As Adele69 has said, as long as the formulas work and you compile your spreadsheet as asked in the question, you should be fine. If they specifically ask you to fill a cell with a yellow background, you need to do this in order to achieve marks.

    Hope that helps
Sign In or Register to comment.