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 an example of a trendline option in Excel?
A
bar
B
exponential
C
radar
D
stock
Explanation: 

Detailed explanation-1: -The exponential trendline is a curved line that illustrates a rise or fall in data values at an increasing rate, therefore the line is usually more curved at one side. This trendline type is often used in sciences, for example to visualize a human population growth or decline in wildlife populations.

Detailed explanation-2: -An exponential trendline is a curved line that is most useful when data values rise or fall at increasingly higher rates. You cannot create an exponential trendline if your data contains zero or negative values.

Detailed explanation-3: -Select the curve on the graph itself and then right-click. Click on Add Trendline. A dialog box will pop up giving you the option for plotting a curve based on different criteria. Choose EXPONENTIAL.

Detailed explanation-4: -Trendlines are used to predict possible future trends based on the know values of the past. You can choose any one of these six different trend or regression types: Linear Trendlines, Logarithmic Trendlines, Polynomial Trendlines, Power Trendlines, Exponential Trendlines, or Moving Average Trendlines.

There is 1 question to complete.