Excel Masterclass Part 3

Identify which of the following is the valid syntax for the Excel SUMIF function:

• =SUMIF(range,criteria,[sum_range])

• =SUMIF(range,[value_if_true],[value_if_false])

• =SUMIF([range],[criteria],sum_range)

• =SUMIF(criteria, range,[sum_range])

Name one way that I can use to discover whether Excel has an inbuilt function for what I want to do?

• Type 'Help' in the active cell

• Access Help via the backstage

• Use the search bar at the top of Excel window

• Use the name manager to locate the help file within Excel

As well as adding cell values together AutoSum can also:

• Calculate the maximum value in the range

• Average cell values

• Count Numbers

• All of the above

Which function will give the correct number of quantities (i.e. 4 - excluding 'None')

• COUNT(A2:A6)

• COUNTA(A2:A6)

• COUNTIF(B2:B6)

• COUNT(B2:B6)

When looking at the list of arguments for a function the square brackets around one or more arguments represent:

• The argument must be populated

• The argument is optional