Computer Fundamental application

Examination 2019
Group B
Attempt any Six question
2. What is Operating system? Explain the major functions of Operating System.
3. Differentiate between primary and secondary memory.
4. What is computer virus? Explain symptoms of computer virus.
5. Define database? Explain the advantages of database over tile based system.
6. What is proxy server? Write down the benefit of using proxy server in the organization.
7. Define e-commerce? Mention the benefits of using it in the context of customer?
8. Consider the following structure and answer the questions.
E:\ ROOT |---dir_1 | | file_1.txt | | file_2.txt | |____dir_3 |---dir_2 file_2.txt
a) Write down DOS command to create above files and directories. [2] b) Write down DOS command to move all text file into dir_3 directory. [1] c) Write DOS command to delete dir_1 directory. d) Hide the root directory from E drive.
Group C
Attempt any Two question
9. a) From the following spreadsheet, write the formula to address the following conditions:
ABC Company
Kathmandu
A | B | C | D | E | F | G | H | I | |
1 | SN | Name | Addr | Post | Salary | Bonus | Tax | HA | Total |
2 | 1 | Ram | Ktm | Manager | 12000 | ||||
3 | 2 | Sham | Pokhara | Accountant | 11500 | ||||
4 | 3 | Hari | Pokhara | Engineer | 10000 | ||||
Maximum Salary | 10000 |
Condition
1. Bonus will give 15% of salary. If his/her salary is less than equal to 6000
2. Tax will pay 10% of salary if his/her post is manager
3. HA will get 5% of salary, if he/she is not from ktm
4. Total is equal to the sum of (salary, bonus and HA) by deducting the Tax
5. Write a formula to find the maximum salary above the excel sheet.
b) What is Photoshop? Explain five major tools of Photoshop.
10. a) What is word processor? Explain the major function avaliable in the home tab of word document.
b) Define Network Topology? Write down the advantage of Network
11. a) What is animation? What are the advantages of using slide master in Powerpoint?
b) Explain block diagram of computer and its various components.