Which describes the nonadjacent range shown in the figure above?
A) A6:A9;C6:C9
B) A6:A9-C6:C9
C) A6:C9
D) A6;C9

Name: Which describes the nonadjacent range shown in the figure above? A) A6:A9;C6:C9 B) A6:A9-C6:C9 C) A6:C9 D) A6;C9
Brand: Quizplus
Rating: 4.8 (45 reviews)

Question

Quizplus · Accepted Answer

A nonadjacent range in Excel is specified by separating the different ranges with a semicolon. "A6:A9;C6:C9" indicates two separate ranges, A6 to A9 and C6 to C9, which are nonadjacent.

Which Describes the Nonadjacent Range Shown in the Figure Above