Hey now you are read Computer Operator Practical Question Set-2, hope you are read Computer Operator Practical Question Set-1, if you are not read and practice Set-1 please visit this after finished set-2. Thank you !!!, lest start set-2.
MS Word:
- Design a Certificate with page border flower of 30pt in Landscape mode with paper size A4,
- Write the Organization name in Center Position.
- Insert a Picture in Circle in Right top side of the certificate.
- Use center tab on 2 inch and 7 inch in a such way to set dotted line for signature and type chairperson and chief just the below the line.
- Type the suitable text in body part
- make an envelope with font size 12 in Devanagarik.
MS-Excel:
• Type the given data in Excel Sheet.
| Budgets of Our Company | ||
| Title | Expenses | Saving |
| Salary and Wages | 152000 | |
| Fuel | 45000 | |
| Newspaper | 4500 | |
| Electricity | 2545 | |
| Water | 2554 | |
| Security | 2150 |
• Make a Budget title in areal black bold 20 font.
• Insert new column between expenses and saving and put title ‘Actual expenses’
• Input the following data in Actual starting form Cell C4
| Salary and Wages | 14500 |
| Fuel | 40000 |
| Newspaper | 3500 |
| Electricity | 2000 |
| Water | 1800 |
| Security | 1500 |
- Calculate the saving From Cell D4 to D9.
- Put 2 point decimal format from cell B4 to D9
- Make the name Audit for sheet.
Database:
Input the following data in excel and perform the work:
| Name | Gender | Post | Salary | Phone Number |
| Ganit Kumar | M | MD | 45000 | 98017765540 |
| Rashmi | F | Manager | 35000 | 9801945857 |
| Bandana | F | Desk Manager | 25000 | 9841254875 |
| Kumar | M | Cleaner | 19000 | 9841549265 |
Create two query to display male only record and female only record.
PowerPoint:
Make a Presentation:
a. Insert two slide
b. Type EBanking in Master in top center with font 20 Arial Black Font
c. Type the types of Ebanking in list ATMS, Debit Card, Online Banking in First Slide
d. make any animation for Ebanking
HTML
• Make a link for PSC Online to go to web page www.psconline.gov.np for the text.
• Make the following table.
Also Read this:
Computer Operator Practical Question Set-2 Click Here
