1 What are sparklines in Excel?
a) Large charts used to display extensive data
b) Small, single-cell charts that provide a visual representation of data trends
c) Text labels used for chart descriptions
d) Formulas used for statistical analysis
Answer: b) Small, single-cell charts that provide a visual representation of data trends
2 Which option in Excel allows you to insert sparklines into a worksheet?
a) Home Tab > Charts Group
b) Insert Tab > Sparklines Group
c) Data Tab > Analysis Group
d) View Tab > Workbook Views
Answer: b) Insert Tab > Sparklines Group
3 What type of sparklines is best suited for showing data trends over time?
a) Column Sparklines
b) Line Sparklines
c) Win/Loss Sparklines
d) Pie Sparklines
Answer: b) Line Sparklines
4 How can you create a sparkline that displays positive and negative values in different colors?
a) Use the “Design” tab and select “Sparkline Color”
b) Apply conditional formatting to the cells
c) Select “Style” and then “Sparkline Color”
d) Choose “Win/Loss” sparklines and format them manually
Answer: a) Use the “Design” tab and select “Sparkline Color”
5 What does the “Show” option in the Sparkline Tools allow you to customize?
a) Data labels and chart types
b) Color schemes and gridlines
c) Markers, high points, low points, and negative points
d) Data range and chart axis
Answer: c) Markers, high points, low points, and negative points
6 If you want to display a sparkline in a cell and have it reference a range of cells, what should you do?
a) Enter the range in the “Data” field after selecting the cell for the sparkline
b) Use the “Insert” tab to specify the range directly
c) Create the sparkline and then manually enter the range in the cell
d) Use the “Data” tab to adjust the sparkline settings
Answer: a) Enter the range in the “Data” field after selecting the cell for the sparkline
7 How can you modify the style of an existing sparkline?
a) Right-click the sparkline and select “Format Sparkline”
b) Use the “Design” tab under Sparkline Tools to choose a different style
c) Change the color using conditional formatting
d) Delete the sparkline and insert a new one with the desired style
Answer: b) Use the “Design” tab under Sparkline Tools to choose a different style
8 What happens if you delete the data range used for a sparkline?
a) The sparkline will continue to display the last known data
b) The sparkline will become blank or show an error
c) The sparkline will automatically update with new data
d) The sparkline will retain the original data range
Answer: b) The sparkline will become blank or show an error
9 Which of the following is NOT a type of sparkline available in Excel?
a) Line
b) Column
c) Pie
d) Win/Loss
Answer: c) Pie
10 To apply sparklines to a range of cells, which steps should you follow?
a) Select the range for sparklines, then choose the sparkline type and data range
b) Insert the sparklines in a single cell and drag to extend
c) Create individual sparklines in each cell manually
d) Apply sparklines using conditional formatting
Answer: a) Select the range for sparklines, then choose the sparkline type and data range