FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
You should use a ____ chart to compare values side by side, broken down by category.
A
Column
B
Bar
C
Line
D
Clustered Column
Explanation: 

Detailed explanation-1: -Column Chart: Column charts are typically used to compare several items in a specific range of values. Column charts are ideal if you need to compare a single category of data between individual sub-items, such as, for example, when comparing revenue between regions.

Detailed explanation-2: -Clustered column charts are a type of graph used to compare data sets. They are perfect for visualizing data that is grouped into categories. Clustered column charts are often used to compare sales figures or other data that change over time.

Detailed explanation-3: -Use bar charts to show comparisons among individual items. Bar charts have the following chart subtypes: Clustered bar and 3-D Clustered bar chart Compares values across categories. In a clustered bar chart, the categories are typically organized along the vertical axis, and the values along the horizontal axis.

Detailed explanation-4: -Combo charts can be defined as dual-axis charts that come with a secondary Y-axis to allow users to compare two different sets of data against a single dataset.

There is 1 question to complete.