An overview of application packages

April 2023

1 Questions

Question 2c

David Omondi is the owner of a Home Appliances shop at the Douala Branch. Details of items sold by him during the month of March 2023 were given below:

A	B	C
ITEMS	BRAND	SALES PRICE
COLOUR TV WASHING MACHINE REFRIDGERATOR WASHING MACHINE COLOUR TV REFRIDGERATOR WASHING MACHINE COLOUR TV	SAMSUNG LG WHIRLPOOL LG WHIRLPOOL SAMSUNG SAMSUNG LG	28,000 23,000 24,000 22,000 35,000 25,000 22,000 20,000

Required:

Explain the steps required to prepare a pivot table with the above information to show the sales for each brand using a spreadsheet application such as LibreOffice Cac. Use proper cell references in your explanation.

Answers and Explanations are locked.

December 2022

2 Questions

Question 4a

Differentiate between an “accounting package” and a “spreadsheet” based on the following features:

(i) Report generation.

(ii) Audit trail.

Answers and Explanations are locked.

Question 6a

(i) Highlight features of a presentation program that are not available in a word processing program.

(ii) Explain contexts in which one would need to use a presentation program instead of a word processing program.

Answers and Explanations are locked.

An overview of application packages

Premium Topic Resources

April 2023

December 2022