MS Excel 2007 Full Practical Test | 100 Marks Complete Step-by-Step Solution
About this video
MS Excel 2007 Full Practical Test with Complete Step-by-Step Solution | 100 Marks Practical Exam
In this complete MS Excel 2007 tutorial by PEARL INSTITUTE BATALA, you will learn how to solve a full 100-mark Excel practical test from start to finish.
This tutorial covers the complete practical test from Section A to Section J, including workbook setup, formulas, functions, formatting, sorting, filtering, charts, PivotTable, VLOOKUP, HLOOKUP, Data Validation, Goal Seek, printing, protection and more.
Topics Covered
Workbook setup and worksheet formatting
Data entry and AutoFill
Relative, Absolute and Mixed Cell References
Gross Amount, Discount, GST and Final Amount
SUM, AVERAGE, MAX, MIN
COUNT, COUNTA, COUNTIF
SUMIF and SUMIFS
ROUND Function
IF and Nested IF
AND and OR Functions
IFERROR
Sorting and Filtering
Conditional Formatting
Remove Duplicates
Custom Sort
Clustered Column Chart
Pie Chart
VLOOKUP
HLOOKUP
LEFT, RIGHT and MID
CONCATENATE
UPPER and PROPER
Student Result Sheet
Percentage, Result and Grade calculation
TODAY and Age calculation
Data Validation
Drop-down List
PivotTable
Subtotals
Goal Seek
Page Setup and Printing
Print Area
Header and Footer
Sheet Protection
Named Range
Excel Table
INDEX + MATCH
Basic Dashboard Concepts
The practical test is designed for students preparing for computer courses, DCA, PGDCA, CCC, office work, practical exams and Excel skill tests.
This video explains every major step in an easy Hindi/Hinglish style while keeping Excel commands and formulas in English.
PEARL INSTITUTE BATALA
Computer Education • Skill Development • Practical Training
Website: www.PEARLINSTITUTE.in
Contact: 7814976999
If this tutorial helps you, share it with students learning Microsoft Excel and subscribe for more practical computer tutorials.
