Help plz! Can't figure out wording of this Excel question...
dahlia
Registered Posts: 24
Hi all, appreciate if anyone could help.
Question is from AAT's level 3 synoptic sample assessment 1 (AQ2016) task 2.2 (c):
Put an IF statement in F18 that will show 'Balanced' if the column totals balance, and 'Check' if they do not.
Ring any bells? Answer provided by AAT doesn't show the formula, just the word 'Balanced' in the cell, so I just could not figure out what it's meant by if the column totals balance...
What column? What totals? Balance with what? (I'm completely confused!)
Grateful if anyone could offer some help/pointers. Thanks!
Question is from AAT's level 3 synoptic sample assessment 1 (AQ2016) task 2.2 (c):
Put an IF statement in F18 that will show 'Balanced' if the column totals balance, and 'Check' if they do not.
Ring any bells? Answer provided by AAT doesn't show the formula, just the word 'Balanced' in the cell, so I just could not figure out what it's meant by if the column totals balance...
What column? What totals? Balance with what? (I'm completely confused!)
Grateful if anyone could offer some help/pointers. Thanks!
0
Best Answers

His concern is that none of the columns will balance as 1 column is original budget, 1 column is flexed budget, 1 column is actual results and 1 column is variance  none of which will have the same values.
Reading the question it's ambiguous in what it asks but it does state if the column totals balance so presumably flexed budget + variance = actual would be your parameters of the formula?5 
Sorry for answering a question you didnt ask! Having checked it I believe it could be the total of the variance in 'operating profit' i.e £16,200 is the same as the sum of the remaining variances, which it is, hence 'balanced'.5

Answers

For example, if the sum of column A is the same as the sum of column B then cell F18 should state the word 'balanced' if they do not match then F18 should state the word 'check'. The formula should be =IF(SUM(A3:A10)=SUM(B3:B10),"balanced","check") OR you can have a SUM total cell at the bottom of column A & B (i.e in Cells A11&B11) then the forumla would be =IF(A11=B11,"balanced","check")0

Thank you, both, for your helpful replies!
The wording is certainly ambiguous, which allow for both of your interpretations, I think.
It does say "column totals" plural so @Irrorate's suggestion makes a lot of sense.
On the other hand, it follows on and references column F, so it could just be what @thefuture says.
Arrrrr... pulling my hair out atm just started sample assessment 2, is it just my weary brain/eyes or there are actually errors in the Excel script (found a few already which is uncharacteristic of AAT's normally high standards)?
Anyway, thanks to all!0 
Got it! Thanks for the much needed clarification @AlisonSwanson
0 
I remember this awful torment ( darling I remember the exam as tho it were yesterday!)
The sum of the two smaller numbers should equal the larger number
IF clause ( 'balanced') and fall thro  false then 'check'
the actual syntax is as above and I think I finally got it but my numbers  didnt add up!
and yes the whole exam was like that  I had made a mess of q1 and looked on q2  your bit and thought  "another bl++dy question I cant understand ......"
has anyone had the patronising email from AAT on synoptic ?
"synoptic is a very long word, and it means "final exam at end of the year"and then went on "this year it wasnt us  you are all too thick to pass"
and then it continues  "Learn the Logic of Excel"
well what I say is  the logic of Excel is that Bill Gates makes an awful lot of money
and really I dont think this is suitable content for an accounting exam  even if AAT is dedicated to help him
[ Logic on the basis of Boolos & Jeffrey 5th ed I could understand  or logic of Peano's axioms  but logic of Excel oh pleeeeeease !  sorry got a bit technical there]
no result yet  clearly I am retake equivocal
and level 4  no not more of the same thank you  I have had enough.....
1
Categories
 All Categories
 1.2K Books to buy and sell
 2.3K General discussion
 18.9K For AAT students
 234 NEW! Qualifications 2022
 133 General Qualifications 2022 discussion
 7 AAT Level 2 Certificate in Accounting
 31 AAT Level 3 Diploma in Accounting
 55 AAT Level 4 Diploma in Professional Accounting
 8.9K For accounting professionals
 23 coronavirus (Covid19)
 272 VAT
 91 Software
 272 Tax
 135 Bookkeeping
 7.3K General accounting discussion
 201 AAT member discussion (AATQB, MAAT, FMAAT and AAT Licensed Accountants and Bookkeepers)
 3.8K For everyone
 39 AAT news and announcements
 352 Feedback for AAT
 2.8K Chat and offtopic discussion
 586 Job postings
 17 Who can benefit from AAT?
 36 Where can AAT take me?
 44 Getting started with AAT
 26 Finding an AAT training provider
 47 Distance learning and other ways to study AAT
 25 Apprenticeships
 65 AAT membership