AcademyOne is a large academic library that sends books to smaller libraries across the country - NSC Computer Application Technology - Question 10 - 2018 - Paper 2

Two hardware components that would likely need upgrades to handle large data processing are:

1. CPU/GPU - Enhancing processing power for better performance.
2. RAM - Increasing memory capacity to handle larger applications and datasets.

1. Not enough disk space: When storage devices are nearly full, the computer struggles to perform optimally as it lacks the space to manage temporary files.
2. Hard drive becomes fragmented: With time, files can become scattered across the drive, making access slower due to additional read/write times.

A NIC (Network Interface Card) or a dongle must be installed in each computer to enable network connectivity.

1. Lacks security for unauthorized access: Peer-to-peer networks typically don't have centralized security protocols, making them vulnerable.
2. No centralized management of network resources: This could lead to inefficient sharing and potential data loss as there is no control over who accesses what resources.

Suitable wired media include UTP/STP cables, LAN cables, Ethernet cables, or simply Network cable for establishing connections between computers.

A Router or Modem would be required to connect the library's Local Area Network (LAN) to the internet.

1. Accessibility: Cloud storage allows access to files from anywhere, making it easier to manage documents remotely.
2. Automatic backups: Cloud solutions often provide automated backup services, ensuring data safety without manual intervention.

1. Data recovery from corruption or theft: If the original data is lost or compromised, backups can restore it to a secure state.
2. System failure or accidental deletion: Backups are essential for recovering data in case of software failure or unintentional file removal.

The tag <ul> (unordered list) is used to create a bulleted list in HTML.

The <br> tag is used to create a line break in a paragraph in HTML.

1. Move the <td> tags within the <tr> elements properly by ensuring each row is enclosed between <tr> and </tr> tags.
2. Ensure there are proper closing tags for each <td> to maintain table structure.

The Wrap text feature allows the content of cell E1 to be displayed fully without adjusting the column width.

The cell values in the range A2:A6 are formatted as text and are also centered.

Option 1: =SUMIF(B2:B37492,"Cape Town",E2:E37492) is the most appropriate as it calculates the total amount directly based on criteria, saving time and ensuring more accurate results.

1. The 'Yes' and 'No' arguments are swapped in the second IF condition, which leads to logical errors in displaying results.
2. The first IF statement is missing a No as the third argument, which leads to incomplete conditions.