Scribd
Upload
45 views10 pages

Excel MIS Assignment Solutions Guide

Uploaded by

shubham.soni
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
45 views10 pages

Excel MIS Assignment Solutions Guide

Uploaded by

shubham.soni
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
You are on page 1/ 10

MIS Using Excel - Assignment Solutions

1. What is the total sales revenue generated from mobile


sales?
Solution- =SUM(F2:F58)
2. Which month had the highest sales revenue, and can you
represent this information visually?
Solution-
3. Can you create a pivot table to show the total sales revenue
for each phone brand?
Solution-
4. Create a pivot table to show the total sales revenue for top 10
customers with the highest sales revenue?
Solution-
5. How many unique customers made purchases?

Solution- =SUM(1/COUNTIF(A2:A48,A2:A48))

6. How many units of Samsung Galaxy A52 were sold?


Solution- =SUMIF(B:B, "Samsung Galaxy A52", E:E)

7. How many transactions were recorded in the month of July


2023?
Solution- 4,
=COUNTIFS(C2:C51, ">=2023-07-01", C2:C51, "<=2023-07-31")
8. What is the total quantity of phones purchased in the first
quarter of 2023 (January to March)?
Solution- 15, =SUMIFS(E2:E51, C2:C51, ">=2023-01-01", C2:C51,
"<=2023-03-31")

You might also like