1. The main purpose of charts in Excel is to:
(A) Perform complex calculations
(B) Summarize and present data visually
(C) Format cells with colors
(D) Validate data entry
2. Which tab in Excel contains the option to insert charts?
(A) Insert
(B) Home
(C) Data
(D) Review
3. Which type of chart is best used to compare parts of a whole?
(A) Line Chart
(B) Column Chart
(C) Pie Chart
(D) Bar Chart
4. Which chart is most suitable for showing trends over time?
(A) Line Chart
(B) Pie Chart
(C) Column Chart
(D) Area Chart
5. Which type of chart is best for comparing quantities across different categories?
(A) Pie Chart
(B) Scatter Chart
(C) Line Chart
(D) Bar/Column Chart
6. What is the horizontal axis of a chart called in Excel?
(A) Value Axis
(B) Category Axis
(C) Data Series
(D) Legend
7. What is the vertical axis of a chart called in Excel?
(A) Value Axis
(B) Category Axis
(C) Data Labels
(D) Title Axis
8. The part of a chart that explains the meaning of colors, patterns, or symbols is called:
(A) Axis
(B) Gridlines
(C) Legend
(D) Data Series
9. In Excel, data labels in a chart are used to:
(A) Show page numbers
(B) Apply formatting
(C) Display exact values on chart elements
(D) Create hyperlinks
10. Which option is used to switch data between rows and columns in a chart?
(A) Chart Layout → Switch Row/Column
(B) Format Painter
(C) Page Layout → Orientation
(D) Data Validation