Exam 77-420 Microsoft Excel 2013 2. Create Cells and Ranges 2.3 Order and Group Cells and Ranges: Insert Sparklines

Insert -> Sparklines -> Line Add Some Spark Microsoft Excel has a new feature called Sparklines. A Sparkline is a little chart that helps people see the trends. It is another way of picturing the data.   1. Try This: Add a Sparkline Select Cell A2. Go to Insert -> Sparklines. Click on Line.   You will be asked to select the Ranges: Data Range: B4:B12 Location Range: $A$2. Click OK.   Keep going...   What If It Doesn't Work? Look at the Location Range. You may have noticed that the Location Range was listed as $A$2:$B$2. You need to correct this or you may receive an error message about an invalid Range.