Description

Essentials of IT

Dec 2025 Examination

 

 

Q1. Mike, a sales manager at a small electronics company, tracks monthly sales data for laptops, smartphones, and accessories from January to June. He wants to visualize this data to compare category performance and identify trends. Mike is familiar with Excel’s various chart types but is unsure which to use for clear communication of both trends and category comparisons. He must present his findings to the management team, who expect actionable insights and visually compelling charts. Based on the scenario, how should Mike apply his knowledge of different Excel chart types to effectively visualize and compare the sales performance of laptops, smartphones, and accessories over six months? Discuss which chart types he should select for trend analysis and category comparison, and justify your recommendations using relevant chart selection frameworks. (10 Marks)

Ans 1.

Introduction

In today’s competitive business world Data visualization has emerged as one of the best methods of communicating the results effectively. Mike is a sales manager, is in charge of providing six months of sales data on smartphones, laptops and accessories. Although the numbers on tables can display the totals, they are often unable to show patterns, growth trends or show performance comparisons across different categories. Selecting the appropriate Excel chart type lets management to comprehend the significance of the numbers at a glance. Because Mike would like to emphasize the overall trends over time as well as comparisons between different categories, he should choose the right chart type. The quality of his presentation is dependent on the combination of charts that look appealing and simple to read and based on the frameworks of chart selection like “compare

 

Its Half solved only

Buy Complete assignment from us

Price – 190/  assignment

NMIMS Online University Complete SolvedAssignments  session DEC 2025

Last date 16 OCT 2025

buy cheap assignment help online from us easily

we are here to help you with the best and cheap help

Contact No – 8791514139 (WhatsApp)

OR

Mail us-  [email protected]

Our website – www.assignmentsupport.in

 

Q2(A). A national sales organization operates across multiple regions and tracks sales data for hundreds of products. The executive team relies on a dashboard built in Excel, which uses PivotTables and slicers to filter and visualize sales by region, product, and time period. However, some executives have raised concerns about the dashboard’s responsiveness and the clarity of insights when multiple slicers are applied simultaneously. The analytics team is tasked with evaluating the current approach and recommending improvements. Assess the effectiveness of using PivotTables with slicers for real-time sales performance monitoring in a geographically dispersed sales organization. What limitations might arise ? (5 Marks)

Ans 2a.

Introduction

In big national sales companies the ability to monitor sales in real-time across products and regions is crucial for deciding. PivotTables in Excel as well as slicers are frequently utilized to analyze and present the data in a way that is interactive. Although this method allows for flexibility and speedy filtering, some executives have expressed concerns regarding dashboard flexibility and clarity, particularly when multiple filters are used. An objective assessment is necessary to assess how effective the system really is and what issues could arise in a dispersed geographical business environment.

Concept and Application

Before we can analyze the limitations, it’s essential to comprehend the fact that

 

 

Q2(B). Ms. Priya, owner of Elite Electronics, has announced a bonus scheme for sales associates based on their sales figures. She instructs Raj, the finance manager, to use specific colors in Excel to highlight associates eligible for different incentive tiers. With over 200,000 units sold across multiple locations, the dataset is extensive. Raj must ensure that the formatting is both accurate and easily interpretable by management and staff. Critically assess the decision to use color-based conditional formatting (blue for 5,000+ units, yellow for 3,000–4,999 units) for incentive eligibility at Elite Electronics. What are the strengths and limitations of this visual approach in large-scale data management, and how could the process be improved to ensure accuracy and clarity for all stakeholders? (5 Marks)

Ans 2b.

Introduction

Within Elite Electronics, a bonus scheme for sales associates been launched in conjunction with Raj assigned to utilize Excel’s conditional formatting in order to highlight employees who are eligible in accordance with the number of sales units. Color-coding – blue for 5,000+ units and yellow for 3,000-4999 units — is meant to facilitate the recognition of the eligibility for incentives. While this approach appears easy to use, the vast collection of over 200,000 units in multiple locations raises concerns about accuracy, scalability, as well