DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
column
|
|
line
|
|
pie
|
|
scattered
|
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.