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

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'?

Accepted Answer

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

Answer

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?

Accepted Answer

SmartArt Hierarchy diagram

Answer

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?

Accepted Answer

Data Labels

Answer

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?

Accepted Answer

Only the width of the selected column changes

Answer

Dragging a column border in Word adjusts only that specific column's width, which may affect adjacent column widths depending on settings.

MCAS - Microsoft Certified Application Specialist Practice Test