Microsoft PowerPoint $(10$ Marks$)$

Open a new PowerPoint application

IFS$113$E $2024$

a$)$ On the cover page, write the title: Value of Bitcoin in $2024.$ Also put the student numbers of all group members. $[2]$

b$)$ On the second slide, display the bar chart that you created on the spreadsheet. Resize it so that is fits properly and neatly $[2]$

c$)$ Format the colour scheme or the design of the slides so that it looks appealing. Ensure that your colour scheme or design does not diminish the visibility of your chart or any other text on the slides. $[4]$

d$)$ Add page numbers to your slides. $[2]$

Graphs and Charts $(10$ Marks$)$

a$)$ Using the data in Columns $D$ and $E,$ create a Clustered Column Bar Chart to compare the opening and closing values of Bitcoin during the month of April.

b$)$ Using your calculated values in column G$,$ create a $2$D line chart that will show the fluctuation of the closing value of Bitcoin from January $1,2024$ to April $30,2024.$ Create the chart next to the main table, below the Average Closing Value.

c$)$ Edit the chart area so that it displays:

I. The correct values on the horizontal axis $($dates$)2$

II$.$ The legend to the right of the chart $[2]$

III. An appropriate chart title $($you name it$)[2]$

Microsoft PowerPoint $(10$ Marks$)$

Open a new PowerPoint application

Basic Calculations $(10$ Marks$)$

a$)$ Using the Spreadsheet provided on Blackboard, perform the following calculations:

b$)$ In Cell F$3,$ convert the Opening Value of Bitcoin that is displayed in Cell B$2$ as US Dollars to South African Rands. A realistic conversion rate is provided in Cell J$1.[2]$

c$)$ Apply absolute referencing where necessary and drag the formula to apply the calculation throughout column $F$ to Cell F$122.$

$1$

d$)$ In Cell G$3,$ convert the Closing Value of Bitcoin that is displayed in Cell E$3$ as US Dollars to South African Rands. Use the conversion rate provided in Cell J$1.$

e$)$ Repeat C$.[1]$

f$)$ In Cell J$2$ calculate the average opening value of

IFS$113$E $2024$

Bitcoin, and in Cell J$3$ calculate the average closing value. Use the figures expressed in South African Rand. $[4]$