1 Highlight all the dates after October 06, 2018: Provide your answer in a new worksheet with screenshots
ts of how you do the activity.
In taking a screenshot include all the screen with time and date as below.
Date
3/11/2018
11/5/2019
3/12/2018
26/9/2019
12/4/2018
3/1/2019
6/5/2018
21/6/2019
24/7/2019
22/4/2018
8/6/2019
17/10/2017
28/1/2018
19/3/2019
18/8/2019
19/10/2017
2 Highlight all grades above average:
Grades
59
56
75
99
86
72
89
67
76
80
71
56
63
100
100
3 Highlight all the duplicate names:
John
Danny
Dean
Donny
Jake
Jill
Hannah
Jake
John
Danny
Dean
4 Highlight all cells greater than the MEDIAN of the range:
79
59
60
78
87
88
71
78
99
54
57
95
55
91
76
79
w you do the activity.
as below.
1 Highlight all the dates after October 06, 2018: Provide your answer in a new worksheet with screenshots of how you do the activity.
In taking a screenshot include all the screen with time and date as below.
Date
3/11/2018
11/5/2019
3/12/2018
26/9/2019
12/4/2018
3/1/2019
6/5/2018
21/6/2019
24/7/2019
22/4/2018
8/6/2019
17/10/2017
28/1/2018
19/3/2019
18/8/2019
19/10/2017
2 Highlight all grades above average:
Grades
59
56
75
99
86
72
89
67
76
80
71
56
63
100
100
3 Highlight all the duplicate names:
John
Danny
Dean
Donny
Jake
Jill
Hannah
Jake
John
Danny
Dean
4 Highlight all cells greater than the MEDIAN of the range:
79
59
60
78
87
88
71
78
99
54
57
95
55
91
76
79
w you do the activity.
as below.
Using Index&Match, find the ID Number of David
ID Number Name
9584423 Yoav
5034521 Bob
9543669 Rami
9995553 David
8595323 Lev
9359305 Frank
Name: David
Answer: 9995553 <- Insert formula here
