IF STATEMENTS

What do all excel formulas start with?

What formula would be used to find the item that cost the most in a list of products?

• =MAX

• =MIN

• =COUNT

• =AVERAGE

What formula would be used to find the person who gets paid the lowest in a list of wages?

(a)  

The text on the key of the keyboard using to highlight 2 ranges of information that are not beside each other when creating a chart:

(a)  

Which is the correct formula to calculate the profit/ loss in this example?

• =B5*C5

• =B5+C5

• =B5-C5

• =SUM(B5:C5)

Draw the symbol which represents MORE THAN

What formula should be used in cell E5 to determine if they have made a PROFIT or LOSS?

• =AVERAGE

• =SUM

• =C5-D5

• =IF

Read the formula carefully - will this give the correct answer?

• Yes

• No

If the pupil average is >50% they are ON TRACK, if not they are NOT ON TRACK. Which should be displayed in the VALUE IF TRUE option?

• ON TRACK

• NOT ON TRACK

Draw the symbol for less than