Question

benjamin needs to create a table with employee information regarding only bryan, ashley, and andrew using the data shown. which cell range should he select in order to create a table that includes the required data located in this spreadsheet? figure a: employee information in a spreadsheet. a a1:a8 b a1:d8 c a4:d6 d a4:a6

Explanation:

Step1: Identify target employees

Bryan (row4), Ashley (row5), Andrew (row6) are required.

Step2: Check columns

Data spans columns A (ID) to D (State).

Step3: Determine cell range

Rows 4-6 and columns A-D → A4:D6.

Answer:

C. A4:D6