CSIT Family An online CSIT community

Colleges

Triton International College

Location: Subidhanagar, Tinkune

Phone No: 123456790

Courses: BCA, BBA, BIM, BBS, BIT

Triton International College

Location: Subidhanagar, Tinkune

Phone No: 123456790

Courses: BCA, BBA, BIM, BBS, BIT

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.

I there is