Answer:
D. Forecast
Explanation:
The FORECAST is used to predict the future trend. This function returns a prediction of a future value based on existing values provided.
There are several sub functions within FORECAST which will help you create linear and exponential forecasts based on the inpute data provided and data can be any historical data such as sales, budgets, cash flows, stock prices, and the like.
Formula for FORECAST is as below
FORECAST( x-value, known_y_values, known_x_values )
x-value : It is the input value or the value used to predict the future value.
known_y_values : It is the known y-values used to predict the y-value.
known_x_values : It is the known x-values used to predict the y-value.
Finally FORECAST function returns the numeric value.
