MIS Test Paper

	A	B	C	D	E	F	G
1	Sr no	Emp_ID	Name	Department	Join_Date	Salary	Region
2	1	101	Ramesh	Sales	2019-01-10	40000	North
3	2	102	Sita	HR	2020-03-15	45000	South
4	3	103	Amit	IT	2018-07-22	60000	East
5	4	104	Priya	Marketing	2021-09-30	48000	West
6	5	105	Karan	Finance	2022-11-18	55000	North
7	6	106	Rutvik	Sales	2019-02-19	15000	East
8
9
10	Provide serial number here by formula					Use Formula Here
11		Use VLOOKUP to find Salary of Emp_ID 103.
12		Use XLOOKUP to find Department of Name "Sita".
13		Use HLOOKUP to get Region from transposed data.
14		Use IFERROR to handle any missing Emp_ID lookups.
15		Use ARRAYFORMULA to calculate 10% bonus for all employees.
16		Use QUERY to find employees who joined after 2020.
17		Create a Pivot Table to show average salary by Department.
18		Provide serial number with formula
19
20		Convert the amount in Word by using Formula
21		₹25,000
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100