USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
click on the number of employees by year chart, click on the chart elements button (+), select trendline, check linear forecast
|
|
|
click on the number of employees by year chart, click on the chart elements button (+), select legends, check linear forecast
|
|
|
click on the number of employees by year chart, click on the chart elements button (+), check linear forecast
|
|
|
none of the above
|
Detailed explanation-1: -Forecasting with the Trend line Click on your line graph. Choose the trend line (Linear or Exponential). Right Click the Trend line, Choose Format Trend line. Under Forecast choose the number of the period into the future you want to forecast.
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: -The TREND function can calculate both current and future trends. The FORECAST function is used as a regular formula and returns a single new y-value for a single new-x value.