Unit: Information Communication Technology
27 Questions| 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