MCAS Charts, Tables & Visual Data 3

Question 1

In Microsoft Word, how do you merge two or more cells in a table into a single cell?

Accepted Answer

Select the cells, then use Table Tools > Layout > Merge Cells

Answer

The Merge Cells button is located in the Table Tools > Layout tab after selecting the cells you wish to combine.

Question 2

In Excel, which chart type shows the relationship (correlation) between two sets of numeric data?

Accepted Answer

XY Scatter chart

Answer

An XY Scatter chart plots individual data points based on two numeric variables, making correlations and distributions visible.

Question 3

In PowerPoint, which command on the Insert tab is used to add a spreadsheet-style grid for numeric data in a slide?

Accepted Answer

Table

Answer

Insert > Table adds a grid of rows and columns directly onto a PowerPoint slide for displaying structured data.

Question 4

In Excel, what does the 'Switch Row/Column' button do in the Chart Design tab?

Accepted Answer

Transposes which data is plotted on the X-axis versus the data series

Answer

Switch Row/Column swaps what is treated as data series versus category axis, reinterpreting the same data in a different orientation.

Question 5

In Microsoft Word, which option lets you sort the rows of a table alphabetically based on a specific column?

Accepted Answer

Table Tools > Layout > Sort

Answer

The Sort button in Table Tools > Layout allows you to sort table rows alphabetically or numerically by a chosen column.

MCAS - Microsoft Certified Application Specialist Practice Test