Instructions: STEPI Clear All Formating in cells B1 and CI (Found above under the "editing" tab) Insert TODAY and NOW functions in Cells Bl and CI, Format Today as Long Date and Format Now as time. - If today is showing as situated" try adjusting the column width** STEP 2 In Column E (Flop or Sucess?) Using the IF function to show the movie as either Sucess or Flop In order for a Movie to be consider a 'Sucess' it must have generated GREATER THAN">" or EQUAL TO-300 Million Dollars in Profit (300,000,000) Use the following format to enter and IF Function: IF(Enter Logical Test here. "Value if True","Value if False") Logical test can take many forms, for our example we want to test if a number is Greater than or Equal to 300,000,000 Copy and paste (with formating) and apply the function to the entire column, this should label cach movie as either Sucess or Flop STEP 3 Using the SUMIF Function, som all of the movies that are Flops and all of the movies that are sucesses in the appropriate cells that I've labeled for you. the SUMIF Function takes the following form for our example: SUMIF(Range, "Criteria") STEPS Use the Conditional Formating Tool under the Tables tab to Highlight all cells in Colmun D Greater than 300,000,000 as Light Green and all these Less than as Light Red STEP 6 Use the COUNTIF function to count the number of flops and successes in column E - the COUNTIF Function takes the following form: -COUNTIF(Range, "Criteria") Flop or Sucess? 629,436,184 346,080,025 INSERT TODAY FUNCTION INSERT NOW Date and Time FUNCTION (FORMAT (FORMAT AS LONG DATE) AS TIME) Movie Badget (5) World Gross (5) Profit Spider-Man 3 258,000,000 887,436,184 King Kong (2005) 207,000,000 553.000,025 Superman Returns 204,000,000 391,081,192 Spider-Man 2 200,000,000 784,024,485 Titanic 200,000,000 1.835,400,000 Chronicles of Narnia, The 180,000,000 748,806,957 Wild Wild West 175,000,000 217,700,000 Evan Almighty 175,000,000 120.698,890 Waterworld 175,000,000 264, 246,220 Terminator 3: Rise of the Machines 170,000,000 433,058,296 Polar Express, The 170,000,000 296,596,043 Van Helsing 170,000,000 300.150.546 Shrek the Third 160,000,000 733,012,359 Poseidon 160,000,000 181.674.817 Alexander 155,000,000 167,297,191 Pearl Harbor 151,500,000 450.500.000 Harry Potter and the Goblet of File 150,000,000 892,213,036 Harry Potter and the Order of the Phoenix 150,000,000 822.828,538 Mission: Impossible III 150,000,000 397,301,348 TROY 1.50.000.000 497,298 577 187,081,192 584,024,485 1,635,400,000 568,806,957 42,700,000 -54,301,110 89.246,220 263,058,296 126,596,043 130,150,546 573.012.359 21.674.817 12.297.191 299.000.000 742,213,036 672.828.538 247,501,348 347.298.577 Smakers Sumo Sus