Question

course - ictv3 spreadsheet essentials
andrew needs to create a table using the data shown. which cell range should he select in order to create a table that includes all of the data in the spreadsheet?
figure: a
a a2:d8
b a1:d1
c a1:d8
d a2:d2

Explanation:

Step1: Identify data range

The data includes headers (row 2: ID, First Name, City, State) and data rows from row 3 to row 8. Columns are A to D. So the range should start at A2 (first header cell) and end at D8 (last data cell).

Step2: Evaluate options

• Option A: A2:D8 includes headers (row 2) and all data rows (3 - 8) in columns A - D.
• Option B: A1:D1 is only the merged title row, not the data table.
• Option C: A1:D8 includes the merged title row (A1:D1) which is not part of the data table structure (headers start at row 2).
• Option D: A2:D2 is only the header row, no data.

Answer:

A. A2:D8