Assignments

Basic Excel Teachoo New.jpg

 

 

How to Make a Folder

1.png

 

Shortcut of Folder

2.png

All Folder Made

 

3.png

How to Make a File

 

4.png

Open Excel File

 

5.png

 

 

 

 

Answer of Q1

Q1.png

 

Formulas of Q 1

Q1 WITH FORMULAS.png

Hindi Videos

 

 

English Videos

 

 

Answer of Q2

Q2.png

Formulas of Q 2

Q2 WITH FORMULAS.png

 

English Video

 

 

Hindi Video

 

Formulas of Q 3

Q3 WITH FORMULAS.png

 

Hindi Video

 

English Video

 

Formula SLM Method of Q4

Q4 SLM METHOD.png

Formula WDV Method of Q4

Q4 WDV METHOD.png

 

 

English Video

 

 

 

Make Excel File with Following details

Employee Name Basic Salary
P 50000
Q 40000
R 10000
S 90000
T 8000

 

Make File Name- Basic Excel

Put Folder Name- Excel

Save Folder in D Drive 

 

Important Points

Dont Start from First Column First Row

Leave few rows on left and few rows on right

It is always better to Save File in D or E drive instead of Desktop or My Documents

(because data may be lost if computer windows is changed

We can create shortcut on Desktop for our convenience

  1. Excel

Transcript

BASIC Excel - teachoo.com Make a folder Called Training Make Some subfolders like Excel,Tally,GST,TDS Open Excel Folder. Make an Excel file called Basic Excel Open Excel File and Make the following in different sheets Q1 Item Quantity Rate Amount Discount 40% Net Amount GST 28% Total P 10000 2 Q 20000 4 R 15000 5 S 18000 6 T 40000 3 Total Q2 Employess Name Basic Pay DA HRA Bonus Gross Salary PF ESI Net Salary L 40000 1/2 of Basic 1/4 of (Basic + DA) Double of (basic + HRA) Total Salary 12% of (Basic + DA) 1.75% of Gross Salary Gross - PF -ESI M 15000 N 10000 O 20000 P 18000 Total Q3 Useful Excel Formulas Make the Following in Excel To Make Folder Ctrl Shift N Drag Down Select Area Ctrl D 1 1 100 100 Drag Right Select Area Ctrl R 2 3 200 200 Copy Paste Ctrl C CTRL V 3 5 300 400 Cut Paste Ctrl X Ctrl V 4 7 400 800 Bold Ctrl B 5 9 500 1600 If Some Mistake Ctrl Z or Esc 6 11 600 3200 To Edit a Cell F2 7 13 700 6400 To Save Ctrl S 8 15 800 12800 To Go To Next Sheet Ctrl Pagedown 9 17 900 25600 To Come Back Ctrl Pageup 10 19 1000 51200 To Minimize Windows D Q4 Make Depreciation chart WDV Method SLM Method Year Opening Value Dep 10% Closing Value Year Opening Value Dep 10% Closing Value 2020 100000 20000 80000 2020 100000 20000 80000 2021 80000 16000 64000 2021 80000 20000 60000 2022 64000 12800 51200 2022 60000 20000 40000 2023 51200 10240 40960 2023 40000 20000 20000 2024 40960 8192 32768 2024 20000 20000 0

About the Author

CA Maninder Singh's photo - Expert in Practical Accounts, Taxation and Efiling
CA Maninder Singh
CA Maninder Singh is a Chartered Accountant for the past 10 years. He also provides Accounts Tax GST Training in Delhi and Pune.