Subtask 1: Create a MS Access database. Subtask 2: Create a chart. Subtask 3: Create a PowerPoint…

Question

Subtask 1: Create a MS Access database. Subtask 2: Create a chart. Subtask 3: Create a PowerPoint presentation template.

ScanSolve AI Tutor · Accepted Answer

Here's how to complete Subtask 2: Create a chart.

Calculate the "Increased Amount" for each cyber threat.
The increased amount is found by subtracting the "PRESENT" value from the "FUTURE" value.
- DDoS attacks: $69 - 61 = 8$
- Compromised third parties: $52 - 50 = 2$
- Android malware: $42 - 35 = 7$
- Nation-state attacks: $45 - 26 = 19$
- Cyber extortion: $42 - 19 = 23$
- Clickjacking: $24 - 19 = 5$
Complete the spreadsheet with the calculated "Increased Amount".
$\begin{array}{|l|c|c|c|} \hline \textbf{THREAT} & \textbf{PRESENT} & \textbf{FUTURE} & \textbf{INCREASED AMOUNT} \\ \hline \text{DDoS attacks} & 61 & 69 & \textbf{8} \\ \text{Compromised third parties} & 50 & 52 & \textbf{2} \\ \text{Android malware} & 35 & 42 & \textbf{7} \\ \text{Nation-state attacks} & 26 & 45 & \textbf{19} \\ \text{Cyber extortion} & 19 & 42 & \textbf{23} \\ \text{Clickjacking} & 19 & 24 & \textbf{5} \\ \hline \end{array}$
Create an embedded pie chart in Excel.
To create the pie chart displaying the increased amount of all threats:
- Enter the data from the completed table into an Excel spreadsheet.
- Select the "THREAT" column and the "INCREASED AMOUNT" column.
- Go to the "Insert" tab, then select "Pie Chart" from the Charts group.
- Add an appropriate chart title, such as "Increased Cyber Threats".
- Add data labels to show the specific increased amount for each slice of the pie.
- Ensure a legend is visible to identify which threat corresponds to which color slice.
- Embed the chart below the spreadsheet data.

Subtask 1: Create a MS Access database. Subtask 2: Create a chart. Subtask 3: Create a PowerPoint presentation template.