MCQs

1. Why is data type conversion important in sales analysis?
a. To reduce dataset size
b. To improve visualization colors
c. To enable accurate calculations and aggregation
d. To remove duplicates

Answer: c - To enable accurate calculations and aggregation
Correct data types are required for calculations, grouping, and time-based analysis.

2. Why are line charts used for revenue trends over time?
a. To compare categories
b. To display distributions
c. To show changes across time
d. To remove missing values

Answer: c - To show changes across time
Line charts clearly highlight how revenue evolves over time.

3. What is the main purpose of grouping data in this project?
a. To increase rows
b. To summarize sales by category or time
c. To clean missing values
d. To normalize data

Answer: b - To summarize sales by category or time
Grouping allows meaningful aggregation such as total revenue by month or product.

4. What insight does customer-level analysis provide?
a. File size optimization
b. Dataset encoding
c. Identification of high-revenue customers
d. Chart formatting

Answer: c - Identification of high-revenue customers
It helps businesses understand which customers drive the most revenue.