Nick is starting a new Excel course on Data Analysis. What should he do first before analyzing data?

• Collect and clean relevant data
• Create charts immediately
• Ignore missing values
• Delete random data points

A startup company needs help understanding its sales performance. What should they perform first?

• Data cleaning
• Exploratory Data Analysis
• Data entry
• Marketing research

Bananas, a SaaS company, wants to find sales trends. What type of data analysis helps in spotting patterns?

• Descriptive statistics
• Exploratory Data Analysis
• Inferential analysis
• Regression analysis

An analyst begins by checking for missing values and outliers. Which step of EDA is this?

• Preparing the data
• Visualizing data
• Formulating hypotheses
• Calculating the mean

Before doing any analysis, an analyst explores the dataset for patterns. Why is this step important?

• It helps avoid errors and misunderstandings
• It saves storage space
• It reduces file size
• It deletes duplicate data

A dataset has values 5, 10, 15, 20, and 25. What is the mean?

• 15
• 10
• 20
• 12

The sales data of a company shows 100, 200, 300, 400, and 500. What is the range?

• 400
• 500
• 300
• 200

The most common number in a dataset is called the ____.

• Median
• Mode
• Mean
• Range

If the middle number of a sorted dataset is 50, what does this represent?

• Mode
• Mean
• Median
• Average

An analyst observes sales increasing monthly. What step in EDA allows them to create this kind of insight?

• Formulating hypotheses
• Data visualization
• Data cleaning
• Calculating the mean