Flipkart Neev Online Assessment - NIT Jalandhar

Problem Preview

"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 - [x] **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 - [x] **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? - [x] **=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 | - [x] **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) - [x] **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? - [x] **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") - [x] **=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? - [x] **=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? - [x] **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? - [x] **=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) - [x] **=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 - [x] **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 - [x] **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 - [x] **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 - [x] **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."