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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Microsoft Excel Data Analysis 7th Questions!