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]
Which is true about trendlines?
A
They can be added to 3D charts
B
They can be added to pie charts.
C
They can be used to predict future values
D
They correspond directly to data in the spreadsheet
Explanation: 

Detailed explanation-1: -Trendlines can be used to predict future expenses (for example, term bill prices), business sales, population growth, climate, or anything else that has a numeric value. This makes them a very useful tool because they can help us make decisions about the future.

Detailed explanation-2: -Which of the following statements about trend lines is true? → A trend line shows the general patterns of the data, but does not try to connect all the data points.

Detailed explanation-3: -A trendline helps technical analysts determine the current direction in market prices. Technical analysts believe the trend is your friend, and identifying this trend is the first step in the process of making a good trade. To create a trendline, an analyst must have at least two points on a price chart.

Detailed explanation-4: -Trendlines are used commonly by traders who seek to ensure that the underlying trend of an asset is working in favor of their position. Trendlines can be used effectively by traders to gauge potential areas of support/resistance, which can help to determine the likelihood that the trend will continue.

There is 1 question to complete.