. Create a hierarchical table identifying the three main categories of software and their subcategories. (17 marks) 3. List and describe the four pricing models commonly used in the software industry. (8 marks) 4. Compare and contrast the essential applications for desktops/laptops versus tablets/smartphones. Which ones are the same? Which ones are different? Do you agree or disagree with these lists? (15 marks) 5. Answer the steps for Microsoft Windows users and MAC users as requested below a. List the seven activities that take place during the installation process for PC software. How do you remove software from a PC? (5 marks) b. Describe the process for installing software on a MAC. How do you remove software from a MAC? (5 marks) 6. How do you describe the operating system? (1 mark) 7. List three applications that are the core of an office suite. (3 marks) 8. Should you use the Spell Checker built into your Word processor? Why? (2 marks) 9. According to the textbook what are several formatting factors that a user should be aware of to help then create the look of the final document? (3 marks) 10. Provide an example of What-If analysis? (2 marks) 11. Give an example of a spreadsheet formula that uses cell references and the most efficient formula to mathematically calculate each of the following: (2 marks each = 10 marks) If A1=5, B1=10, C1=20 Formula Add 10 to 50 times 5 2 marks Calculate the average 5, 10, 20 2 marks Calculate the highest number of 5,10,20 2 marks Calculate 5 by 10 2 marks Calculate 40 by 5 2 marks 12. What is the difference between relative referencing and absolute referencing with regards to using a spreadsheet? Show an example of what a cell of each looks like (4 marks) 13. What is a database? (1 mark) 14. Define what presentation software is. (2 marks) 15. What are the elements of a naming convention and what do naming conventions offer? (6 marks) 16. Identify what you could use to locate a computer files location. What are the components that could be included? (6 marks) M 17. Save and remember to keep a copy for you should there be any problems with the delivery.