Question: Using the data in the file named Toysrusformat.xlsx, highlight in red all quarters for which revenue has increased over at least the last two quarters.
Using the data in the file named Toysrusformat.xlsx, highlight in red all quarters for which revenue has increased over at least the last two quarters. Highlight all fourth quarter revenues in blue and first-quarter revenues in red.

1 Year 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 1899 17 20 21 222 A 23 24 1997 1997 1997 1997 1998 1998 1998 1998 1999 1999 1999 1999 2000 2000 2000 2000 2001 2001 2001 2001 2002 2002 B Quarter C Sales 1 2 $1,738.00 3 $1,883.00 4 $4,868.00 1 $1,924.00 2 $1,989.00 3 $2,142.00 4 $4,383.00 1 $2,043.00 2 $2,020.00 3 $2,171.00 4 $4,338.00 1 $2,186.00 2 $2,204.00 3 $2,465.00 4 $5,027.00 1 $2,319.00 2 $1,994.00 3 $2,220.00 4 $4,799.00 1 $2,061.00 2 $2,021.00 D E F G H Highlight all fourth-quarter revenues in blue and first-quarter revenues in red.
Step by Step Solution
3.44 Rating (151 Votes )
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
