FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
A bar graph compares multiple values.
A
True
B
False
C
Either A or B
D
None of the above
Explanation: 

Detailed explanation-1: -Answer: FALSE, because the graph that is useful displaying or representing the relationship between two or more measurement variables is the Scatterplot. While a bar graph is useful to represent two or more categorical variables simultaneously.

Detailed explanation-2: -A bar chart is used when you want to show a distribution of data points or perform a comparison of metric values across different subgroups of your data. From a bar chart, we can see which groups are highest or most common, and how other groups compare against the others.

Detailed explanation-3: -A bar diagram makes it easy to compare sets of data between different groups at a glance. The graph represents categories on one axis and a discrete value in the other. The goal is to show the relationship between the two axes. Bar charts can also show big changes in data over time.

Detailed explanation-4: -Double bar graph is useful for the comparison of data. Q. Bar graphs are usually used to represent ‘categorical data’ while histogram is usually used for ‘continuous data’.

Detailed explanation-5: -Multiple variable bar charts can be created from a single data file or from different data files. Typically, the X values (for vertical bars) are the same for each of the bar charts. However, the X values may be different between bar charts. When creating stacked bar charts, each row of data is considered a stack.

There is 1 question to complete.