Question

28. In MS-Excel formulas, an adjacent range
is specified by giving the starting and
ending cell addresses separated by a :
(A) Semicolon (:)
(B) Comma (,)
(C) Full stop(.)
(D) Colon(:)​

Answer 1

Answer:

(B) Comma (,)

Explanation:

A range of cells is described in terms of the top left cell and the bottom right cell references separated by a colon. Comma ( , ) - This is used to define non adjacent cells (e.g. "A1", "B2"). The comma is also known as the union operator.

Answer 2

Answer:

The correct answer is d. Colon