Description

Essentials of IT

Jun 2026 Examination

 

 

Q1. A financial analyst needs to show both the total budget size and the percentage contribution of different departments over three years. Which Excel chart types should be used to provide the clearest comparison of these two metrics for a board meeting? (10 Marks)

Ans 1.

Introduction

When a financial analyst needs to present two fundamentally different types of information simultaneously, total budget size and percentage contributions, choosing the right chart type is not a cosmetic decision but a communication one. A board meeting demands clarity above all else. Presenting one chart that tries to do both jobs usually results in a visual that does neither well. The answer lies in understanding what each chart type is designed to convey and how their combination gives board members the complete picture without ambiguity or cognitive overload.

Concept and Application

Excel offers multiple chart types, each optimized for a specific analytical purpose. For this

 

Its Half solved only

Buy Complete assignment from us

Price – 190/  assignment

NMIMS Online University Complete SolvedAssignments  session JUNE  2026

Last date 27 April 2026

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). The High School Events Club is organizing a huge Talent Show. For years, they have used a single Excel file on one laptop to manage the budget and use Analysis ToolPak to predict ticket sales. The New Idea: The Club President wants to move everything to Google Sheets. She loves that five people can type in the names of contestants at the same time and share the link with the Principal instantly. The Pushback: The Treasurer is worried. He says, Excel has better PivotTables to summarize our costs, and it’s safer because the file stays on my computer, not on the internet where anyone with a link might see it! Some members suggest using Google Sheets for the sign-up list but keeping the Excel file for the final money math. Your Task: 1. The Sharing Trade-off: What is the biggest advantage of using Google Sheets for the sign-up list compared to emailing an Excel file back and forth? 2. The Feature Gap: If the Treasurer needs Advanced Analysis tools that Google Sheets does not have, what is the risk of switching completely to the web version? (5 Marks)

Ans 2(A).

Introduction

The Events Club is facing a real-world technology trade-off that many organizations encounter when choosing between desktop and cloud-based tools. The decision is not simply about which platform is better in general but about which tool serves each specific task best. Real-time collaboration and advanced analytical capability are both legitimate requirements, and they pull in different directions.

Concept and Application

Google Sheets and Microsoft Excel are both spreadsheet tools, but their strengths reflect

 

Q2 (B). FreshFields Inc. has a table with Branch Name, Manager, and Q2 Sales. A junior analyst wants to see which branch had the highest sales, so they highlight only the Q2 Sales column and click Sort Z to A. Excel shows a warning message: Excel found data next to your selection. Since you have not selected this data, it will not be sorted. The Question: If the analyst chooses Continue with the current selection, what happens to the relationship between the Branch Name and the Q2 Sales figures? Why is Expand the selection the only safe choice for maintaining reporting accuracy? Can conditional formatting help in this case? (5 Marks)

Ans 2(B).

Introduction

Excel’s Sort warning is one of the most important data integrity safeguards in spreadsheet management. The analyst’s instinct to sort only the sales column is understandable but dangerous. Understanding why Excel issues this warning and what the two choices actually do to the dataset is essential for any analyst responsible for reporting accuracy.

Concept and Application

A spreadsheet table is a relational structure where each row represents a complete record. In