AIN2601 MOCK EXAM 206

QUICK NOTE :
SOME QUESTIONS CAN HAVE MULTIPLE VARIATIONS OF THE ANSWER
THIS IS A AUTOMATICALLY MARKED MOCK EXAM, AND ONLY ONE CAN BE AUTOMARKED CORRECT
DO NOT WORRY – WHEN YOU GET THE RESULT, CHECK TO SEE IF YOUR ANSWER IS IN THE LIST OF CORRECT ANSWERS UNISA WOULD STILL ACCEPT

• Spreadsheets Part 02 : 22 Marks

– The following formula structures will come in handy:

• Payment : =PMT(rate,nper,pv,fv,type)
• Future Value : =FV(rate,nper,pmt,pv,type)
• Present Value : =PV(rate,nper,pmt,fv,type)
• Vlookup : =VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)