HOW TO ANSWER AN EXCEL QUESTION
Write down the structure of the Excel functions you must know out of your head
Example
=IF(logical_test,value_if_true,value_if_false)
READ all the provided information and underline/highlight the important information
READ through the spreadsheet (left to right & top to bottom)
If an amount or a percentage(%) is given in a cell you MUST use that cell reference
to use it in your formula/function
Writing a formula: Write the formula using amounts and replace the amounts with
the applicable cell reference
Negative marks in exam
–
Refer to MO001 document at the end of Study Unit 5
Have a look at the bigger picture
Examples of exam questions

EXCEL
QUESTION 1