Note: if only one of two or more criteria must be met, use =OR 1 There are xx questions on this worksheet; please attempt them all. 2 Sample Question 3 (x marks) 3 Use logical functions in cell F5, such that the Budget expenses $2,200 4 formula can be copied down to cells F6 to Name Sales Target Expenses Surplus 5 F10, to display the difference between each John $45,000 $40,000 $1,900 6 employee's sales and their target ONLY IF Liam $36,000 $40,000 $2,700 7 their sales exceed their target AND their Reece $61,000 $50,000 $3,800 8 expenses were less than the budget in cell Zac $32,000 $35,000 $1,500 9 E3). If BOTH criteria are not met, leave the Simon $29,000 $25,000 $1,800 10 cell blank. Ryan $48,000 $2,000 11 12 Sample Question 4 (x marks) 13 How much tax would you pay on any positive Income up Tax amount 14 income in cell C14, based upon the tax scale Taxable income $95,000 to plus 15 in the table to the right? 16 The tax table has been named "Taxscale" for $18,200 17 ease of function entries. $37,000 $3,572 Tax payable $80,000 $17,547 $180,000 $54,547 $0 0% $0 19.0% 32.5% 37.0% 45.0% Sample Question 5 (x marks) 22 The table to the right shows exchange rates 23 of 5 foreign currencies with the Australian 24 Dollar. The rates are the average during the 25 month. 26 Limit the entries in cell C32 to the five 27 currencies. 28 Work out in cell C33 which was the best 31 month to buy that currency (i.e. the highest 32 rate). 33 Show in cell C34 which was the best month 34 to acquire that currency. Month Oct-13 Nov-13 Dec-13 Jan-14 Feb-14 Mar-14 Foreign Currency UKUSEUR HKD 0.58 0.94 0.71 6.20 0.57 0.92 0.73 6.15 0.55 0.92 0.72 6.25 0.90 0.70 6.30 0.55 0.91 0.69 0.92 0.71 6.25 JPY 112.00 115.00 105.00 108.00 112.00 118.00 0.54 6.20 0.56 Foreign currency Best rate? Best month? Note: if only one of two or more criteria must be met, use =OR 1 There are xx questions on this worksheet; please attempt them all. 2 Sample Question 3 (x marks) 3 Use logical functions in cell F5, such that the Budget expenses $2,200 4 formula can be copied down to cells F6 to Name Sales Target Expenses Surplus 5 F10, to display the difference between each John $45,000 $40,000 $1,900 6 employee's sales and their target ONLY IF Liam $36,000 $40,000 $2,700 7 their sales exceed their target AND their Reece $61,000 $50,000 $3,800 8 expenses were less than the budget in cell Zac $32,000 $35,000 $1,500 9 E3). If BOTH criteria are not met, leave the Simon $29,000 $25,000 $1,800 10 cell blank. Ryan $48,000 $2,000 11 12 Sample Question 4 (x marks) 13 How much tax would you pay on any positive Income up Tax amount 14 income in cell C14, based upon the tax scale Taxable income $95,000 to plus 15 in the table to the right? 16 The tax table has been named "Taxscale" for $18,200 17 ease of function entries. $37,000 $3,572 Tax payable $80,000 $17,547 $180,000 $54,547 $0 0% $0 19.0% 32.5% 37.0% 45.0% Sample Question 5 (x marks) 22 The table to the right shows exchange rates 23 of 5 foreign currencies with the Australian 24 Dollar. The rates are the average during the 25 month. 26 Limit the entries in cell C32 to the five 27 currencies. 28 Work out in cell C33 which was the best 31 month to buy that currency (i.e. the highest 32 rate). 33 Show in cell C34 which was the best month 34 to acquire that currency. Month Oct-13 Nov-13 Dec-13 Jan-14 Feb-14 Mar-14 Foreign Currency UKUSEUR HKD 0.58 0.94 0.71 6.20 0.57 0.92 0.73 6.15 0.55 0.92 0.72 6.25 0.90 0.70 6.30 0.55 0.91 0.69 0.92 0.71 6.25 JPY 112.00 115.00 105.00 108.00 112.00 118.00 0.54 6.20 0.56 Foreign currency Best rate? Best month
