2.1 - Spreadsheet Analytics

Question 1

Why are spreadsheets important in data analysis?

Answer 1

Spreadsheets let you organize, calculate, visualize, and explore data quickly without coding.

Question 2

What are common spreadsheet applications used by data analysts?

Answer 2

Microsoft Excel and Google Sheets.

Question 3

Name three key features of spreadsheets for analysis.

Answer 3

Formulas & functions, tables, charts/visualizations

Question 4

A ______ is a collection of rows and columns in a spreadsheet.

Answer 4

Table / worksheet

Question 5

A ______ in a spreadsheet is a single cell or range of cells that store data or formulas.

Answer 5

Field / cell

Question 6

Which of these is a formula in a spreadsheet?
A) SUM(A1:A10)
B) Table
C) Chart
D) Filter

Answer 6

A) SUM(A1:A10)

Question 7

Which feature would you use to quickly see a visual summary of data trends?
A) Pivot Table
B) Conditional Formatting
C) Chart / Graph
D) Sorting

Answer 7

C) Chart / Graph

Question 8

What is a pivot table used for?

Answer 8

To summarize, aggregate, and analyze data dynamically.

Question 9

Give one example of using a formula in spreadsheets.

Answer 9

Examples: SUM to add totals, AVERAGE to find mean, IF to check conditions.

Question 10

Highlighting cells that meet certain conditions automatically is called ______.

Answer 10

Conditional formatting

Question 11

Why is organizing data into tables helpful?

Answer 11

Makes data easier to read, analyze, and reference in formulas or charts.

Question 12

Name one best practice for spreadsheet analysis.

Answer 12

Examples: label rows/columns clearly, avoid merged cells in tables, document formulas, check for errors.