A structured compilation of technical multiple-choice questions covering Microsoft Excel, Data Visualization, and Supply Chain Case Studies with verified answers and explanations.

---

Technical: MS Excel & Visualization MCQs

Question 46

Group: Technical | Section: MS Excel | Marks: 1

Problem Statement:
Consider the below table:

Donation ID	Donor ID	Type	Method	Status	Amount
1	D1	Donation	Credit Card	Completed	5000
2	D2	T-Shirt	Paypal	Abandoned	500
3	D3	Food	Paypal	Failed	3000
4	D4	Cash	Credit Card	Failed	1000
5	D5	Stationary	Paypal	Completed	400
6	D6	T-Shirt	Credit Card	Abandoned	500

User has to create the below Pivot table from the above given data:

Count of Method	Credit Card	Paypal	Grand Total
	3	3	6

Which of the selections users must follow to create the above Pivot table, please choose the correct option?

• Pivot Table Fields Pane -> Choose Fields -> Select "Add as a Slicer" in Method Dropdown
• Pivot Table Fields Pane -> Choose Fields -> Select "Add to Rows" in Method Dropdown
• Pivot Table Fields Pane -> Choose Fields -> Select "Add to columns" in Method Dropdown
• Pivot Table Fields Pane -> Choose Fields -> Select "Add to Values" in Method Dropdown

Explanation:
The categories (Credit Card and Paypal) are arranged horizontally as column headers across the top with a trailing "Grand Total" column. Placing the field into the Columns area generates this horizontal layout.

---

Question 47

Group: Technical | Section: MS Excel | Marks: 1

Problem Statement:
What would be the output of the following formula when applied to the below data:
=FIND("C2", C2, 2)

Where cell C2 contains: C1C2C3C4C3C2C1

• 1
• 2
• C1C2C3C4C3C2C1
• 3

Explanation:
The FIND(find_text, within_text, [start_num]) function returns the 1-based character position of the substring.

• Position 1: C
• Position 2: 1
• Position 3: C
• Position 4: 2
  Starting search from index 2, the first "C2" substring begins at position 3.

---

Question 48

Group: Technical | Section: MS Excel | Marks: 1

Problem Statement:
You have a list of sales figures from B1 to B10, and you want to find the smallest number in the list. Which formula will give you the result?

• =MIN(B1:B10)
• =MINIMUM(B1:B10)
• =SMALL(B1:B10)
• =LOW(B1:B10)

Explanation:
=MIN() is the built-in Excel function for finding the minimum value in a range. Functions like MINIMUM and LOW do not exist, while SMALL requires a second rank parameter (k).

---

Question 49

Group: Technical | Section: MS Excel | Marks: 1

Problem Statement:
What will be result of the following formula when applied to the below data:
=SUMIF(A2:A5, "China", B2:B5)

	A	B	C	D
1		A1	A2	A3
2	India	180	320	440
3	China	240	160	310
4	India	230	520	420
5	China	350	520	620

• 590
• 350
• Error will be shown
• 240

Explanation:
The formula sums column B where column A equals "China":

• Row 3: 240
• Row 5: 350
• Total: $240 + 350 = 590$.

---

Question 50

Group: Technical | Section: MS Excel | Marks: 1

Problem Statement:
Consider the below excel sheet, if the user wants to calculate the average of the cell range E6 to E10 then, which of the formulas is used?

(Values in E6:E10 are 10, 20, 30, 40, 50)

• AVRG(E6:E10)
• AVG(E6:E10)
• =AVERAGES(E6:E10)
• AVERAGE(E6:E10)

Explanation:
The standard Excel function for arithmetic mean is AVERAGE. Abbreviations like AVG or AVRG are invalid.

---

Question 51

Group: Technical | Section: Visualization | Marks: 1

Problem Statement:
What is the first step in structuring an effective report?

• Provide context and interpretation
• Include only raw data
• Explain the central information and recommendations
• Use technical terms extensively

Explanation:
An effective report begins by framing the background, objectives, and context so the audience understands the purpose and scope before reviewing data and recommendations.

---

Question 52

Group: Technical | Section: MS Excel | Marks: 1

Problem Statement:
You want to calculate the total sales for a specific product category listed in column A and the sales amounts in column B. You need to sum only the sales that meet the criteria. Which formula would you use?

• =COUNTIF(A:A, "Electronics")
• =SUMIF(A:A, "Electronics", B:B)
• =SUM(A:A, B:B)
• =SUMIFS(B:B, A:A, "Electronics")

Explanation:
The syntax for SUMIF is =SUMIF(range, criteria, [sum_range]). Here, A:A is checked for "Electronics" and corresponding values in B:B are summed.

---

Question 53

Group: Technical | Section: MS Excel | Marks: 1

Problem Statement:
Consider the table given below. User has to display the value only for Group B. If none of the values found then "No Results Found" must be displayed. Which of the below formulas can be used?

• =FILTER(A4:C8, B3:B9="B", "No Results Found")
• =FILTER(A3:C9, B3:B9="C", "No Results Found")
• =FILTER(A3:C9& B3:B9="B", "No Results Found")
• =SEARCH("No Results Found", A2:C9:B3:B9="B")

Explanation:
The dynamic array function FILTER takes =FILTER(array, include, [if_empty]). Filtering condition B3:B9="B" selects Group B records and returns the fallback string when no match exists.

---

Question 54

Group: Technical | Section: Visualization | Marks: 1

Problem Statement:
Which of the following list of challenges is not true for an organization in adopting analytics techniques to succeed in the market?

• Cultural acceptance to change
• Lack of technology leadership
• Insufficient organizational agility
• Lack of direction in the business

Explanation:
Cultural acceptance is an enabler and positive driver for digital transformation, whereas cultural resistance is the actual challenge/barrier.

---

Question 55

Group: Technical | Section: MS Excel | Marks: 1

Problem Statement:
You want to create a list of numbers from 1 to 10 in a column using a single formula. Which formula would you use?

• =SEQUENCE(10, 1, 1, 1)
• =RANGE(1, 10)
• =ARRAY(1, 10)
• =LIST(1, 10)

Explanation:
Excel's dynamic array formula =SEQUENCE(rows, [columns], [start], [step]) with parameters (10, 1, 1, 1) generates values from 1 to 10 vertically.

---

Question 56

Group: Technical | Section: MS Excel | Marks: 1

Problem Statement:
Consider the below excel sheet image, where A2, A3 and A4 cells have a value (A2=10, A3=8, A4=1). User wants to show the value in cell A5 as TRUE only if the value of the cell A2 is greater than the value of cell A3 and the value of the cell A4 is greater than the value of A2. Which of the below formulas can be used?

• =AND(A3>A2, A2<A4)
• =AND(A3>A2, A4<A2)
• =AND(A2>A3, A2<A4)
• =AND(A2>A3, A4<A2)

Explanation:

• Condition 1: $A2 > A3$ (A2>A3)
• Condition 2: $A4 > A2$, which is identical to $A2 < A4$ (A2<A4)
  Joining with AND: =AND(A2>A3, A2<A4).

---

Question 57

Group: Technical | Section: Visualization | Marks: 1

Problem Statement:
When designing a data visualization for a broad audience, what is a key consideration for ensuring accessibility?

• Incorporating interactive features
• Including complex statistical analyses
• Using a wide range of colors for variety
• Ensuring readability for color-blind individuals

Explanation:
Accessibility guidelines mandate high-contrast ratios and color palettes distinguishable by individuals with color vision deficiencies (e.g., deuteranopia, protanopia).

---

Question 58

Group: Technical | Section: Visualization | Marks: 1

Problem Statement:
What is the primary purpose of using a diverging color scheme in a data visualization?

• To highlight a single data point
• To emphasize a trend over time
• To show a comparison between two groups
• To represent a range of values with a midpoint

Explanation:
Diverging color schemes highlight deviations in two directions from a critical baseline/midpoint (e.g., positive vs. negative margins, above vs. below target).

---

Question 59

Group: Technical | Section: MS Excel | Marks: 1

Problem Statement:
You enter "01-May-2025" in a cell and drag the fill handle. Which Autofill option ensures only weekdays are filled?

• Use Ctrl + Drag method
• Format cells as short date
• Choose Fill Weekdays option
• Drag the handle directly

Explanation:
The AutoFill contextual options menu provides "Fill Weekdays", which auto-increments dates while omitting Saturdays and Sundays.

---

Question 60

Group: Technical | Section: Visualization | Marks: 1

Problem Statement:
If I want to show the percentage distribution of expenses in a budget (e.g., rent, utilities, groceries) then which chart is more suitable?

• Histogram
• Pie Chart
• Bar Chart
• Box Plot

Explanation:
Pie charts and donut charts are specifically suited for part-to-whole categorical percentage distributions that sum to 100%.

---

Case Study: Supply Chain

Question 61

Group: Case Study | Section: Supply Chain | Marks: 10

Scenario:
Around 600 small marketplace sellers operate in three manufacturing clusters. Most sellers individually send low-volume shipments to the fulfillment centre, leading to irregular and high freight cost and frequent missed receiving cut-offs. A scheduled milk-run collection could consolidate volume, but sellers have different production times and fear penalties if they miss the pickup window. The current 3PL is willing to pilot dedicated routes only if minimum daily volume is guaranteed.

Solution Framework

1. Seller Segmentation

   • Tier 1 (High Volume): Daily scheduled milk-run pickups aligned with fixed production-ready times.
   • Tier 2 & 3 (Low/Medium Volume): Aggregated drop-offs at cluster micro-hubs or alternate-day milk-runs.

2. Route & Frequency Design

   • Daily Evening Milk Runs: 1–2 dedicated circular collection routes per cluster between 4:00 PM and 7:30 PM.
   • Consolidated Linehaul: Direct transit to the fulfillment center before overnight docking cut-offs.

3. Consolidation Points (Cluster Hubs)

   • Micro-Hubs: 1 central drop-off node per cluster allowing delayed sellers to self-drop orders prior to linehaul departure.

4. Pickup-Window Rules & SLA Safeguards

   • Defined Slots: 30-minute pickup windows with real-time ETA alerts.
   • Penalty Grace Period: 15-minute driver wait tolerance and fee waivers during the 4-week pilot to encourage adoption.

5. Commercial Arrangements

   • Volume Underwriting: Marketplace provides a take-or-pay baseline volume guarantee to the 3PL.
   • Cost Sharing: Freight efficiency gains passed back as discounted per-unit fulfillment fees.

6. Exception Handling & Contingencies

   • Missed Pickups: Flexible self-delivery to the cluster hub before final departure.
   • Fleet Redundancy: 3PL maintains a dedicated standby buffer vehicle per cluster.

7. Key Metrics & KPIs

   • Capacity: $\ge 80%$ vehicle cube utilization.
   • Cost: $20 ext{--}30%$ reduction in per-unit freight expense.
   • Reliability: $\ge 95%$ on-time pickup rate; $\ge 70%$ seller pilot adoption within 60 days.