text: **Using Quick Analysis Tools With Live**
  **Preview**
  
  Most of the***Quick Analysis***tools in the 
  ***Quick Analysis***gallery provide a Live 
  Preview of the changes in the worksheet 
  when you point to an option. 
  This is very useful if you are not sure of the 
  formatting or type of analysis you require as it 
  provides you with a preview of what the data 
  would look like if you selected that specific 
  option. 
  At the right we have selected only the totals 
  from the worksheet shown above. We have 
  pointed to options from the***TOTALS***tab (*%*
  *Total*and*Average*) and from the 
  ***FORMATTING***tab (*Data Bars*). 
  Live Preview has either presented another 
  row of analysed data or has formatted the 
  selection accordingly. 
  All of these tools are also available on the 
  ribbon but using the***Quick Analysis***tools is 
  much quicker. 