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

1. CPU/GPU - Upgrading the Central Processing Unit (CPU) or Graphics Processing Unit (GPU) can significantly boost performance and allow for better handling of intensive applications.
2. RAM - Increasing the amount of RAM helps in processing larger datasets and running more applications simultaneously.

1. Not enough disk space - As the available disk space decreases, the computer's performance can slow down due to limited resources for processing and temporary file storage.
2. Fragmented hard drive - Over time, data may become fragmented, resulting in longer access times as the computer struggles to read data stored in non-contiguous sectors.

A Network Interface Card (NIC) or dongle must be installed in each computer to allow for network connections.

1. Lacks security for unauthorized access - In a peer-to-peer setup, individual computers operate independently without a centralized security protocol, making sensitive data more vulnerable.
2. No centralized management of network resources - Managing resources like files and printers can become cumbersome as there is no central point for administration.

1. UTP/STP cable - Unshielded Twisted Pair (UTP) or Shielded Twisted Pair (STP) cables are commonly used for Ethernet networks.
2. Ethernet cables - Standard Ethernet cables can efficiently connect multiple computers in a local area network.

A router or modem is required to connect the local area network (LAN) of the library to the internet.

1. Data can be accessed from anywhere - Cloud storage allows users to access their files from any location with an internet connection, providing flexibility and convenience.
2. Storage can be easily upgraded - Cloud services typically allow for easy scaling of storage space according to the library's needs.

1. Data may be stolen or compromised - Restoring data is crucial for recovering information that has been lost due to unauthorized access or data corruption.
2. Recent changes may have destabilized the system - In case of software instability caused by recent changes, restoring previous data can help regain functionality.

<br> tag is used to create an open line in a paragraph in HTML.

1. Each <td> tag should be correctly nested within a <tr> tag, ensuring the correct structure for table rows.
2. The closing </table> tag needs to be moved to the appropriate position at the end of the table code.

The wrap text feature can be used by pressing Alt + Enter before 'Earned' to display all the content without needing to adjust the column width.

The values in the range A2:A6 have been formatted as text and centered.

Option 1: =SUMIF(B2:B37492,"Cape Town",E2:E37492) is more appropriate because it automatically considers the entire range and provides a more accurate and efficient calculation, compared to Option 2 which requires manual selection of each cell.

1. The 'Yes' and 'No' arguments should be swapped for the second IF statement to display the correct output.
2. The first IF statement is missing a 'No' as the third argument which is necessary to complete the conditional statement.