10.30.5
- 1. What is conditional formatting, and how is it used in dashboards?
- 2. How can you link slicers to multiple pivot tables or charts?
- 3. What is the purpose of using timeline slicers in dashboards?
- 4. How do slicers help in filtering data in charts and dashboards?
- 5. What are the key elements of an effective dashboard layout?
- 6. What is a dashboard in Excel?
- 7. How can pivot charts help in data analysis?
- 8. How can you create a pivot chart from a pivot table?
- 9. What are pivot charts, and how are they different from regular charts?
- 10. How do you format chart colors, fonts, and styles?
- 11. How do you add or remove chart elements such as titles, labels, and legends?
- 12. How can you change the data range of an existing chart?
- 13. How can you insert a chart in Excel?
- 14. What is a scatter plot and when is it useful?
- 15. When would you use a pie chart in Excel?
- 16. How is a line chart different from an area chart?
- 17. What is the difference between a column chart and a bar chart?
- 18. How do you choose the right chart type for your data?
- 19. What are the common types of charts available in Excel?
- 20. What is the purpose of using charts in Excel?