Charts, Tables & Visual Data Flashcards

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

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

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

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

Answer: XY Scatter chart

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

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

Answer: Table

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

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

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

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

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

Answer: Table Tools > Layout > Sort

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

In Excel, which feature allows you to create an interactive summary that groups and aggregates data from a larger dataset?

Answer: Pivot Table

A Pivot Table summarizes, groups, and aggregates large datasets interactively, letting you drag fields to reorganize the analysis.