Question

how will you select a range and non adjacent cell in a sheet​

Answer 1

$\huge \tt \underline \red{ANSWER :-}$

To select a range, select a cell, then with the left mouse button pressed, drag over the other cells. Or use the Shift + arrow keys to select the range. To select non-adjacent cells and cell ranges, hold Ctrl and select the cells.