Scribd
Upload
19 views2 pages

Excel Practical Exercise

Microsoft Excel is a spreadsheet application used for data storage, calculations, and visualization, part of the Microsoft Office Suite. Key features include worksheets, formulas, data tools, and automation through macros, while common uses encompass budgeting, data analysis, and inventory management. A practical exercise involves analyzing sales data, calculating total sales, and creating visual representations using Excel functionalities.

Uploaded by

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

Excel Practical Exercise

Microsoft Excel is a spreadsheet application used for data storage, calculations, and visualization, part of the Microsoft Office Suite. Key features include worksheets, formulas, data tools, and automation through macros, while common uses encompass budgeting, data analysis, and inventory management. A practical exercise involves analyzing sales data, calculating total sales, and creating visual representations using Excel functionalities.

Uploaded by

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

What Microsoft Excel Is

 A spreadsheet application used to store data in rows and columns.


 Helps perform calculations, data analysis, and visualization using formulas,
charts, and graphs.
 Part of the Microsoft Office Suite (also available as part of Microsoft 365).

🔹 Key Features

1. Worksheets & Workbooks


o A workbook is the whole file (e.g., [Link]).
o A worksheet is a single sheet (tab) within the workbook.
2. Cells, Rows, and Columns
o Data is entered into cells (intersection of rows and columns).
o Each cell has an address (e.g., A1, B2).
3. Formulas and Functions
o Formulas are user-defined calculations (e.g., =A1+B1).
o Functions are built-in formulas like:
 =SUM(A1:A10) → adds numbers
 =AVERAGE(A1:A10) → finds average
 =IF(condition, value_if_true, value_if_false) → logical
decision
4. Data Tools
o Sorting & Filtering
o Data Validation
o Pivot Tables (summarizing large data sets)
5. Charts & Graphs
o Bar, Line, Pie, Column, Scatter, etc.
o Helps visualize trends and patterns.
6. Formatting
o Adjust fonts, colors, borders, and cell styles.
o Conditional formatting: change appearance based on rules (e.g., highlight
values >100).
7. Automation
o Macros (automating tasks using VBA programming).

🔹 Common Uses of Excel

 Budgeting and financial planning


 Data entry and record-keeping
 Creating reports and dashboards
 Analyzing sales, profits, or trends
 Academic grading systems
 Inventory management
 Statistical and scientific data analysis

Microsoft Excel Practical Exercise

📊 Scenario: Sales Report Analysis


You are given the following sales data for a small electronics shop. Use Microsoft Excel to
analyze and present the information.

Product Unit Price Units Sold Month


Laptop 50,000 12 January
Smartphone 25,000 20 January
Tablet 18,000 15 January
Laptop 50,000 10 February
Smartphone 25,000 18 February
Tablet 18,000 12 February

Tasks for Students


1. Enter the above data into an Excel worksheet.
2. Insert a new column called Total Sales and calculate it using the formula: Total Sales =
Unit Price × Units Sold.
3. Use the SUM function to calculate:
- The total sales for all products combined.
- The total sales for each product type (Laptop, Smartphone, Tablet).
4. Use the AVERAGE function to find the average units sold per product.
5. Apply conditional formatting to highlight Total Sales above 300,000 in green.
6. Create a Column Chart showing total sales for each product.
7. Create a Pivot Table that summarizes total sales per product across the two months.

You might also like