Create a forecast sheet based on range a1 b4 – Forecasting plays a pivotal role in decision-making, and the creation of a forecast sheet based on a specified range of…