How did you go?

[Etherlite]

Anyway the way I see this forum is a collection of highly motivated who really care about how they went in the subject, using a "nerdy" forum to discuss it which indicates we are all pretty IT savvy.

Based on that and the similarities in our results, despite a few people getting some right here, some wrong there, I would say we are all heading for the A, A+ region of marks for the exam, almost without a doubt.

Unless you really f***** the exam up, I'm going to say we all did well in this year's exam.

Well done everyone.

[Potter]

Huh? Income was like $2550 and expenses were like $2350 =S
you probably added them wrong?

I put just Hooray as well, no quotations as they are asking what would appear on the cell exactly. and quotations wouldn't appear.

Nah, but the screen shot of the spreadsheet didn't have any values in the reference cells.
The question was referring back to the screen shot, not from manual calculations if you get what I mean..
That's my interpretation of the question.. Is that shitty logic or what..?

[majo]

Anyway the way I see this forum is a collection of highly motivated who really care about how they went in the subject, using a "nerdy" forum to discuss it which indicates we are all pretty IT savvy.

Based on that and the similarities in our results, despite a few people getting some right here, some wrong there, I would say we are all heading for the A, A+ region of marks for the exam, almost without a doubt.

Unless you really f***** the exam up, I'm going to say we all did well in this year's exam.

Well done everyone.

well done wooo!! haha

i believe that if you went out of ur way to even be apart of this forum, it shows that you truely do care about your score and you did your best!

best of luck to everyone for annymore upcoming exams!

[ks04]

Huh? Income was like $2550 and expenses were like $2350 =S
you probably added them wrong?

I put just Hooray as well, no quotations as they are asking what would appear on the cell exactly. and quotations wouldn't appear.

Nah, but the screen shot of the spreadsheet didn't have any values in the reference cells.
The question was referring back to the screen shot, not from manual calculations if you get what I mean..
That's my interpretation of the question.. Is that shitty logic or what..?

The way i did it was that even if it wasn't using the manual calculations we had to do it still wouldnt display " ", it would just display nothing.  Ruling out the impossiable answers just left HOORAY... as far as my logic could desipher :S

[Vadnal]

Anyway the way I see this forum is a collection of highly motivated who really care about how they went in the subject, using a "nerdy" forum to discuss it which indicates we are all pretty IT savvy.

Based on that and the similarities in our results, despite a few people getting some right here, some wrong there, I would say we are all heading for the A, A+ region of marks for the exam, almost without a doubt.

Unless you really f***** the exam up, I'm going to say we all did well in this year's exam.

Well done everyone.

That's the spirit, good encouragement and I also agree.
All the best on your results for other exams guys.

[codykm]

Also, how can you make a query an alert? For the podcasts Q.
I automatically thought an IF statement. But it said query?
Was a bit confused so I made up a line of crap.

i made up an if statement also haha

same.

me too

I put:
Stock <= Reorder Stock, "Reorder Stock"

Which i think is probably wrong, but my logic was: if stock is less than or equal to reorder stock, then display message 'Reorder Stock'
I didn't use an IF statement as it said query :S

And also, its HOORAY with no quotations

[Potter]

This is the same situation isn't it..?

[codykm]

(Image removed from quote.)

This is the same situation isn't it..?

If you're talking to me, no, because thats in a spreadsheet using spreadsheet formula, it was a database using queries

[majo]

(Image removed from quote.)

This is the same situation isn't it..?

its what i did so i hope so lmao

cant databases use if statements?

[ks04]

I also put an if statement, however, i'm pretty sure that would be wrong as it's just a queiry.... hmm...
there were a few questions which weren't too clear i thought this year!
Does anyone know how long it takes for Mark Kelly to post his answers normally?

[codykm]

Don't know, I think you might be able to.. so the IF statements probably right.. lol

[Potter]

(Image removed from quote.)

This is the same situation isn't it..?

its what i did so i hope so lmao

cant databases use if statements?

I don't think they can..
Sorry, I'm referring back to that Hooray question.  

[ks04]

(Image removed from quote.)

This is the same situation isn't it..?

its what i did so i hope so lmao

cant databases use if statements?

I don't think they can..
Sorry, I'm referring back to that Hooray question.  

The else argument (after the second comma) was empty, otherwise, yes.

[Vadnal]

You guys put the $'s in for the VLOOKUP as well?

[ks04]

on a side note... did anyone manage to get a copy of the exam they can scan and post?