Excel (spreadsheet program) formulae (1 Viewer)

[Götterfunken]

Does anyone has a list, or would be able to make one, of all the Excel formulae and functions we should know?

I know basic things like =(A1+A2), but beyond that I'm a bit confused. I'd appreciate if anyone knows any good websites or links on the matter as well.

Thanks

(I should add our year 12 teacher knew nothing and in the last week of school, as a result of my complaint to the principal, we received a print off of the entire 'IT' section from the hsc.csu.edu website. It's interesting, and helpful in its own right, but doesn't go into enough detail. Or I’m just missing the ‘excel and you’ section.

 

[d_griffo]

need to know

<b>
if
vlookup
absolute and relative
</b>

maybe need others not sure

but then again in last two years HSC papers hasnt us to write any specific codes as such but wont hurt to know what they are, just in case

 

[Casmira]

Min, max, ADD, average etc.. make sure you know them

 

[Götterfunken]

it's the 'etc' that worries me vaguely.

 

[Casmira]

they arent going to expect you t ogo to like stndv( standard deviation) but will expect, these all apply to functions of FUNCTION(Cell:range) (eg. SUM(D18)

SUM can be used for adding up a range of fields
SUB for minusing fields
PRODUCT times shit

Logical functions;
Function Description
AND Returns TRUE if all of its arguments are TRUE
FALSE Returns the logical value FALSE
IF Specifies a logical test to perform
NOT Reverses the logic of its argument
OR Returns TRUE if any argument is TRUE
TRUE Returns the logical value TRUE

Ill be damned if they exceed anything as "advanced" as MIN/MAX