FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

HOW TO USE THE CONCATENATE FUNCTION IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
What chart has vertical bars representing spreadsheet values.
A
column
B
line
C
pie
D
scattered
Explanation: 

Detailed explanation-1: -Bar charts usually present categorical variables, discrete variables or continuous variables grouped in class intervals. They consist of an axis and a series of labelled horizontal or vertical bars. The bars depict frequencies of different values of a variable or simply the different values themselves.

Detailed explanation-2: -This chart type creates a vertical bar graph, which Excel refers to as a Column chart. If you want to create a horizontal bar graph, choose the Bar chart type. Click Next when you are done. Confirm that your Data Series are in Columns in your spreadsheet.

Detailed explanation-3: -Vertical bar chart consists of rectangular bars that represent the changes over a period of time or for comparing data values of some objects. This simple bar chart displays the revenue a company gets selling its products.

Detailed explanation-4: -A histogram is a graph that shows the frequency of numerical data using rectangles. The height of a rectangle (the vertical axis) represents the distribution frequency of a variable (the amount, or how often that variable appears).

Detailed explanation-5: -Both charts compare two or more values. However, the difference lies in their orientation. A bar chart is oriented horizontally, whereas a column chart is oriented vertically.

There is 1 question to complete.