Data Visualization | MCQs

Explanation

A PivotTable is a powerful tool to calculate, summarize, and analyze data

Additional Information:

A data table is a range of cells in which you can change values in some of the cells 

Explanation

The current active cell can be identified as being the one that has a darker black border around it.

Explanation

Conditional Formatting highlights data based on rules, making patterns easy to spot.

It provides visual cues like colors or icons to quickly understand data trends.

Explanation

A bar chart or bar graph is a chart or graph that presents categorical data with rectangular bars with heights or lengths proportional to the values that they represent.

The bars can be plotted vertically or horizontally.

A vertical bar chart is sometimes called a column chart

**** 

RY19012023

Explanation

In Conditional Formatting we cannot set condition to look for Bold and apply Italics on them.

Explanation

Any process of arranging items systemically

Explanation

A bar chart or bar graph is a chart or graph that presents categorical data with rectangular bars with heights or lengths proportional to the values that they represent. The bars can be plotted vertically or horizontally. A vertical bar chart is sometimes called a column chart

**** 

RY19012023

Explanation

A scatter plot is a type of graph used in Exploratory Data Analysis (EDA) to visualize the relationship between two continuous variables. It displays the data points as points on a coordinate grid, with the x-axis representing one variable and the y-axis representing the other.

The primary purpose of a scatter plot is to:

• Show the strength and direction of the relationship between the two variables
• Identify patterns, correlations, or outliers in the data
• Help identify potential relationships that may not be immediately apparent from looking at individual variables

Scatter plots are particularly useful for:

• Identifying linear or non-linear relationships
• Identifying clusters or groups in the data
• Identifying outliers or anomalies

Explanation

When there is no data in in the adjacent cells, long text flows into adjacent cells on a worksheet.

Explanation

If we need to remove only the formatting done in a range, we must use From Edit menu choose Clear and then Formats.