draft their own team and compete with teams built by others. Fantasy
therefore increasing their enjoyment of the game. The fans get to create their
own roster of players by draft ing talent from actual NFLŪ teams. Leagues are
usually formed with 10-14 of these fans, who become the owners/managers
of their own unique roster. A draft is held, where all the league members
get together with each other and draft 14-20 NFLŪ players. At the end of the
season, one owner emerges as the champion. Fantasy FootballŪ has been
played for over 20 years, with an esti mated six to eight million fans involved.
The following acti vity illustrates how spreadsheets can be used to calculate
the points for the top fantasy players in the 2010 NFLŪ season.
2. Type the data as shown.
3. Format the width of columns A C to 20.0 and left align.
4. Bold cell A1 and change the font size to 16 point.
6. Bold cells A5, A15, and A25.
required to round the answers to the formulas down to the nearest whole
number. The formulas for the fi rst player in each positi on are given below.