Assignment TitlePivot Table PracticeOpen Microsoft Excel.Select a dataset with column headers.Go to Insert → PivotTable.Create a Pivot Table in a...
Pivot Tables help organize and analyze data efficiently.
Assignment QuestionsOpen Microsoft Excel.Enter a small dataset with columns such as Product, Region, and Sales.Select the dataset.Go to Insert →...
Assignment Title; Understanding Charts and Data Visualization in Microsoft Excel
Assignment InstructionsRead the lesson on Charts and Data Visualization carefully and answer the following questions.Assignment QuestionsWhat is data visualization and...
Working with Excel Tables, Structured References, Sorting, and Data Management
Assignment Create a dataset in Excel with the following columns:Employee Name, Department, Salary, Years of Experience, and Gender.Convert the dataset into...
Creating and Managing Excel Tables
Create a small dataset in Excel with the following columns:Name, Age, Department, Salary, and Years of Experience.Convert the dataset into...
Cell Management Skills Assignment
📌 Assignment Instructions 🧩 Task 1: Create a Student Record TableOpen a new Excel workbook and create the table below starting...
Applying Relative, Absolute, and Mixed Referencing in Excel
Assignment Applying Relative, Absolute, and Mixed Referencing in ExcelYou are given a worksheet containing the following columns:Product NamePriceQuantityAmountYou are also given...
Practical Data Cleaning Using Excel Tools
📝 Assignment QuestionsUse Find & Replace to correct any incorrect or repeated names in the worksheet (e.g., correct misspelled names...
Practical Assignment: Creating Data Validation and Dependent Drop-Down Lists
Assignment Instructions 🔹 Simple Drop-Down List (10 Marks)Create a new worksheet.Create a list of the following fruits in one column:AppleOrangeBananaPineappleGuavaMangoIn another...
Aggregate Functions Practical Assignment
Assignment InstructionsDownload the attached Excel file and complete the tasks using the appropriate Excel functions.TasksUsing the dataset provided in the...