give me proepr answer with excel sheet

Forecasting Assignment on Excel Month January February March April May June July August September October November December Yearly 1 528 270 152 345 226 182 413 118 275 165 320 220 3214 2 550 275 155 348 228 187 416 122 280 162 342 215 3280 Year-Sales in Units 3 567 280 158 359 236 192 417 127 283 171 368 240 3398 4 571 283 167 358 239 194 418 126 284 179 376 265 3460 5 600 288 170 364 242 194 418 130 291 178 400 250 3525 1. The trend line for this data is y=80.2 x + 3134.5. Determine the forecast forYear 6. 2. Given the above data what forecasting technique would be appropriate? 3. Create a forecast using the technique you recommended.