Question: 2
(Choose 1 answer)
Pepsi observes errors in data alignment after applying filters. What is the likely cause, and how can it be fixed?
A. Header rows were not locked during filtering; reapply filters correctly
B. Data was exported without a consistent format; re-export in CSV
C. Sorting occurred before data validation; undo sorting
D. Columns were not formatted; apply conditional formatting
