Excel Assessment

Which of the following best defines data analysis?

• Organizing data in folders

• Examining data to extract meaningful insights

• Using formulas to calculate totals

• Collecting data from various sources

What is the primary objective of data cleaning in the analysis process?

• Remove duplicate files from the computer

• Make the data consistent and error-free

• Add new columns to the dataset

• Change all data types to text

Which step in data analysis involves interpreting results to draw conclusions?

• Data collection

• Data visualization

• Data cleaning

• Data interpretation

A manager asks you to predict future sales based on past trends. What type of data analysis is this?

• Descriptive analysis

• Predictive analysis

• Diagnostic analysis

• Prescriptive analysis

During diagnostic analysis, what might you do to understand a drop in sales?

• Ignore outliers

• Examine customer feedback trends

• Create a summary table of sales totals

• Change data types to match formats

Which of these is not a type of data analytics?

• Predictive

• Prescriptive

• Perspective

• Diagnostic

You receive a dataset with missing entries in critical columns. What is the best first step?

• Delete rows with missing values

• Replace missing values with an average or median

• Flag missing entries for further review

• Ignore the missing entries

How do you remove unnecessary blank rows in Excel quickly?

• Filter the data to exclude blanks

• Use the Delete Duplicates feature

• Sort the data and delete blank rows

• Highlight blanks and press Delete

Which function is most suitable to correct inconsistent capitalization in names?

• =UPPER()

• =PROPER()

• =LOWER()

• =TRIM()

If a dataset contains dates stored as text, how can you convert them into proper date format?

• Use the TRIM function

• Apply a Date format in the Format Cells menu

• Manually re-enter the dates

• Use Conditional Formatting