G $ 12 0D 9 . B INSERT TODAY INSERT NOW FUNCTION (FORMAT FUNCTION 1 AS LONG DATE) [FORMATAS TIME) 2 Budget ($) World Gross ($) Profit Flop or Sucess? 3 $ 25,80,00,000.00 $ 88,74,36,184.00 ############# 4 20.70,00,000.00 $ 55,30,80,025.00 ############# 5 20,40,00,000.00 $ 39,10,81,192,00 $ 18,70,81.192.00 6 20.00.00.000,00 $ 78,40,24 485.00 ########### 7 $ 20.00.00.000,00 **************** #************ 8 $ 18.00.00.00000 $ 74 88.06.957.00 ##### 9 $ 17.50.00.000.00 $ 21,77,00,000.00 $427.00,000.00 10 $ 17.50.00,000.00 12,06,98.890.00 $15.43 01:110.00) 11 $ 17,50,00 000.00 26.42.46.220.00 $8 92.46.220.00 12 $ 17.00.00.000.00 $ 43.30,58 296.00 ############ 13 $ 17.00,00.000,00 29.65.96043.00 ######## 14 17,00.00.000,00 30.01.50,546.00 $13.01.50,546.00 $ 16,00,00.000,00 73.30. 12. 359.00 ######## $ 16.00.00.000.00 18, 16,74 817.00 216.7.817.00 $ 15.50.00.00000 16.72.97. 19100 $ 122 97 191.00 $ 15.15.00,000.00 $ 45,05,00 000 00 ###### 15 00 00,000.00 $ 89.22.13.036 00 $ 15,00,00,000.00 82.28.28.538.00 ### $ 1500,00,000.00 $ 39,75 01348.00 ###### 22 $ 15,00,00,000.00 $ 49.72 98.577.00 ###### $ 2.&& Sum of Flops Sum of Sucesses #of Flops and Successes Instructions: STEP 1 Clear All Formating in cells Bland CHI Found above under the "editing tab) Insert TODAY and NOW functions in Cells Bland Cl. Format Today as Long Date and Format Now as time -If todwis showing a adusting the column width STEP 2 In Column E/Flop Sucent Using the function to show the movie as the Sucess of Flop In order for Movie to be considera Sudest'it must have generated GREATER THAN EQUAL TO-300 Million Dolls in Profit (300,000,00011 Use the following format to enter and IF Function IFE Logical Testhere,"Value True Value False" Logical testcantake many forms for our example we want to test a number is Greater than or Equato 300.000.000 Copy and paste with formating and apply the function to the entire column, this should labeleach movie as either Sucess or Flop STEP 3 Using the SUMIF Function sur 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 SUMIFIRange. "Criteria") STEP 5 Use the Conditional Formating Tool under the Tables tab to Highlight all cells in Comun Greater than 300,000,000 as Light Green and all those Less than as Light Red STEP 6 Use the COUNTIF function to count the number of flops and successes incolumn E - the COUNTIF Function takes the following form: - COUNTIF(Range "Criteria") TALVETE WWS