$1.$ Describe the two major kinds of software $($Chapter $1).(4$ marks$)$

$2.$ Describe two types of system software programs $($Chapter $1).(4$ marks$)$

$3.$ Define and compare general$-$purpose applications, specialized applications, and mobile apps $($Chapter $1).(6$ marks$)$

$4.$ List the three most used categories of application software $($Chapter $3).(3$ marks$)$

$5.$ Discuss six common features in application programs $($Chapter $3).(12$ marks$)$

$6.$ When would you use each of the following application programs: word processor, spreadsheet, database management system, and presentation software? $(4$ marks$)$

$7.$ Provide an example of a mobile application for: music, video, social networking, shopping, and games. $(5$ marks$)$

$8.$ Provide an example of What$-$If analysis? $(2$ marks$)$

$9.$ 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 A$1=15,$ B$1=100,$ C$1=200$

Formula

Calculate the product of $15$ and $100$

$2$ marks

Calculate the average of $15,100,200$

$2$ marks

Calculate the highest number of $15,100,200$

$2$ marks

Calculate the difference of $200$ and $100$

$2$ marks

Calculate the lowest number of $15,100,200$

$2$ marks

$10.$ 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 look like? $(4$ marks$)$

$11.$ What are video editors? What are image editors? What are illustration programs? What are desktop publishing programs? $(4$ marks$)$

$12.$ What are blogs? What is Web Authoring and web authoring programs? What is WYSIWYG? $(4$ marks$)$

$13.$ What is a software suite? What are the advantages of purchasing a suite? $(2$ marks$)$

$14.$ What is the difference between a traditional office suite and a cloud or online suite? $(2$ marks$)$