- Cla . COMP1021 FirstName_LastName_Student_A3.xlsx_e1117296514cc74faad29bfc49e9f91a - Microsoft Excel Home Insert Page Layout Formulas Data Review View X n! AutoSum - Wrap Text General Fill - .00 *Merge & Center % to Insert Delete Format Conditional Format Cell Formatting as Table Styles Styles 2 Clear Sort & Find & Filter - Select Editing Alignment Number Cells * Cut Calibri 11 - A En Copy Paste B I U Format Painter Clipboard Font H26 foc B C D E INSERT TODAY INSERT NOW FUNCTION (FORMAT FUNCTION 1 AS LONG DATE) (FORMAT AS TIME) 2 Budget ($) World Gross ($) Profit Flop or Sucess? 3 $ 25,80,00,000.00 $ 88,74,36,184.00 ############# F G H 1 Instructions: STEP 1 Clear All Formating in cells B1 and C1 (Found above under the "editing" tab) Insert TODAY and NOW functions in Cells B1 andC1, Format Today as Long Date and Format Now as time. - If today is showing as "#*****####" try adjusting the column width": 4 4 $ 5 $ 6 $ 7 $ 8 $ 9 $ 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 each movie as either Sucess or Flop 10 $ 11 $ 12 $ 13 $ 20,70,00,000.00 $ 55,30,80,025.00 ############# 20,40,00,000.00 $ 39,10,81,192.00 $ 18,70,81,192.00 20,00,00,000.00 $ 78,40,24,485.00 ############# $ 20,00,00,000.00 ############### ############# 18,00,00,000.00 $ 74,88,06,957.00 ############# 17,50,00,000.00 $ 21,77,00,000.00 $4,27,00,000.00 17,50,00,000.00 $ 12,06,98,890.00 $ (5,43,01,110.00) 17,50,00,000.00 $ 26,42,46,220.00 $8,92,46,220.00 17,00,00,000.00 $ 43,30,58,296.00 ############# 17,00,00,000.00 $ 29,65,96,043.00 ############# 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 $ 2,16,74,817.00 15,50,00,000.00 $ 16,72,97,191.00 $1,22,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 ############# 15,00,00,000.00 $ 39,75,01,348.00 ############# 15,00,00,000.00 $ 49,72,98,577.00 ############# $ STEP 3 14 15 $ Using the SUMIF Function, sum 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") 16 $ = 17 $ 18 $ 19 $ STEP 5 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 those Less than as Light Red STEP 6 20 $ 21 $ Sum of Flops Sum of Sucesses Use the COUNTIF function to count the number of flops and successes in columnE -the COUNTIF Function takes the following form: = COUNTIF(Range, "Criteria") 22 $ 23 24 25 26 # of Flops and Successes Activate Windows KI Cover sheet Assgn 3 IIII Ready "70% + o Type here to search o -7C Cloudy - o d) + 19:14 30-01-2022
