Why are spreadsheets used in data analysis?

• A. They require heavy coding
• B. They allow flexibility in analyzing data sets, comparing current data with past campaigns, sorting, and filtering metrics
• C. They are used only for writing reports
• D. They are expensive

Answer: (B)

Spreadsheets enable flexible data analysis by providing a grid of cells where you can quickly organize, clean, and manipulate data using built-in functions and features. This flexibility lets you explore datasets from different angles without writing code. You can sort data to rank campaigns, filter to focus on a specific channel or date range, and compare current results with past campaigns side by side to spot trends or shifts in performance. You can compute key metrics like conversion rate, ROI, or cost per acquisition with simple formulas, and pivot tables help you summarize large sets of data into meaningful averages and totals. This combination of sorting, filtering, and easy cross-period comparisons makes spreadsheets a versatile tool for exploratory analysis, quick what-if scenarios, and presenting findings in a clear, actionable way. The other options imply heavy coding, restricted use to writing reports, or high costs, which don’t reflect how spreadsheets are typically used for flexible, fast data analysis.