Reference Operator
A absolute reference is created in Excel by using $ sign
e.g. G$7 (Absolute Row and Column)
Range Operator
A range of cells can be specified in Excel using : sign
e.g. B4:B8
Intersection Operator
Space can be used to perform Intersection Operation (Values present in both)
Both the selection should belong to the same list
e.g. =SUM(B7:D7 C6:C8)