Sr.
No Description Formula
1 Serial Number 1
2 Filter Control + Shift + L
3 Select an entire row Shift+Space
4 Select an entire column Ctrl+Space
5 For : @* ":"
6 For Auto sequence no SEQUENCE(COUNTA(B:B)-1)
7
8
9
10
11
12
Auto-highlight row and column of selected cell with VBA
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
Application.ScreenUpdating = False
'Clear the color of all cells
Cells.Interior.ColorIndex = 0
With Target
'Highlight row and column of the selected cell
.EntireRow.Interior.ColorIndex = 38
.EntireColumn.Interior.ColorIndex = 24
End With
Application.ScreenUpdating = True
End Sub
Date of Birth 8/10/1994
Current Date 10/10/2023
Years 29
Months 2
Days 0
In Words 29 Years 2 Months 0 Days
Applying IF Function Combination of IF & AND Functio
Subject Marks Pass/Fail Students Subject 1
Maths 82 Pass Justin 53
Chemistry 75 Pass Mike 48
Physics 58 Fail Andrew 27
Economics 67 Fail Carry 78
Geography 72 Pass Josh 72
ation of IF & AND Functions Applying COUNTIF Function
Subject 2 Pass/Fail Students Maths Cemistry
46 Pass Justin 72 86
55 Pass Mike 85 68
63 Fail Andrew 73 84
32 Fail Carry 51 74
38 Pass Josh 72 78
OUNTIF Function
Physics Pass/Fail
92 Pass
61 Fail
62 Pass
64 Fail
88 Pass
Activity Start Date Number of Days
Get the Equipments 2/25/2015 15
Build the Arms Cover 2/28/2015 3 Gantt
Assemble the Armour 2/28/2015 6
Design the Chest Piece 3/4/2015 3 Get the Equipments
Prepare the Neck Piece 3/7/2015 2 Build the Arms Cover
Design the Mask 3/10/2015 3 Assemble the Armour
Get the Cape & Gloves 3/13/2015 2
Design the Chest Piece
Make the Boots 3/15/2015 3
Stich the Suit 3/16/2015 6 Prepare the Neck Piece
Attach the Belt 3/22/2015 1 Design the Mask
Test for Survival 3/24/2015 7 Get the Cape & Gloves
Make the Boots
Stich the Suit
Attach the Belt
Test for Survival
42060 42065
Gantt Chart - Building a BatSuit
Get the Equipments
uild the Arms Cover
semble the Armour
ign the Chest Piece
pare the Neck Piece
Design the Mask
the Cape & Gloves
Make the Boots
Stich the Suit
Attach the Belt
Test for Survival
42060 42065 42070 42075 42080 42085 42090
