Chapter 5: Charts in Excel
Section A: Multiple Choice Questions (30 Marks)
1. What is the category axis (horizontal axis) in a standard chart called?
2. What is the value axis (vertical axis) in a standard chart called?
3. The key that identifies colors, patterns, or symbols assigned to data series in a chart is called:
4. Which chart type displays data in the form of vertical bars?
5. Which chart type displays data in the form of horizontal bars?
6. Which chart type is best suited to show proportions or percentage shares of a single data series as slices of a circle?
7. Which chart type uses lines connecting data points to show trends over continuous time intervals?
8. Which chart type looks similar to a spider web and plots values relative to a central point?
9. Which chart type plots data points combining X and Y values into single coordinate data points?
10. The area bounded by the X and Y axes where the actual chart data is plotted is called the:
11. The entire area containing the chart along with all its components (title, axes, legend, plot area) is the:
12. Horizontal or vertical lines extending across the plot area to make reading values easier are called:
13. Which chart component provides additional information or exact numeric values directly on individual data markers?
14. A set of related data values plotted together in a chart (e.g., test scores of a class) is known as a:
15. Which tab on the Ribbon opens when a chart is selected to modify its layout, style, and elements?
16. Which chart type emphasizes the magnitude of change over time by filling the area below line markers?
17. Which chart type is specifically designed to illustrate fluctuations in stock prices or market trading volumes?
18. A chart placed on the same worksheet alongside the data table is known as an:
19. What keyboard function key creates an instant embedded chart from selected data in Excel?
20. What function key creates a chart on a separate Chart Sheet instantly?
21. Which chart type resembles a pie chart but contains a hollow center allowing multiple data series visualization?
22. Which chart type replaces 2D data points in scatter plots with variable-sized circular bubbles?
23. Descriptive headings placed along axes to clarify what data is being represented are called:
24. Which group under the Insert Tab contains all chart insertion commands in Excel?
25. What happens to a chart when the numerical values in its source worksheet table are edited?
26. Which button on the Chart Elements floating menu toggles numerical data tables directly beneath the chart?
27. Which chart type plots data like a topographic map on a 3D surface model?
28. To move a selected chart to a different position on a worksheet, you drag its:
29. What main title identifies the overall subject and purpose of a chart at the top?
30. The primary advantage of presenting data through charts rather than tables is that charts:
Section B: Assertion & Reason Questions (30 Marks)
Directions: Choose the correct option:
- A: Both Assertion (A) and Reason (R) are true, and Reason (R) is the correct explanation.
- B: Both Assertion (A) and Reason (R) are true, but Reason (R) is NOT the correct explanation.
- C: Assertion (A) is true, but Reason (R) is false.
- D: Assertion (A) is false, but Reason (R) is true.
31. Assertion (A): Charts make it easier to draw comparisons and analyze growth trends visually.
Reason (R): Graphical representations highlight relationships and patterns faster than dense numerical tables.
32. Assertion (A): A pie chart can comfortably display multiple data series with dozens of rows simultaneously.
Reason (R): Pie charts are restricted to visualizing proportions within a single data series.
33. Assertion (A): The Y-axis of a column chart is also known as the category axis.
Reason (R): The Y-axis displays numerical values used to measure bar heights, making it the value axis.
34. Assertion (A): Legends identify data series using specific colors, patterns, or symbols.
Reason (R): Legends assist viewers in identifying which color corresponds to which category or data set.
35. Assertion (A): Line charts are ideal for displaying continuous changes in data over time.
Reason (R): Line plots connect individual data points with line segments to highlight trends.
36. Assertion (A): Updating cell values in a worksheet permanently breaks connected charts.
Reason (R): Excel charts maintain dynamic links to source worksheet cells and update automatically.
37. Assertion (A): Bar charts present data using horizontal bars.
Reason (R): Column charts present data using vertical bars.
38. Assertion (A): An embedded chart appears on the same worksheet alongside source numbers.
Reason (R): Embedded charts enable viewing data tables and visual graphics together on one page.
39. Assertion (A): Gridlines extend across the plot area to make value estimation accurate.
Reason (R): Gridlines align plotted data markers visually with values printed on the Y-axis.
40. Assertion (A): Scatter charts connect data points using thick filled bars.
Reason (R): Scatter (XY) charts plot numeric coordinate pairs along horizontal and vertical axes.
41. Assertion (A): Doughnut charts can plot multiple data series in concentric rings.
Reason (R): Unlike pie charts, doughnut charts feature a open middle ring enabling multi-series display.
42. Assertion (A): Pressing `F11` inserts an embedded chart into the current active sheet.
Reason (R): `F11` creates a new dedicated Chart Sheet, whereas `Alt + F1` creates an embedded chart.
43. Assertion (A): Radar charts display changes in values relative to a center point.
Reason (R): Radar charts plot individual axes for each category radiating outwards from the origin.
44. Assertion (A): Chart Title provides an overall description of what the chart represents.
Reason (R): Chart Titles are placed prominently at the top of the chart frame.
45. Assertion (A): Data Labels show the exact numerical value of data points directly on the chart.
Reason (R): Data Labels remove ambiguity by displaying precise numbers on bars or pie slices.
46. Assertion (A): Plot Area encompasses the entire chart container including legends and title.
Reason (R): Plot Area strictly refers to the bounded region containing plotted graphics and axes.
47. Assertion (A): Stock charts require specific sets of data like High, Low, and Close values.
Reason (R): Stock market tracking relies on plotting fluctuating opening, closing, and extreme prices.
48. Assertion (A): Area charts fill the space beneath line series with solid colors or patterns.
Reason (R): Filling area under curves visually emphasizes the overall volume or magnitude of change.
49. Assertion (A): You cannot change the chart type once a chart is generated in Excel.
Reason (R): The 'Change Chart Type' command on the Design tab allows switching between chart styles instantly.
50. Assertion (A): Bubble charts add a third dimension of data represented by bubble size.
Reason (R): X position, Y position, and bubble diameter map three variables simultaneously.
51. Assertion (A): Axis Titles help readers understand what measurements or categories are plotted on axes.
Reason (R): Labeling axes as 'Months' or 'Sales in USD' provides essential units of context.
52. Assertion (A): Resizing handles on a chart border allow changing its height and width.
Reason (R): Dragging corner handles scales the overall chart proportionately.
53. Assertion (A): Selecting data is an optional step prior to inserting a chart in Excel.
Reason (R): Excel requires selected cell ranges to populate data series and axis labels in a chart.
54. Assertion (A): Chart Styles gallery allows switching color schemes and visual designs quickly.
Reason (R): Pre-formatted chart styles combine colors, shadows, and layouts for professional aesthetics.
55. Assertion (A): Legend position cannot be changed and stays locked at the right side of a chart.
Reason (R): Excel allows placing legends at top, bottom, left, right, or overlaying the plot area.
56. Assertion (A): Surface charts display continuous optimum combinations between two sets of data.
Reason (R): Colors and patterns indicate areas that share the same range of values like topographic maps.
57. Assertion (A): 3D Column charts add a depth visual effect to vertical bars.
Reason (R): 3D effects improve readability when analyzing complex multi-layered data arrays.
58. Assertion (A): Deleting a chart permanently removes its source numbers from the worksheet.
Reason (R): Charts are visual drawing objects linked to worksheet data without containing original cells.
59. Assertion (A): The 'Switch Row/Column' button swaps data plotted on X-axis and Y-axis.
Reason (R): Swapping rows and columns alters the chart perspective without altering source table layout.
60. Assertion (A): Charts assist decision makers in evaluating trends efficiently.
Reason (R): Graphical representation converts abstract numbers into clear visual insights.
Section C: Visual & Scenario Based Questions (10 Marks)
61. Identify the Chart Component Visual:
Horizontal Axis ➔ [ Apple | Banana | Mango | Orange ]
What is this axis titled in standard Excel charts?
62. Scenario Visual: Mohit wants to compare monthly fruit sales data visual provided by his store manager. Which chart type is best suited to compare sales volumes visually side-by-side?
63. Identify the Pie Chart Proportions Visual:
Circle Slices ➔ [ Math: 40% | Science: 30% | English: 30% ]
What does a single slice in a pie chart represent?
64. Scenario Visual: Rashmi wants to track how test scores changed across 5 consecutive monthly tests. Which chart visually tracks trends best?
65. Identify the Spider-Web Chart Layout Visual:
Axes radiating from center ➔ [ Speed | Power | Accuracy | Stamina ]
What is this specific web-like chart type called?
66. Observe the Legend Box Visual:
[ Blue Square: Term 1 Marks ] | [ Red Square: Term 2 Marks ]
Where is this color-matching key located in a chart?
67. Scenario Visual: An analyst wants to display XY data points showing student study hours vs exam percentage scores. Which chart is appropriate?
68. Identify the Chart Element Addition (+ Menu) Visual:
Checking the box for Data Labels in Excel chart elements does what?
69. Look at the Doughnut vs Pie Chart visual distinction:
Which feature allows a Doughnut Chart to plot two sets of yearly sales figures that a Pie Chart cannot?
70. Identify the Instant Chart Shortcut Visual:
Selecting table `A1:B5` and pressing `Alt + F1` creates what object on the worksheet?
No comments:
Post a Comment