Practice from Computer Fundamentals and Applications with detailed solutions and model answers from past Tribhuvan University exams.
How do you define the term computer software? Explain types of computer software.
(a) Consider the following Excel Sheet and write down the correct formula based on the given conditions:
| XYZ COMPANY KATHMANDU | ||||||
| TAX | ||||||
| SN | Name | Salary | Service Tax | Income Tax | Total | Net Salary |
|---|---|---|---|---|---|---|
| 1 | Bishnu KC | 10,000 | ? | ? | ? | ? |
| 2 | Ram Gurung | 20,000 | ? | ? | ? | ? |
| 3 | Nikita Nepal | 35,000 | ? | ? | ? | ? |
| 4 | Gita Karki | 40,000 | ? | ? | ? | ? |
i. Service tax will be 5% for employees with a yearly salary greater than 1,50,000; otherwise, 1%.
ii. Income tax will be:
b) Explain the following DOS Commands with suitable examples: ATTRIB
XCOPY
MKDIR
MOVE
DEL
a) Explain the major functions available in the Layout tab of a Word document. b) What is the use of a layer in Photoshop? How do you organize layers in Adobe Photoshop?
What are hardcopy devices? Explain the working mechanism of dot-matrix, laser, and ink-jet printers.
What kinds of programs fall under the utility category? Describe a utility program you have on your computer.
Write down characteristics and applications of laser printer.
a) What is a softcopy device? Explain the working mechanism and applications of the OMR. b) Write DOS Commands to perform the following tasks: i. To create the TU directory at the current prompt. ii. To display the tree view structure of the files and folders included within the TU directory. iii. To remove the BCA and MCA (non-empty folders) from the current prompt. iv. To locate the IP address of your computer in the network. v. To discover the presence of a remote device on the network.
Utility software helps to maintain proper and smooth functioning of a computer system. Justify it with proper examples.