Part 8: Data Analysis Basics Quiz – Introduction to Excel Analysis (20 MCQ)

Correct answer: B. Examining data to find patterns, trends, and insights for decisions

★ Key Takeaway: Data analysis is about understanding what the numbers mean so you can make better decisions.

Explanation: In Excel, analysis means exploring your data to answer questions, such as what changed, what is growing, and where problems exist. Calculations and charts are tools, but the goal is insight and decision-making.

Why other options are incorrect:

• A. Formatting cells to make a sheet look professional – Formatting improves readability, but it does not explain patterns or support decisions by itself.
• C. Writing advanced formulas in every worksheet – Formulas help calculate results, but analysis is the thinking process of interpreting those results.
• D. Creating charts only for presentation – Charts can show insights, but analysis happens before presentation, when you interpret what the data is saying.

Tip: Want to learn data analysis in Excel the right way (with real examples)? A 1-on-1 tutor can guide you step by step. Learn Excel faster with a 1-on-1 tutor on Fiverr →

Correct answer: C. An outlier or anomaly

★ Key Takeaway: An outlier is a value that looks unusually different from the typical pattern.

Explanation: A sudden spike or drop that does not match the overall pattern is often an anomaly. Analysts investigate outliers because they can indicate data errors, special events, or real business issues.

Why other options are incorrect:

• A. A normal seasonal trend – A trend is usually consistent or repeated over time, not a single unusual drop.
• B. A summary statistic – A statistic like average or total summarizes data; it does not describe an unusual point.
• D. A data validation rule – Data validation controls what users can enter, not what patterns you discover in results.

Correct answer: A. Weekend sales are consistently higher than weekday sales, so staffing should increase on weekends

★ Key Takeaway: An insight explains what the data means and often suggests an action.

Explanation: An insight combines a pattern (weekend sales are higher) with an interpretation that supports a decision (adjust staffing). The other options are useful facts, but they do not explain meaning.

Why other options are incorrect:

• B. Total sales last month were 125000 – This is a raw result; it does not explain why it happened or what to do next.
• C. The average order value is 42 – This is a summary measure, but it is not an interpretation or decision-focused conclusion.
• D. There are 480 rows in the dataset – This describes dataset size, not performance or meaning.

Correct answer: D. Make sure the data is clean, consistent, and accurate

★ Key Takeaway: Clean data is the foundation of correct analysis.

Explanation: If the data contains duplicates, missing values, wrong formats, or numbers stored as text, your totals, averages, and comparisons can become misleading. Good analysis starts with trusted input.

Why other options are incorrect:

• A. Create charts immediately to see the picture – Charts based on messy data can look convincing while still being wrong.
• B. Write advanced formulas to speed things up – Formulas do not fix incorrect or inconsistent data; they often spread the problem faster.
• C. Share the workbook to get feedback early – Sharing is useful later, but first you must make sure the data is reliable.

Correct answer: B. Use the median or check outliers because one value is unusually high

★ Key Takeaway: When outliers exist, the median often describes “typical” better than the average.

Explanation: The East value (450) is far higher than the other two, so an average would be pulled upward and may not represent a typical region. Using the median (118, 120, 450) keeps the typical level realistic, and checking the outlier helps you understand why it is different.

Why other options are incorrect:

• A. Use the maximum because it shows the strongest region – The maximum shows the highest value, but it does not represent what is typical.
• C. Use the total because it combines all regions – A total is useful for overall volume, but it hides how most regions are performing.
• D. Use the count because it shows how many regions you have – Count describes how many items exist, not what a typical sale looks like.

Correct answer: C. Units sold per employee

★ Key Takeaway: Normalize data (per person, per day, per store) to compare fairly.

Explanation: Store B sold more units, but it also has many more employees. A per-employee measure shows productivity and creates a fair comparison between different-sized stores.

Why other options are incorrect:

• A. Total units sold only – Totals are influenced by store size and may not reflect efficiency.
• B. The maximum daily sale from each store – A single best day can be misleading and does not represent normal performance.
• D. The number of rows in each store’s data – Row count is about data volume, not performance.

Correct answer: D. Totals can hide important differences and problem areas inside the data

★ Key Takeaway: Grouping and segmentation help you find what totals hide.

Explanation: A total can look healthy while one region is declining or one product is causing losses. Breaking results into categories helps you find where changes are happening.

Why other options are incorrect:

• A. Totals will automatically remove duplicates – Totals do not remove duplicates; duplicates can inflate totals if not handled.
• B. Totals will convert text into numbers – Excel will not automatically convert text numbers just because you total them.
• C. Totals will prevent users from entering wrong data – Preventing wrong data is done with validation rules, not totals.

Correct answer: A. A key metric that helps measure progress toward a goal

★ Key Takeaway: KPIs focus attention on what matters most for performance.

Explanation: A KPI is a number you track because it connects directly to a target, such as monthly profit, conversion rate, or on-time delivery percentage. Good analysis often starts by choosing the right KPIs.

Why other options are incorrect:

• B. A type of Excel chart used for presentations – Charts visualize KPIs, but the KPI is the metric itself, not the chart.
• C. A feature that restricts data entry – Restricting entry is data validation, not KPI tracking.
• D. A worksheet that contains only formulas – A worksheet can contain KPIs, but the term KPI refers to a metric, not a sheet type.

Correct answer: C. Apply a filter so only the selected region is shown

★ Key Takeaway: Filtering hides data from view without removing it.

Explanation: Filters let you focus on one category while keeping the full dataset intact. This is safer than deleting data and makes it easy to switch between regions and compare results.

Why other options are incorrect:

• A. Delete all rows that are not the region you want – Deleting removes data permanently and can destroy your ability to compare later.
• B. Convert the worksheet to a chart and analyze the chart only – A chart is built from data; it does not replace proper filtering and analysis.
• D. Copy the workbook and work on the copied file every time – Copies create version confusion and extra work; filtering is the standard method.

Tip: If filtering and analysis steps feel confusing, guided practice with real datasets helps a lot. Get personalized Excel help from a Fiverr expert →

Correct answer: B. Sales increased by 12 percent compared to last month, mostly driven by the Online channel

★ Key Takeaway: Strong analysis explains change and points to a cause, not just a number.

Explanation: Decision-makers need context: how performance changed and what contributed to it. A percentage change plus a driver (Online channel) helps you decide what to repeat or improve.

Why other options are incorrect:

• A. This month’s sales are 68000 – This is useful, but it does not show improvement or decline compared to last month.
• C. The dataset contains 1200 rows – Row count is about data size, not performance insight.
• D. The workbook has 5 worksheets – Worksheet count has no direct meaning for business performance.

Correct answer: D. Check context such as number of customers, store count, or time period covered

★ Key Takeaway: Totals can be unfair comparisons when groups are different sizes.

Explanation: Region A might have more stores or more customers, which naturally produces higher totals. Comparing per-store or per-customer performance often gives a more accurate picture of real performance.

Why other options are incorrect:

• A. Immediately create a chart to confirm the result – A chart can visualize totals, but it does not fix an unfair comparison.
• B. Delete Region B to simplify the analysis – Deleting removes comparison and can hide issues you should understand.
• C. Replace totals with random sample values – Random replacement damages accuracy and is not a proper analysis method.

Correct answer: C. Break the total into parts, such as by product, region, or channel

★ Key Takeaway: Segmenting data explains what is driving the total.

Explanation: When you split totals into meaningful groups, you can see which part increased and which part declined. This helps you find causes and take targeted action instead of guessing.

Why other options are incorrect:

• A. Hide all columns except one to reduce clutter – Hiding columns can improve view, but it does not explain why the total changed.
• B. Use only the grand total and ignore categories – The grand total alone hides what changed inside the data.
• D. Change all numbers to text so they are easier to read – Turning numbers into text breaks calculations and makes analysis harder.

Correct answer: B. Profit is what remains after subtracting costs from revenue

★ Key Takeaway: High revenue does not guarantee strong profit.

Explanation: Profit reflects what the business keeps after expenses. In Excel analysis, separating revenue and cost helps you see whether growth is actually healthy.

Why other options are incorrect:

• A. Revenue is the same thing as profit – Revenue is money earned before expenses; profit is after expenses.
• C. Costs are always equal to revenue – Costs vary and can be lower or higher; they are not automatically equal.
• D. Profit is measured only by counting transactions – Transaction count does not account for prices or costs, so it cannot measure profit.

Correct answer: A. Each category’s percent of total sales

★ Key Takeaway: Percent of total shows contribution and makes categories easier to compare.

Explanation: Percent of total answers questions like “Which category is driving most sales?” even when totals are large. It is often clearer than showing totals alone.

Why other options are incorrect:

• B. The workbook file size in kilobytes – File size is a technical detail and does not explain sales contribution.
• C. The number of columns in the dataset – Column count does not tell you which category contributes most.
• D. The font size used in the report – Font size affects appearance, not the meaning of sales data.

Correct answer: D. Sales increased by 20 percent

★ Key Takeaway: Percent change compares the difference to the original value.

Explanation: The increase is 10000, and 10000 divided by the original 50000 equals 0.20, which is 20 percent. Percent change helps you compare growth even when totals differ.

Why other options are incorrect:

• A. Sales increased by 10000 percent – 10000 is the absolute increase, not the percent increase.
• B. Sales doubled exactly – Doubling would mean going from 50000 to 100000, not 60000.
• C. Sales decreased by 20 percent – The value increased, not decreased.

Correct answer: B. Compare multiple measures like revenue, profit, and units sold

★ Key Takeaway: Strong analysis checks more than one measure to avoid misleading conclusions.

Explanation: A product can have high revenue but low profit because of high costs. Looking at multiple measures gives a more complete, realistic view of performance.

Why other options are incorrect:

• A. Compare the font style used for each product’s row – Formatting does not tell you anything about business performance.
• C. Compare only the largest single transaction for each product – A single extreme value can distort reality and may not represent typical performance.
• D. Compare only the number of worksheets in the workbook – Worksheet count is unrelated to product performance.

Correct answer: C. Because outliers can pull the average away from what is typical

★ Key Takeaway: Outliers can distort averages, so always check the spread of your data.

Explanation: If most values are small but one value is extremely large, the average increases and may not describe a typical case. That is why analysts sometimes use the median for “typical” or review outliers separately.

Why other options are incorrect:

• A. Because an average always ignores numbers – An average uses numbers; it does not ignore them.
• B. Because an average is the same as the maximum – The maximum is the largest value; the average is a central measure.
• D. Because an average can only be calculated in Pivot Tables – You can calculate averages with formulas anywhere, not only in Pivot Tables.

Correct answer: D. What decision or question do we want the data to answer?

★ Key Takeaway: Clear questions lead to clear analysis.

Explanation: If you know the decision you need to support, you can choose the right metrics, groupings, and comparisons. Without a clear question, it is easy to create reports that look busy but are not useful.

Why other options are incorrect:

• A. Which font should the report use? – Appearance matters later, but it does not guide what analysis should be done.
• B. How many worksheets should the workbook have? – Workbook structure can change; the purpose of analysis should come first.
• C. Which chart looks the most attractive? – The best chart is determined by the message and data, not by looks alone.

Correct answer: A. Correlation means two things move together, but it does not prove one causes the other

★ Key Takeaway: Correlation is a clue, not proof.

Explanation: Two variables can rise together because of a third factor or coincidence. Good analysts avoid claiming “X caused Y” unless there is strong evidence beyond a simple relationship.

Why other options are incorrect:

• B. Correlation means one thing always causes the other – This is a common mistake; correlation alone cannot confirm cause.
• C. Causation means the data contains duplicates – Duplicates are a data quality issue, not a relationship concept.
• D. Causation means values are stored as text – Text numbers are formatting problems, not causation.

Correct answer: B. Returns increased after a delivery delay, so improving delivery speed may reduce refunds

★ Key Takeaway: Strong conclusions connect a pattern to a practical action.

Explanation: Managers need insights they can act on. This conclusion describes what changed (returns increased), links it to a likely driver (delivery delay), and suggests a decision (improve delivery speed).

Why other options are incorrect:

• A. The workbook file name is report-final-v3 – File names help organization, but they are not analysis results.
• C. There are 14 columns in the dataset – Dataset structure is not a decision-focused insight.
• D. Cell A1 contains the title – This is a worksheet detail, not an analytical conclusion.