MCAS Charts, Tables & Visual Data 1 — Questions and Answers
Question 1: In Microsoft Excel, which chart type is best suited for showing trends over time with continuous data?
- Bar chart
- Line chart (Correct answer)
- Pie chart
- Scatter chart
Correct answer: Line chart
Line charts are ideal for displaying trends over continuous time periods because the connected points show the direction of change.
Question 2: In Excel, what must you do before creating a chart from worksheet data?
- Format all cells as percentages
- Select the data range you want to include in the chart (Correct answer)
- Sort the data in ascending order
- Apply a table style to the data
Correct answer: Select the data range you want to include in the chart
You must first select the data range so Excel knows which values to plot in the chart.
Question 3: Which type of chart is most appropriate for displaying the percentage contribution of each category to a whole?
- Clustered column chart
- Pie chart (Correct answer)
- Line chart
- Bubble chart
Correct answer: Pie chart
Pie charts display each category as a slice of the whole circle, making proportions and percentages easy to visualize.
Question 4: In Microsoft Word, how do you insert a table with a specific number of rows and columns?
- Home tab > Styles > Table
- Insert tab > Table > Insert Table (specify rows and columns) (Correct answer)
- Page Layout > Columns > More Columns
- View > Table Options
Correct answer: Insert tab > Table > Insert Table (specify rows and columns)
The Insert tab contains the Table command where you can use 'Insert Table' to specify exact row and column counts.
Question 5: In an Excel chart, what is the 'Legend' used for?
- To provide a title for the entire chart
- To identify the data series represented by different colors or patterns (Correct answer)
- To display the source data range of the chart
- To add annotations to specific data points
Correct answer: To identify the data series represented by different colors or patterns
The legend is a key that identifies each data series in the chart by associating colors or patterns with series names.
Question 6: In Excel, how do you change the chart type of an existing chart?
- Delete the chart and create a new one
- Right-click the chart and select 'Change Chart Type' (Correct answer)
- Double-click a data point to open chart settings
- Use Format > Chart > Type from the menu bar
Correct answer: Right-click the chart and select 'Change Chart Type'
Right-clicking an existing chart provides the 'Change Chart Type' option to switch to a different chart style without recreating it.
MCAS Charts, Tables & Visual Data 1
In Microsoft Excel, which chart type is best suited for showing trends over time with continuous data?