Introduction to Excel
Formatting and Graphs
Login to blackboard and download the spreadsheet and tutorial notes from the tutorials section of BN1160.
Do not run the files from within blackboard but save them to your drive as you need all the Excel functions to do the exercise.
Formatting in Excel (Point 1 on the Formatting sheet)
In Excel cells can be formatted to enhance the appearance and improve the clarity of the spreadsheet.
* Go to Format Cells by right clicking on the mouse and choosing the ‘Format Cells…’ option)
Figure 1 – Format Cells Dialog Window | * The Format Cells Dialog Window will appear on your screen (see Figure 1) * You can now format the different characteristics of the cells – in this task you are concerned with turning the “Bank Proposal” into a business document, therefore you will need to: * Make the heading distinct from the data using Font, Border and Patterns * Ensure suitable alignment of headings (centred etc) and of currency data (right justified) using Alignment * Format the Interest % figure using Number/Percentage * Format the cells with monetary value figures using Number/Currency, e.g. to show £ symbol and negative figures in red |
The cell is the basic functioning unit of organisms in which chemical reactions take place. These reactions involve an energy release needed to support life and build structures. The cell consists of membrane bound organelles, which are responsible for the division of labour. There are two main classes of cells- Prokaryotes which are cells without a nucleus, where the DNA is spread around the ...
Creating Charts in Excel (Point 2 on the Formatting sheet)
Charts are useful for presenting data in presentations or reports so the trend of data is visible to the audience/reader.
* Highlight the cells you wish to chart (months and cumulative balance) – left click on mouse and drag mouse over month cells, press Ctrl on keyboard and left click on mouse and drag mouse over cumulative balance cells
* Choose the ‘Insert’ tab
* Step 1 – choose a sensible graph type from the Charts section * Step 2 – choose ‘select data’ from the Data section and ensure that your x-axis labels are months taken from row 5 of the spreadsheet * Step 3 – Edit Titles (label x and y axis as well), Axes, Gridlines, Legends (no need for legend as only one data series shown on graph), Data Labels and Data Table accordingly * Colours etc can be formatted by double-clicking on them within the chart |
* Line Graphs in Excel (Line graph sheet)
* There are different types of Line Graph that can be used to representing time series data on the X-axis.
* Have a look at the different line charts by selecting the ‘change chart type’ from the ‘type’ section of the menu (figure 3)
* Work through the tasks listed on the Line graph sheet
Figure 3 – Change Chart Type Window | |
Pie Charts in Excel (Pie chart sheet)
* There are different types of Pie Chart that can be used to represent percentage and proportion data. * Have a look at the different pie charts by selecting the ‘change chart type’ from the ‘type’ section of the menu (figure 3).
* Work through the tasks listed on the Pie chart sheet. | |
Bar Charts in Excel
* There are different types of Bar Chart that can be used to represent a wide range of data.
* Have a look at the different bar charts by selecting the ‘change chart type’ from the ‘type’ section of the menu (figure 3).
Based on the information in Table 2, what patterns do you observe? Based on the information in Table 2, the patterns that I observe is that wherever there are fish, there is dissolved oxygen. The more fish there are, the more dissolved oxygen there is. Since fish are living organisms that need oxygen to survive, there is always going to dissolved oxygen in the water when fish are present. 2. ...
* Work through the tasks listed on the Bar chart sheet.
| | |
* Don’t Forget – Excel has an extensive Help facility if you require more information about charts etc.
E.g. Click on Help and then type “line chart” – Excel has information about creating line charts.