Microsoft Excel 
ITTraining@sgul.ac.uk Page 38 St. George’s Information Services 
PRACTICE EXERCISE 
The Quick Analysis Tools 
Tasks: Completed: 
 Before starting this exercise you MUST have completed all of the topics in 
the chapter The Quick Analysis Tools… 
 
 
Open the workbook PE_Quick Analysis.xlsx (it can be found in the same 
folder as the student files)  
 
Use the Quick Analysis tools to apply a colour scale to the data in the 
worksheet  
 
Use the Quick Analysis tools to create a chart for the Overheads data. 
This chart should be a clustered column chart that has the column 
headings as the x axis, and displays the legend at the bottom of the chart. 
Make the chart title Cost of Overheads. 
 
 
Reposition the chart below the data  
 
Use the Quick Analysis tools to create Sparklines for the Qtr1 to Qtr4 
and Total columns for Overheads 
Your worksheet should appear as shown on the following page… 
 
 
Use the Save As command to save the workbook as PE_Quick Analysis 
(Completed).xlsx 