Excel Exercise Assignment

                                            Excel Exercises

Create a spreadsheet with 3 tabs, 1 for pie chart, 1 for line chart and 1 for bar chart.

Tab 1 Pie Chart. A monthly budget of your expenses.

Tab 2 Line Chart. A spreadsheet of 1 month of stock data from yahoo finance of any stock you choose

Tab 3 Bar Chart. Task for any project you wish to work on..

Tab 1. Create a monthly budget and build a pie chart.

Personal Budget : Students build a monthly financial budget.

Calculate the percent within the spreadsheet cell Percentage of Total

Percentage = (Part ÷ Whole) × 100 

E.g. Rent Percentage = (1200 / 2200) x 100

Note: the 2200 is the sum of all expenses

Round cell to 1 decimal point

Pie chart

Here is the underlying dataset used to generate the pie chart example above:

Note use your own data and calculate your own percentages

Category	Amount ($)	Percentage of Total
Rent	$1,200	54.5%
Food	$450	20.5%
Utilities	$200	9.1%
Entertainment	$200	9.1%
Transport	$150	6.8%
Total	$2,200	100.0%

Select graph area 

Insert

Then click on pie chart which is the circle

Tab 2. Pick a stock and pull data for a 30 day period for volume and price.

Pull data from Yahoo Finance

Enter symbol at top of page e.g. MSFT

Go to Historical Data tab

Highlight 1 month of data and copy

Paste into spreadsheet and only keep Date, Close and Volume columns by deleting other columns.

Spreadsheet contains latest Microsoft date, price and volume data

Line graph of price

Highlight columns you wish to chart

Click on line graph icon

select two non-adjacent columns in Excel, use the following steps:

Select the first column: Click the column letter at the very top of the first column you want (for example, click A).

Hold the modifier key:

Windows: Press and hold the Ctrl key.

Mac: Press and hold the Command (⌘) key.

Select the second column: While holding the key, click the column letter of the second column (for example, click

Insert both charts on tab

Tab 3  Bar Chart

To create a simple bar chart in Excel, all you need is a basic two-column table. Here is an easy, 3-step example:

Type Out Your Data

Create a small table with categories in the left column and numbers in the right column. For example, let's track weekly hours spent on different tasks:

Task	Hours
Planning	5
Coding	12
Testing	8
Meetings	4

Highlight and Insert

Highlight your entire table (including the headers).

Go to the Insert tab on the top Excel ribbon.

Click the Insert Column or Bar Chart icon (it looks like vertical or horizontal bars).

Choose the very first option under 2D Bar or 2D Column (Clustered Bar).

 Clean It Up 

Once the chart pops up on your screen:

Click on the Chart Title at the top to rename it (e.g., Weekly Hours).

Click the Plus sign (+) next to the chart to quickly add or remove elements like Data Labels (to show the exact numbers right on the bars).

That's it! Excel instantly translates your table into a visual chart.

In one of your tabs hit file

Then share

Share spreadsheet  to john.iacovacci@uconn.edu