[Revenue Patwari Pre Aug, 2021]
1. Which sign is used to specify a cell range?
: (colon)
/ (slash)
* (asterisk)
- (hyphen)
Correct Answer :
: (colon)
In Excel, the colon (:) is used to specify a range of cells. For example, A1:A10
refers to all cells from A1 to A10. It is commonly used in functions like SUM(A1:A10)
to indicate the range of cells to be processed.