What action should be taken to create sparklines for a specific data range in Excel? a. Highlight the data and press Enter b. Use the Sparkline Wizard c. Click: Insert -> Sparklines -> Select the Sparkline type d. Manually enter data in the Sparkline Dialogue
How can you access the Sparkline Dialogue in Excel? a. Click: Insert -> Sparklines -> Choose Sparkline type b. Click: Data -> Sparklines -> Pick the Sparkline type c. Click: View -> Sparkline Dialogue d. Press Ctrl + S shortcut keys
Why are sparklines recommended for visually representing two-dimensional data with a large number of rows? a. They simplify data representation b. They automatically set Maximum and Minimum bars c. They handle limited data efficiently d. They integrate with external charting tools