Scribd
Upload
24 views2 pages

Excel Assignment

The Excel assignment focuses on data analysis and visualization using a sales dataset for various products. Students are required to format data, perform calculations, sort and filter information, and create charts in Excel. The assignment must be submitted by May 20, 2025, and is evaluated based on data entry, formula usage, sorting, filtering, and chart creation.

Uploaded by

pc7774558
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
24 views2 pages

Excel Assignment

The Excel assignment focuses on data analysis and visualization using a sales dataset for various products. Students are required to format data, perform calculations, sort and filter information, and create charts in Excel. The assignment must be submitted by May 20, 2025, and is evaluated based on data entry, formula usage, sorting, filtering, and chart creation.

Uploaded by

pc7774558
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

Excel Assignment: Data Analysis &

Visualization
Learning Objectives
By completing this assignment, students will:
 Understand how to enter and manage data in Excel.
 Perform basic calculations using formulas and functions.
 Create tables, charts, and summaries.
 Use formatting to present data clearly.

Scenario: Sales Data Management


You are a sales analyst for a small electronics company. You’ve been given a dataset of
monthly sales for different products. Your task is to organize, analyze, and visualize this
data using Microsoft Excel.

Dataset
You must create the following table in Excel:

Product Jan Feb Mar Apr May Jun

Laptop 45 39 50 55 48 60

Smartphone 60 65 58 62 68 70

Tablet 30 28 35 33 32 38

Headphones 50 55 52 58 60 65

Smartwatch 20 25 30 28 27 35

Tasks to Complete

1. Formatting
1. Apply bold headings and center-align all cells.
2. Use conditional formatting to highlight sales greater than 60.
3. Apply a border to the entire table.
2. Calculations
1. In a new column, calculate the total sales for each product across all months using
the SUM function.
2. In another column, calculate the average sales using the AVERAGE function.
3. Use a formula to find the highest-selling product in June.
4. Use a function to calculate the month with the highest total sales.

3. Sorting and Filtering


1. Sort the data based on total sales in descending order.
2. Apply a filter to show only products with average sales above 40.

4. Charting
1. Create a column chart comparing monthly sales of all products.
2. Create a pie chart showing the proportion of total sales for each product.

Submission Guidelines
 Save the file as: YourID_ExcelAssignment.xlsx
 Submit the assignment via email by 20 May 2025

Evaluation Criteria
Data Entry & Formatting 3
Use of Formulas 10
Sorting & Filtering 3
Charts & Visualization 4
Total 20

You might also like