1) Open a new sheet (Sheet 2) in the Excel workbook.
2)
In Sheet 2, create a table from the data above displaying the the percent of females
that have been diagnosed with diabetes and the percent of the females that haven't
been diagnosed with diabetes in the year 2014. Type ONLY the data needed for the
graph in the cells. Resize the rows/columns to fit your data if necessary. Do not skip
cells in the rows or columns.
3)
Apply borders to the entire table. You may also apply a design to the table.
4)
5)
Highlight the table you just created.
Click on the Insert tab, then on Recommended Charts. Select an appropriate pie
chart to represent the data.
A graph will appear displaying your data. You may apply a design to the graph.
With the graph selected, click the plus sign and add the following chart elements if
necessary:
6
7)
.
The graph should have an appropriate title.
The slices should be named "Diagnosed with Diabetes" and "Not Diagnosed with
Diabetes" and the percent of the total.
After part 1, insert a page break and copy and paste the table and pie chart on page 3
of the Word document. Label the top of the page "PART 2
S)
9
Below the table/graph, answer (in full sentences) question #2:
Question 2. In 2014, there were 161,809,242 females in the U. S. How many females
OTT
Focus
B0