Dino Toys
2020 Annual Sales Summary
Dinosaur Quarter 1 Quarter 2 Quarter 3 Quarter 4
Stegosaurus $ 934,849.00 $ 4,959,438.00 $ 459,340.00 $ 3,948,302.00
T-Rex $ 1,150,000.00 $ 2,939,454.00 $ 304,950.00 $ 3,940,390.00
Velicioraptor $ 903,943.00 $ 495,932.00 $ 3,499,393.00 $ 7,839,393.00
Triceratops $ 493,494.00 $ 495,834.00 $ 4,994,030.00 $ 45,934,033.00
Maisaura $ 459,403.00 $ 384,392.00 $ 394,940.00 $ 3,948,372.00
Troodon $ 459,334.00 $ 382,910.00 $ 394,022.00 $ 3,829,203.00
Edmontosaurus $ 549,332.00 $ 2,938,453.00 $ 1,929,238.00 $ 3,483,920.00
Torosaurus $ 394,559.00 $ 483,823.00 $ 3,829,348.00 $ 5,044,030.00
Gigantosaurus $ 499,332.00 $ 4,953,422.00 $ 3,829,201.00 $ 8,392,039.00
Pisanosaurus $ 34,945.00 $ 484,933.00 $ 384,903.00 $ 3,847,392.00
Totals $ 5,879,191.00 $ 18,518,591.00 $ 20,019,365.00 $ 90,207,074.00
Best Selling Toy
1. On the 2020 Sales worksheet, In cells F2:F12 use
conditional formatting to apply a Yellow Fill with Dark Yellow
text to the cells that contain values greater than
$10,000,000.
ary 2. On the 2020 Sales worksheet, Perform a multi-level sort.
Sort the table by "Dinosaur" (A to Z) then by "Total Sales"
Total Sales (Largest to Smallest).
$ 10,301,929.00
3. On the 2021 Projections worksheet, enter a formula that
$ 8,334,794.00 multiplies the value in the "Quarter 4" column by the
$ 12,738,661.00 "Q3_Increase" range. Use the range in the formula instead of
$ 51,917,391.00 a cell reference or value.
$ 5,187,107.00
4. On the 2020 Sales worksheet, in cell B16, use a function to
$ 5,065,469.00 display the highest sale from the range, B3:E12.
$ 8,900,943.00
$ 9,751,760.00 5. On the Revenue Split worksheet, swap the data over the
axis.
$ 17,673,994.00
$ 4,752,173.00
$ 134,624,221.00
Dino Toys
Annual Sales Summary
Dinosaur Quarter 1 Quarter 2 Quarter 3 Quarter 4
Stegosaurus $ 934,849.00 $ 4,959,438.00 $ 459,340.00
T-Rex $ 1,150,000.00 $ 2,939,454.00 $ 304,950.00
Velicioraptor $ 903,943.00 $ 495,932.00 $ 3,499,393.00
Triceratops $ 493,494.00 $ 495,834.00 $ 4,994,030.00
Maisaura $ 459,403.00 $ 384,392.00 $ 394,940.00
Troodon $ 459,334.00 $ 382,910.00 $ 394,022.00
Edmontosaurus $ 549,332.00 $ 2,938,453.00 $ 1,929,238.00
Torosaurus $ 394,559.00 $ 483,823.00 $ 3,829,348.00
Gigantosaurus $ 499,332.00 $ 4,953,422.00 $ 3,829,201.00
Pisanosaurus $ 34,945.00 $ 484,933.00 $ 384,903.00
Totals $ 5,879,191.00 $ 18,518,591.00 $ 20,019,365.00 $ -
Quarter 4 Projection 104%
1. On the 2020 Sales worksheet, In cells F2:F12 use
conditional formatting to apply a Yellow Fill with Dark Yellow
text to the cells that contain values greater than
$10,000,000.
2. On the 2020 Sales worksheet, Perform a multi-level sort.
Sort the table by "Dinosaur" (A to Z) then by "Total Sales"
Total Sales (Largest to Smallest).
$ 6,353,627.00
$ 4,394,404.00 3. On the 2021 Projections worksheet, enter a formula that
$ 4,899,268.00 multiplies the value in the "Quarter 4" column by the
"Q3_Increase" range. Use the range in the formula instead of
$ 5,983,358.00 a cell reference or value.
$ 1,238,735.00
$ 1,236,266.00 4. On the 2020 Sales worksheet, in cell B16, use a function to
display the highest sale from the range, B3:E12.
$ 5,417,023.00
$ 4,707,730.00 5. On the Revenue Split worksheet, swap the data over the
$ 9,281,955.00 axis.
$ 904,781.00
$ 44,417,147.00
Revenue Split
Stegosaurus T-Rex Velicioraptor Triceratops Maisaura
Troodon Edmontosaurus Torosaurus Gigantosaurus Pisanosaurus
