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 uses a point on a grid connected by lines to represent the spreadsheet values:
A
column
B
line
C
pie
D
scattered
Explanation: 

Detailed explanation-1: -A line chart (aka line plot, line graph) uses points connected by line segments from left to right to demonstrate changes in value.

Detailed explanation-2: -A scatter chart has two value axes: a horizontal (x) and a vertical (y) value axis. It combines x and y values into single data points and shows them in irregular intervals, or clusters. Scatter charts are typically used for showing and comparing numeric values, like scientific, statistical, and engineering data.

Detailed explanation-3: -The line chart is a simple, two-dimensional chart with an X and Y axis, each point representing a single value. The data points are joined by a line to depict a trend, usually over time.

Detailed explanation-4: -Line chart. A line graph is commonly used to display change over time as a series of data points connected by straight line segments on two axes. The line graph therefore helps to determine the relationship between two sets of values, with one data set always being dependent on the other set.

Detailed explanation-5: -Charts are used to display series of numeric data in a graphical format to make it easier to understand large quantities of data and the relationship between different series of data. Excel supports many types of charts to help you display data in ways that are meaningful to your audience.

There is 1 question to complete.