Computer Fundamentals and ApplicationsTU Board 2021
a) Consider the following Excel Sheet and write down the correct formula based on conditions:XYZ COMPANY KATHMANDUTAXSNNameSalaryService TaxIncome TaxTotalNet Salary1Bishnu KC10,000????2Ram…
10a) Consider the following Excel Sheet and write down the correct formula based on conditions:XYZ COMPANY KATHMANDUTAXSNNameSalaryService TaxIncome TaxTotalNet Salary1Bishnu KC10,000????2Ram Gurung20,000????3Nikita Nepal35,000????4Gita Karki40,000????Conditions: i. Service tax will be 5% for employees with a yearly salary greater than 1,50,000; otherwise, 1%. ii. Income tax will be:
- 0% for yearly salary up to 1,00,000
- 10% for yearly salary less than 2,00,000
- 15% otherwise iii. Total = Service Tax + Income Tax iv. Net Salary = Salary - Total Tax b) Explain the following DOS Commands with suitable examples: ATTRIB XCOPY MKDIR MOVE DEL
A worked answer is on its wayMeanwhile, read the Computer Fundamentals and Applications notes for this topic.
Discussion
Loading…
More Computer Fundamentals and Applications questions
Explain the fundamental components of a computer system and their functions.TU Board 20255Define computer memory. Explain memory hierarchy.TU Board 20255What is computer software? Differentiate between a program and software.TU Board 20255What is an Operating System (OS)? Explain different types of OS and give examples of Open Source OS.TU Board 20255What is a Database? Explain its main functions and types with examples.TU Board 20255What is browsing? What is meant by home page of a website? Explain any three Internet protocols.TU Board 20255