Excel questions.pdf - HOW TO ANSWER AN EXCEL QUESTION Write down the structure of the Excel functions you must know out of your head Example

Excel questions.pdf - HOW TO ANSWER AN EXCEL QUESTION Write...

This preview shows page 1 - 5 out of 11 pages.

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
Image of page 1
EXCEL QUESTION 1
Image of page 2