FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

MODIFYING PAGE SETUP PROPERTIES IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
A ____ indicates the general pattern of a data series.
A
Sparkline
B
Trendline
C
Narrowline
D
Gridline
E
None
Explanation: 

Detailed explanation-1: -A trendline, also referred to as a line of best fit, is a straight or curved line in a chart that shows the general pattern or overall direction of the data.

Detailed explanation-2: -A linear trendline is a best-fit straight line that is used with simple linear data sets. Your data is linear if the pattern in its data points resembles a line. A linear trendline usually shows that something is increasing or decreasing at a steady rate.

Detailed explanation-3: -A trendline is a line superimposed on a chart revealing the overall direction of the data. Google Charts can automatically generate trendlines for Scatter Charts, Bar Charts, Column Charts, and Line Charts. Google Charts supports three types of trendlines: linear, polynomial, and exponential.

Detailed explanation-4: -A trendline is most accurate when its R-squared value (R-squared value: A number from 0 to 1 that reveals how closely the estimated values for the trendline correspond to your actual data. A trendline is most reliable when its R-squared value is at or near 1.

There is 1 question to complete.