Question

Question 7
A data analyst uses a spreadsheet’s Split tool to place each vegetable and fruit into new, separate cells. What is the comma’s function in this scenario?


A

B

1

Vegetables

Fruits

2

Carrot, Celery

Strawberry, Grape

3

Broccoli, Cauliflower, Spinach

Coconut, Banana, Orange

4

Zucchini

Pear, Blackberry




Substring



Delimiter



String



Duplicate

Answer 1

Delimiter — the comma is the separator that tells the Split tool where to break the text into separate cells.