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