Scribd
Upload
5 views2 pages

Assignment II

The document outlines an assignment for undergraduate students on the fundamentals of Microsoft Excel, consisting of 10 questions to be completed in 2 hours. Tasks include creating a sales dataset, calculating total sales, using various Excel functions (SUM, COUNT, IF, VLOOKUP), and creating different types of charts. Students are required to apply formatting, perform calculations, and visualize data effectively.

Uploaded by

mohitsangwan9999999
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
5 views2 pages

Assignment II

The document outlines an assignment for undergraduate students on the fundamentals of Microsoft Excel, consisting of 10 questions to be completed in 2 hours. Tasks include creating a sales dataset, calculating total sales, using various Excel functions (SUM, COUNT, IF, VLOOKUP), and creating different types of charts. Students are required to apply formatting, perform calculations, and visualize data effectively.

Uploaded by

mohitsangwan9999999
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Assignment-II

Fundamentals of Microsoft Excel


Date: 01/03/26
Level: Undergraduate (Basic) Total Questions: 10 Time: 2.00 hours

Q1. Create Sales Dataset


Create the following table in Excel:

Product Category Quantity Unit Price Salesperson


Laptop Electronics 5 45000 Amit
Shirt Clothing 20 1200 Sneha
Mobile Electronics 8 18000 Rahul
Shoes Clothing 15 2500 Priya
Tablet Electronics 6 22000 Karan

a) Apply proper formatting and borders.


b) Format Unit Price in currency (₹).

Q2. Calculate Total Sales

a) Add a new column Total Sales.


b) Use formula: Total Sales=Quantity×Unit Price

Q3. Use SUM Function

a) Calculate total revenue generated.


b) Calculate total quantity sold.

Q4. Use COUNT and COUNTA

a) Count number of products.


b) Count number of salespersons.

Q5. Use MAX and MIN

a) Find highest total sale.


b) Find lowest unit price.
Q6. Use IF Function

Create a column Performance:

a) If Total Sales ≥ 1,00,000 → “High”


b) Otherwise → “Low”

Q7. Use VLOOKUP


Create a separate table:

Product Discount %

Laptop 10%

Shirt 5%

Mobile 8%

Shoes 6%

Tablet 7%

a) Use VLOOKUP to find discount percentage for each product in main table.

Q8. Create a Pie Chart

a) Create a Pie Chart showing category-wise total sales.


b) Add chart title.

Q9. Create a bar Chart

a) Create a Pie Chart showing category-Quantity sales.


b) Add chart title.

Q10. Create a bar Chart


a) Create a Pie Chart showing Salesperson-Total sales.
b) Add chart title.

You might also like