Help Save & Exit Submit When constructing a quick review table in Excel, knowing the formula...

Transcribed Image Text:

Help Save & Exit Submit When constructing a quick review table in Excel, knowing the formula is essential in populating the cells correctly. Using the Holts exponential smoothing method, complete the following table for Year 4 where a = 0.1 and B = 0.2. Year Lt Tt Ft 1 78,000 2 89,000 70,000 11,000 3 98,000 89,900 12,780 89,000 4 98,000 ? 11,000 89,000 Multiple Choice 101,744 102,212 102,810.8 112,681.6 Help Save & Exit Submit When constructing a quick review table in Excel, knowing the formula is essential in populating the cells correctly. Using the Holts exponential smoothing method, complete the following table for Year 4 where a = 0.1 and B = 0.2. Year Lt Tt Ft 1 78,000 2 89,000 70,000 11,000 3 98,000 89,900 12,780 89,000 4 98,000 ? 11,000 89,000 Multiple Choice 101,744 102,212 102,810.8 112,681.6