MCAS Charts, Tables & Visual Data 2 — Questions and Answers
Question 1: In Microsoft Word, which feature allows you to perform simple calculations on numbers within a table?
- Table Styles
- Formula (Insert > Table Tools > Layout > Formula) (Correct answer)
- Quick Tables
- AutoSum in Insert tab
Correct answer: Formula (Insert > Table Tools > Layout > Formula)
The Formula option under Table Tools > Layout lets you insert formulas like =SUM(ABOVE) to calculate values in table cells.
Question 2: In Excel, what does it mean to 'format a range as a table'?
- It merges all selected cells into one
- It converts the range into a structured table with automatic filtering, styling, and dynamic range management (Correct answer)
- It locks the cells so they cannot be edited
- It creates a pivot table from the selected data
Correct answer: It converts the range into a structured table with automatic filtering, styling, and dynamic range management
Formatting as a table gives the range automatic filter drop-downs, banded row styling, and the ability to reference the table by name in formulas.
Question 3: In PowerPoint, which feature would you use to represent organizational hierarchy visually?
- WordArt
- SmartArt Hierarchy diagram (Correct answer)
- Chart > Bar
- Linked Excel table
Correct answer: SmartArt Hierarchy diagram
SmartArt Hierarchy diagrams are designed specifically to show organizational structures and reporting relationships.
Question 4: In Excel, which chart element displays the actual numeric values next to each data point or bar?
- Axis Labels
- Data Labels (Correct answer)
- Gridlines
- Data Table
Correct answer: Data Labels
Data Labels are annotations added directly to chart data points or bars showing their exact numeric values.
Question 5: When you resize a table in Microsoft Word by dragging a column border, what changes?
- The entire table is scaled proportionally
- Only the width of the selected column changes (Correct answer)
- All columns automatically equalize their widths
- The text font size inside the column adjusts automatically
Correct answer: Only the width of the selected column changes
Dragging a column border in Word adjusts only that specific column's width, which may affect adjacent column widths depending on settings.
Question 6: In Excel, what is the purpose of a secondary axis in a chart?
- To add a second title to the chart
- To plot a data series with a different scale on the right side of the chart (Correct answer)
- To create a second chart on the same sheet
- To show negative values below the x-axis
Correct answer: To plot a data series with a different scale on the right side of the chart
A secondary axis allows you to plot a data series using a separate scale on the right side, useful when series have vastly different value ranges.
MCAS Charts, Tables & Visual Data 2
In Microsoft Word, which feature allows you to perform simple calculations on numbers within a table?