Unit: Information Communication Technology
27 QuestionsDownload CPA Information Communication Technology April 2023 past paper with detailed answers and marking scheme. This paper is based on KASNEB examination standards and is ideal for revision and exam preparation.
Access the full paper online, download the PDF, or study offline. Each question includes step-by-step solutions to help you understand key concepts in Information Communication Technology.
| Computer A | Computer B |
| 128GB Flash Drive 16GB RAM 150DPI Screen 15 inch screen | 512GB Hard Drive 8GB RAM 225DPI Screen 13 inch screen |
| 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.
| Feature | iOS | Android |
| Developer | ? | ? |
| Default browser | ? | ? |
Want to join the discussion?
Log in to post comments and interact with tutors.
Login to Comment