Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Safe-T-NET HR Data Employee ID Employee Name Job Title Office Start Date Years Service Super Annual Salary 1002 James Mason Project Manager Sydney 13/6/2015 6.9
| Safe-T-NET HR Data | ||||||||
| Employee ID | Employee Name | Job Title | Office | Start Date | Years Service | Super | Annual Salary | |
| 1002 | James Mason | Project Manager | Sydney | 13/6/2015 | 6.9 | 11% | $ 148,000.00 | |
| 1003 | Lemin Lu | Senior Engineer | Melbourne | 1/7/2015 | 6.8 | 9% | $ 110,000.00 | |
| 1004 | Sam Viney | Sales Engineer | 17/9/2015 | 6.6 | 9% | $ 123,000.00 | ||
| 1005 | Cynthia Chang | Project Manager | Sydney | 10/1/2018 | 4.3 | 11% | $ 142,000.00 | |
| 1006 | Divika Kapoor | Sales Engineer | Melbourne | 25/1/2018 | 4.3 | 9% | $ 121,000.00 | |
| 1007 | Bin Wang | Engineer | Sydney | 15/2/2018 | 4.2 | 9% | $ 98,000.00 | |
| 1008 | Andy Forbes | Project Manager | Melbourne | 21/8/2019 | 2.7 | 11% | $ 140,000.00 | |
| 1009 | Jordan Riddle | Sales Engineer | Sydney | 13/3/2020 | 2.1 | 9% | $ 92,000.00 | |
| Employee: | Cynthia Chang | 1005 | ||||||
| 1 | How many rows in an excel worksheet? | |||||||
| A | Infinite | FALSE | ||||||
| B | 1048576 | TRUE | ||||||
| C | 1024 | FALSE | ||||||
| D | 16384 | FALSE | ||||||
| 2 | Which of the following is a relative cell reference? | |||||||
| A | $B3 | FALSE | ||||||
| B | B$3 | FALSE | ||||||
| C | $B$3 | FALSE | ||||||
| D | B3 | TRUE | ||||||
| 3 | Which Excel formatting option has been applied to the salary data? | |||||||
| A | General | FALSE | ||||||
| B | Currency | FALSE | ||||||
| C | Accounting | TRUE | ||||||
| D | Number | FALSE | ||||||
| 4 | The formula =COUNT(E4:E11) will return | |||||||
| A | An error | FALSE | ||||||
| B | 7 | FALSE | ||||||
| C | 8 | FALSE | ||||||
| D | 0 | TRUE | ||||||
| 5 | Which of the following would calculate the average salary over 100000 | |||||||
| A | =AVERAGEIFS(I4:I11,">100000") | FALSE | ||||||
| B | =AVERAGEIFS(I4:I11,>100000) | FALSE | ||||||
| C | =AVERAGEIFS(I4:I11)>100000 | FALSE | ||||||
| D | =AVERAGEIFS(I4:I11)>"100000" | FALSE | ||||||
| 6 | Which formula when entered in G4 and copied down will correctly calculate Years Service for all staff | |||||||
| A | =(I1-$F$4)/365.25 | FALSE | ||||||
| B | =($I$1-F4/365.25) | FALSE | ||||||
| C | =$I$1-($F$4/365.25) | FALSE | ||||||
| D | =($I$1-F4)/365.25 | FALSE | ||||||
| 7 | The formula =VLOOKUP(D13,B3:I11,1,FALSE) will return an error, why? | |||||||
| A | Because an absolute cell reference has not been used | FALSE | ||||||
| B | Because the lookup value is to the right of the value you wish to return | FALSE | ||||||
| C | Because it is not an exact match | FALSE | ||||||
| D | Because it is not a range lookup | FALSE | ||||||
| 8 | To find the total salary of people in the Sydney office I should use which function? | |||||||
| A | SUMIFS | TRUE | ||||||
| B | SUM | FALSE | ||||||
| C | VLOOKUP | FALSE | ||||||
| D | COUNTIFS | FALSE | ||||||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started