MS Excel -2016 Practical Questions
Day 1: Calculation of Bill and Formatting of Table :
File Download Link
Day 2: Calculation of Salary and Formatting of Table :
Day 3: Calculation of Mark-Sheet and Formatting of Table :
Day 4: Calculation of Grade-Sheet and Formatting of Table :
Day 5: Calculation of Attendance-Sheet and Formatting of Table :
Day 6: Calculation of Electricity Bill Calculation and Formatting of Table :
Day 7: Calculation of Telecom Bill Calculation and Formatting of Table :
Day 8: Calculation of Loan Amortization and Formatting of Table :
Day 9: Preparing of Ledger, Bank Statement, Stock Book, Purchase Book, Sales Book Formatting of Table :
Ledger Format
Bank Statement Format
Sales Book Format
Purchase Book Format
Stock Book Format
Excel Tips
Tips 1:
How to Autofit Cell according to text ?
-Right click on Sheet.
-Click on View Code.
-Then Visual Basic Windows display.
-Choose Worksheet from General Option.
Type: cells.EntireColumn.AutoFit
-After that close Visual Basic Windows .
Tips 2:
How to add KG/Pcs in Quantity ?
-Press Ctrl+1 (Format Cells)
-Click on Customs.
-Type: # "KG" /# "Pcs"
-Click on ok.
Tips 3:
How to add Rs. Currency Symbol In Amount?
-Press Ctrl+1 (Format Cells)
-Click on Custom
-Type: "Rs. "#,### or "Rs. "#,##0.00
-Click on ok.
Some Shortcut Key:
Key Function Example
Ctrl+1 Format Cell IT Computer
Ctrl+2 Bold IT Computer
Ctrl+3 Italic IT Computer
Ctrl+4 Underline IT Computer
Ctrl+5 Strike Through IT Computer