In Q15: Use the appropriate function that will return TRUE if the Job Title is Manager and
Question:
In Q15:
Use the appropriate function that will return TRUE if the Job Title is Manager and the Region is RG2 and the Department is 1211 and the Salary is 70,000 or more.
In cell Q10 use the appropriate function to calculate how many are TRUE.
In R15:
Use the appropriate function that will return TRUE if the Job Title is Manager or the Salary is 100,000 or more or the Gender is male or the Rating is 2. Copy the function down to the other cells in the column.
In cell R10 use the appropriate function to calculate how many are TRUE.
In cell S15:
If the Age is 39, insert the value from cell M2,
If the Age is 59, insert the value from cell M3,
If the Age is 67, insert the value from cell M4,
otherwise insert the value from cell M5.
(Use absolute cell referencing where necessary).
Copy the function down to the other cells.
In S10 use the appropriate function to calculate the total for all employees. Format as comma style 0 decimal.
In cell T15:
Use the appropriate nested functions: If the Region is RG2 OR RG4 AND the Annual Units Sold is less than 17,500 AND the Department is 1202OR 1211, AND the Gender is M, enter Missed Target, otherwise the cell should be blank. Copy the function down to the other cells in the column.
In T10 use the appropriate function to calculate how many employees have Missed Target.
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill