Computer Fundamentals and ApplicationsTU Board 2019
a) From the following spreadsheet, write the formula to address the following…
10a) From the following spreadsheet, write the formula to address the following conditions:S.nNameAddressPostSalaryBonusTaxHATotal1RamKimManager120002ShamPokharaAccountant115003HariPokharaEngineer10000Maximum Salary?Conditions: Bonus = 15% of Salary. Tax = 10% of Salary if Post is "Manager". HA = 5% of Salary if Address is not "Kim". Total = (Salary + Bonus + HA) - Tax. Find the maximum salary. b.What is Photoshop? Explain five major tools of Photoshop.
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