A new worksheet has items listed in cell range A1 to A20.Which of the following will you type in the Format Object window in the Input Range box to specify the range for the list?
A) "A1:A20"
B) 'A1:A20'
C) A1-A20
D) A1:A20

Question

Quizplus · Accepted Answer

The correct syntax for specifying a range in Excel is to use a colon (:) between the starting and ending cells. Therefore, the correct input range to specify the list in cell range A1 to A20 is "A1:A20".

A New Worksheet Has Items Listed in Cell Range A1