Create a spreadsheet and graph (introductory). (i) Copy the information in the table below into a spreadsheet. Name and save the spreadsheet file appropriately. (ii) From the copied information, create a pie chart using the Chart Wizard function. (iii) Adjust the colours selected so the chart will print out in black and white. Save the final version of your spreadsheet. Print the chart out directly from Excel. Relative percentage composition of elements in the Earth's crust. $$ \begin{array}{lc} \text { Element } & \text { Percentage } \\ \text { oxygen } & 46.2 \\ \text { silicon } & 28.2 \\ \text { aluminium } & 8.2 \\ \text { iron } & 5.6 \\ \text { calcium } & 4.2 \\ \text { sodium } & 2.4 \\ \text { magnesium } & 2.3 \\ \text { potassium } & 2.1 \\ \text { titanium } & 0.6 \\ \text { hydrogen } & 0.2 \\ \text { Total } & \frac{0.2}{100} \end{array} $$

Step by step solution

01

Input Data

First, the data must be inputted into an Excel spreadsheet. In the first column, input the names of the elements. In the second column, input the corresponding percentages for each element.

02

Create Pie Chart

With the data inputted, a pie chart can be created. Highlight the data, and then navigate to the 'Insert' tab on Excel. From there, click on 'Pie Chart' and select the first pie chart option. Make sure to include the data labels which show the percentages for each element.

03

Adjust Colors

Under 'Chart Tools', click on the 'Format' tab, and then on 'Shape Fill' to adjust the colors of the pie chart so it can be printed in black and white. Aim for varying shades of grey to differentiate between the different elements in the pie chart.

04

Save and Print

Once the adjustments have been made, save the final version of the spreadsheet. Then proceed to print the chart directly from Excel.

Unlock Step-by-Step Solutions & Ace Your Exams!

• Full Textbook Solutions

  Get detailed explanations and key concepts

• Unlimited Al creation

  Al flashcards, explanations, exams and more...

• Ads-free access

  To over 500 millions flashcards

• Money-back guarantee

  We refund you if you fail your exam.

Start your free trial

Over 30 million students worldwide already upgrade their learning with Vaia!