[PSSSB Firemen, 2023]
1. In MS-Excel, which one of following denote a range from cell A1 through B5?
A1-B5
A1:B5
A1toB5
A1$B5
Correct Answer :
A1:B5
In MS Excel, a range of cells is denoted by the colon (:) symbol between the starting and ending cells. Thus, A1:B5 represents all cells in the rectangular block from cell A1 to cell B5, including all the cells in between.