Ms Excel
1. How to run Ms-Excel ? Start-program,Ms-Excel.
2. How to exit from Ms-Excel ? File-exit.
3. How to save a document ? File-save(Ctrl+S)-type file name-enter/save/ok.
4. How to clear the screen ? File-close.
5. How to start a new worksheet ? File-new-ok.
6. How can go to saved file ? File-open-click on file from the open document box-enter.
7. How can preview the document ? File-print preview/Ctrl+F2
8. How can back from the preview document ? Esc from the keyboard.
9. Watching page setup. File-page setup-page/margin/header/footer from box.
10. How to copy any document/text ? Block text-Ctrl+C.
11. How to paste any copy text ? Target place-Ctrl+V.
12. How to move any text ? Block text-Ctrl+X.
13. How to write bold/italic/underline? Block text-B/I/U from the formating bar.
14. How to delete any text ? Block text-delete from keyboard.
15. How to change font or write bangla ? Block text-Ctrl+C-format-cell-font change-sushree-bijoy-Ctrl+B.
16. How to change text size ? Select text-change font from formatin bar.
17. How to up/down column/row ? Format-column /row width/height-enter.
18. How to insert column/row ? Select column area-insert-column.
19. How to delete column/row ? Select column/row-edit-delete.
20. Hiding column/row ? Select text-format-row/column hide.
21. Unhiding column/row. Select text-format-column/row unhiding.
22. How to create header/footer ? File-page setup-header/footer-left/centre/right-type text.
23. How to find a word ? Edit-find.
24. How to set a password in your own file ? File-save as-options-type passwod-again password-ok/enter.
25. How can go the password file ? File-save as open-file name-password name.
26. How to remove password ? Desire file—file-save as-option-delete key-ok/enter.
27. Sorting order. Select text-data-sort-ascending/decending-ok/enter.
28. Calculaton : Sum =sum(b2:d2)& -enter. Subt. =(b2-b3) & enter. Multi. =(b2*c2) & -enter. Div. =(b2/d2) & -enter. Aver. =average(b2:d2) & -enter. Max. =max.(b2:d2) & -enter. Min. =min.(b2:d2) & -enter. 29. Sale sheet. Sl No. Item Jan. Feb. Mar Total Avg. Min. Max. 1. Ram 5000 3000 2500 2. HDD. 2400 3600 3000 3. Pen.D 3000 2000 4000. Total Sum(B2:E2),Avg. (B2:E2),Min. (B2:E2),Max(B2:E2).
30. Stock Ledger. Sl No. Item Op-Stock Deliv. Cl.St Total 1. Book 5000 2400 550 2. Pen 4500 3000 250 Total= (C2-D2+E2)-enter.
31. Salary Sheet. H/R basic of 40%,M/A is 10%,T/A H/R of 5% Sl No Name Rank Basic H/R M/A T/A Total 1. Arif Officer 11000 2. Karim Officer 9000 3. Hanif Lecturer 6800 H/R basic=c2*40%,M/A basic=c2*10%,T/A H/R d2*5%.Total=sum(c2:f2)&-enter.
32. Result Sheet. SlNo Name Beng. Eng. Psyc. Eco. Total Result 1 Shahed 45 40 70 50 205 2 Kabir 75 70 80 65 290 Total=Sum(b2:e2) Result = if(b2>=33, “fail”,if(c2>=33, “fail”,if(d2>=33, “fail”,if(e2>=33, “fail”,if(f2>=230 ,“*”,if(f2>=200, “1st”,if(f2>=190, “2nd”,if(f2>=150,“3rd”, “fail”))))))))
33. Calculate of wages. 8 hour 600.00tk.wage, over time per hour 100.00tk.Total wages= ? Sl No. Name Work-hour Over-time Total wages. 1. Sadia 12 2. Farida 11 3. Anwar 10 4. Motiur 10 Over time =C1-8, Total wages = D1*100+600.
34. Calculate commission & Salary. Sales partners,purport salary with sales cost on 5% commission. Salary & commission statement = ? Sl No. Name Salary Sales Total Salary. 1. Sadia 20800 14000 2. Farida 7000 12000 3. Anwar 12500 10000 4. Motiur 12500 10000 Total Salary = C1+D1*5%& press enter.
35. To Calculate commission. 10% Com. sales of 5000tk. 12% com. sales of 7000tk.13% com. on 10000tk.15% com. of 15000tk. Sl No. Name Sales Commission 1. Sadia 20800 14000 2. Farida 7000 12000 3. Anwar 12500 10000 4. Motiur 12500 10000 =if(c1<=5000,c1*10%,if(c1<=7000,c1*12%,if(c1<=10000,c1*13%,if(c1>10000,c1*15%)))).
36. Income Tax. Monthly income 10000tk. tax upto 2%,15000tk. of 3%,20000tk. of 5% & above 20000tk.of 8%. Sl No. Name Monthly Inc. Inc. Tax. 1. Sadia 11000 2. Farida 12000 3. Anwar 20000 4. Motiur 30000 =if(c1=10000,c1*2%,if(c1<=15000,c1*3%,if(c1<=20000,c1*5%,if(c1>20000,c1*8%)))).
37. Interest. 5% interest of 10000tk.,7% interest of 15000tk.,9% of 20000tk.,10% of 25000tk. &15% above 30000tk. Sl No. Name Loan Amount Interest . 1. Sadia 11000 2. Farida 12000 3. Anwar 20000 4. Motiur 30000 =if(c1<=10000,c1*5%,if(c1<=15000,c1*7%,if(c1<=20000,c1*9%,if(c1<=25000, c1*10%,if(c1>=30000,c1*15%)))).