Microsoft Excel Assignments
Beginner to Advanced Practice
Introduction
Practice these Excel assignments to improve spreadsheet, formula, chart and data analysis skills.
Assignment 1: Workbook Basics
Create a workbook, rename sheets, enter student data, format cells, save as Assignment-1.xlsx.
Assignment 2: Basic Formulas
Use SUM, AVERAGE, MIN, MAX and COUNT on a marks sheet.
Assignment 3: Percentage & Grade
Calculate Percentage and Grade using IF function.
Assignment 4: Attendance Sheet
Create an attendance sheet with totals and percentage.
Assignment 5: Employee Salary
Calculate HRA, DA, PF, Gross Salary and Net Salary using formulas.
Assignment 6: Charts
Create Column, Pie and Line charts from sales data.
Assignment 7: Sorting & Filtering
Sort by marks and filter students scoring above 80.
Assignment 8: Conditional Formatting
Highlight Top 10 values, Duplicate values and Failed students.
Assignment 9: Lookup Functions
Use VLOOKUP/XLOOKUP to fetch employee details from another table.
Assignment 10: Pivot Table
Create a Pivot Table and Pivot Chart from sales data.
Sample Data for Practice
| ID | Name | Sales | Target |
|---|---|---|---|
| 101 | Amit | 45000 | 40000 |
| 102 | Neha | 52000 | 50000 |
| 103 | Ravi | 38000 | 42000 |
| 104 | Pooja | 61000 | 60000 |
Practical Assignments
- Student Result Sheet
- Salary Sheet
- Sales Dashboard
- Expense Tracker
- Inventory Management Sheet
Advanced Assignments
- Interactive Dashboard
- Budget Planner
- Loan EMI Calculator
- Invoice Generator
- Attendance Management System
- Sales MIS Report
- Pivot Dashboard
- HR Database
- Stock Register
- Project Tracker
Viva Questions
What is Microsoft Excel?
Write your answer after practice.
Difference between Workbook and Worksheet?
Write your answer after practice.
What is a Cell?
Write your answer after practice.
What is a Formula?
Write your answer after practice.
Difference between Relative and Absolute Reference?
Write your answer after practice.
What is AutoFill?
Write your answer after practice.
What is Conditional Formatting?
Write your answer after practice.
What is Pivot Table?
Write your answer after practice.
What is VLOOKUP?
Write your answer after practice.
What is XLOOKUP?
Write your answer after practice.
What is IF Function?
Write your answer after practice.
What is Data Validation?
Write your answer after practice.
What is Freeze Panes?
Write your answer after practice.
What is a Chart?
Write your answer after practice.
What is a Named Range?
Write your answer after practice.
Keyboard Shortcuts
| Shortcut | Function |
|---|---|
| Ctrl+S | Save |
| Ctrl+C | Copy |
| Ctrl+V | Paste |
| Ctrl+Z | Undo |
| F2 | Edit Cell |
| Ctrl+Shift+L | Filter |
| Alt+= | AutoSum |
0 Comments
Please comment any query