Question: excel please help! Use an Excel function to find the three longest film run-times (film_length). Enter the formula in J19 of the table Fill the


Use an Excel function to find the three longest film run-times (film_length). Enter the formula in J19 of the table Fill the formula down. For full credit, if the value of k in the table changes, the film length should automatically update. For example, if I enter 5, the formula should return the 5th longest film_length. Also, the cell references should be such that dragging the formula from J19 to J20 and 21 returns the correct results for the corresponding k-value in column I. Sort the film table by shortest film_length (shortest length at the top of the list). After the list is sorted, use an Excel function to pull back the title of the 3rd movie in the list Enter the function in cell 126. A B D G Film table film_id 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 title 2 ACE GOLDFINGER 4 AFFAIR PREJUDICE 5 AFRICAN EGG 13 ALI FOREVER 17 ALONE TRIP 19 AMADEUS HOLY 21 AMERICAN CIRCUS 22 AMISTAD MIDSUMMER 39 ARMAGEDDON LOST 50 BAKED CLEOPATRA 53 BANG KWAI 57 BASIC EASY 67 BERETS AGENT 79 BLADE POLISH 80 BLANKET BEVERLY 86 BOOGIE AMELIE 90 BOULEVARD MOB 91 BOUND CHEAPER 102 BUBBLE GROSSE 105 BULL SHAWSHANK 114 CAMELOT VACATION 116 CANDIDATE PERDITION 118 CANYON STOCK 127 CAT CONEHEADS 131 CENTER DINOSAUR 133 CHAMBER ITALIAN 139 CHASING FIGHT 146 CHITTY LOCK 151 CINCINAITI WHISPERER 155 CLEOPATRADEVIL rating special_features category G Trailers, Deleted Scer Horror G Commentaries, Behit Horror G Deleted Scenes Family PG Deleted Scenes, Behl, Horror R Trailers, Behind the S Music PG Commentaries, Dele Action R Commentaries, Behit Action G Commentaries, Behil New G Trailers Sci-F G Commentaries, Behit Family NC-17 Commentaries, Dele Family PG-13 Deleted Scenes Travel PG-13 Deleted Scenes Action + PG-13 Trailers, Behind the Drama G Trailers Family R Commentaries, Behid Music R Trailers New PG Behind the Scenes Classics R Trailers, Commentar Sports NC-17 Deleted Scenes Action NC-17 Trailers, Commentar Sci-Fi R Deleted Scenes, Behl Classics R Trailers, Deleted Scer Animation G Commentaries, Delet Comedy PG Deleted Scenes Classics NC-17 Trailers Music PG Trailers, Commentar Family G Commentaries Drama NC-17 Deleted Scenes Sci-Fi PG-13 Trailers, Deleted Scer New P.12 Trailers Dolce Ser Animation film length 48 117 130 150 82 113 129 85 99 182 87 90 77 114 148 121 63 98 60 125 61 70 85 112 152 1171 114 107 143 150 65 co ARTITI Top k film_length k Film Length 1 2 3 Nm What is the title of the 3rd shortest movie by film_length? Answer this after sorting the list by film_length from low to high +
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
