MCAS Charts, Tables & Visual Data 2

Question 1

In Microsoft Word, which feature allows you to perform simple calculations on numbers within a table?

Accepted Answer

Formula (Insert > Table Tools > Layout > Formula)

Answer

Table Styles

Answer

Quick Tables

Answer

AutoSum in Insert tab

Question 2

In Excel, what does it mean to 'format a range as a table'?

Accepted Answer

It converts the range into a structured table with automatic filtering, styling, and dynamic range management

Answer

It merges all selected cells into one

Answer

It locks the cells so they cannot be edited

Answer

It creates a pivot table from the selected data

Question 3

In PowerPoint, which feature would you use to represent organizational hierarchy visually?

Accepted Answer

SmartArt Hierarchy diagram

Answer

WordArt

Answer

Chart > Bar

Answer

Linked Excel table

Question 4

In Excel, which chart element displays the actual numeric values next to each data point or bar?

Accepted Answer

Data Labels

Answer

Axis Labels

Answer

Gridlines

Answer

Data Table

Question 5

When you resize a table in Microsoft Word by dragging a column border, what changes?

Accepted Answer

Only the width of the selected column changes

Answer

The entire table is scaled proportionally

Answer

All columns automatically equalize their widths

Answer

The text font size inside the column adjusts automatically

Question 6

In Excel, what is the purpose of a secondary axis in a chart?

Accepted Answer

To plot a data series with a different scale on the right side of the chart

Answer

To add a second title to the chart

Answer

To create a second chart on the same sheet

Answer

To show negative values below the x-axis