Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please help! Am Det Punts OG G MUR TID 15 20 2 TH 2 NOT 1 15 ERLE In cell G19, use an Excel function
please help! Am Det Punts OG G MUR TID 15 20 2 TH 2 NOT 1 15 ERLE In cell G19, use an Excel function to lookup the category for each film that was rented in the rental table. The category for each film is listed in the film table. Fill the formula down so that each film_id correctly matches its film category. Add a total row to the film table. Update the total row to show the average film_length Destionar Proteinen News Part Points Tash 2 18, en bounction to the reporfor him that we are The story for the theme the formula down to the child calitati con Astrow to the time the wow the et see cy Com M 1163 11011 VO W31/10 WO 21 105 rem 0 40 . 41 WE 13 11 1 att TER O 11 28 1 ht 21 11 26 19 16 SET SEE 10 AMADO MARCHES ISAN 103 ONE 20 COM LAIM STORM HELOCE BMW MERDENWI BMW NICE WORK 110 CANONOCE 110 BAR PGD 143 12222 1 12 1952 122) 116 150 15153 TO 20 ott ott OLACE tot DE 1 A 1 20 ECE 2.99 09 4.99 42 ALIO SPRE WA EP se 616/ 44 3423 21 932 405 4. INN JIVI DO LEV 33001 40 an Problem 2 TES Rental table Cagetory customer_id rental_id rental_date film_id rental_rate 5 13209 1/3/20 345 0.99 9 15813 5/31/20 219 4.99 11 11646 3/8/20 105 0.99 14 13780 3/24/20 385 4.99 15 13968 4/18/20 812 0.99 15 13798 3/12/20 116 2.99 21 14933 1/25/20 264 2.99 22 12222 2/18/20 861 4.99 23 15532 1/24/20 236 2.99 28 12938 2/21/20 869 2.99 29 15577 2/23/20 118 0.99 33 12277 2/20/20 90 0.99 41 15875 1/21/20 789 2.99 42 15407 2/6/20 733 0.99 42 13351 3/13/20 897 4.99 43 15745 1/3/20 600 0.99 43 15644 6/16/20 689 2.99 44 13428 6/12/20 21 4.99 52 12001 1/24/20 902 4.99 53 11657 667 2.99 Start Page Problem 1 Problem 2 Problem 3 4/7 Problem 4 + Film table film Id rating category film len 129 125 58 17 61 85 title 19 AMADEUS HOLY PG 21 AMERICAN CIRCUS R 67 BERETS AGENT PG-13 105 BULL SHAWSHANK NC-17 205 DANCES NONE NC-17 229 DEVIL DESIRE R 253 DRIFTER COMMANDMENT PG-13 375 GRAIL FRANKENSTEIN NC-17 530 LORD ARIZONA PG-13 542 LUST LOCK G 574 MIDNIGHT WESTWARD G 586 MOCKINGBIRD HOLLYWO/PG 823 SOUTH WAIT R 869 SUSPECTS QUILLS PG 982 WOMEN DORADO R 118 CANYON STOCK R 160 CLUB GRAFFITI 243 DOORS PRESIDENT NC-17 300 FALCON VOLUME PG 13 1 314GHTAWAREAKER i special features Commentaries, Deleted Scenes Behind the Action Commentaries, Behind the Scenes Action Deleted Scenes Action Deleted Scenes Action Trailers, Commentaries, Deleted Scenes, Behil Action Trailers, Behind the Scenes Action Trailers, Behind the Scenes Action Commentaries, Deleted Scenes,Behind the Si Action Trailers Action Trailers, Commentaries, Behind the Scenes Action Trailers, Deleted Scenes Action Behind the Scenes Action Commentaries, Behind the Scenes Action Trailers Action Action Deleted Scenes Behind the Scenes Trailers, Deleted Scenes Animation Trailers, Deleted Scenes Animation Trailers, Commentaries, Deleted Scenes Behl'Animation Animation Commentaries, Behind the Scenes Commentais duodech. Animation 52 16 60 19 47 PG-13 49 100 Am Det Punts OG G MUR TID 15 20 2 TH 2 NOT 1 15 ERLE In cell G19, use an Excel function to lookup the category for each film that was rented in the rental table. The category for each film is listed in the film table. Fill the formula down so that each film_id correctly matches its film category. Add a total row to the film table. Update the total row to show the average film_length Destionar Proteinen News Part Points Tash 2 18, en bounction to the reporfor him that we are The story for the theme the formula down to the child calitati con Astrow to the time the wow the et see cy Com M 1163 11011 VO W31/10 WO 21 105 rem 0 40 . 41 WE 13 11 1 att TER O 11 28 1 ht 21 11 26 19 16 SET SEE 10 AMADO MARCHES ISAN 103 ONE 20 COM LAIM STORM HELOCE BMW MERDENWI BMW NICE WORK 110 CANONOCE 110 BAR PGD 143 12222 1 12 1952 122) 116 150 15153 TO 20 ott ott OLACE tot DE 1 A 1 20 ECE 2.99 09 4.99 42 ALIO SPRE WA EP se 616/ 44 3423 21 932 405 4. INN JIVI DO LEV 33001 40 an Problem 2 TES Rental table Cagetory customer_id rental_id rental_date film_id rental_rate 5 13209 1/3/20 345 0.99 9 15813 5/31/20 219 4.99 11 11646 3/8/20 105 0.99 14 13780 3/24/20 385 4.99 15 13968 4/18/20 812 0.99 15 13798 3/12/20 116 2.99 21 14933 1/25/20 264 2.99 22 12222 2/18/20 861 4.99 23 15532 1/24/20 236 2.99 28 12938 2/21/20 869 2.99 29 15577 2/23/20 118 0.99 33 12277 2/20/20 90 0.99 41 15875 1/21/20 789 2.99 42 15407 2/6/20 733 0.99 42 13351 3/13/20 897 4.99 43 15745 1/3/20 600 0.99 43 15644 6/16/20 689 2.99 44 13428 6/12/20 21 4.99 52 12001 1/24/20 902 4.99 53 11657 667 2.99 Start Page Problem 1 Problem 2 Problem 3 4/7 Problem 4 + Film table film Id rating category film len 129 125 58 17 61 85 title 19 AMADEUS HOLY PG 21 AMERICAN CIRCUS R 67 BERETS AGENT PG-13 105 BULL SHAWSHANK NC-17 205 DANCES NONE NC-17 229 DEVIL DESIRE R 253 DRIFTER COMMANDMENT PG-13 375 GRAIL FRANKENSTEIN NC-17 530 LORD ARIZONA PG-13 542 LUST LOCK G 574 MIDNIGHT WESTWARD G 586 MOCKINGBIRD HOLLYWO/PG 823 SOUTH WAIT R 869 SUSPECTS QUILLS PG 982 WOMEN DORADO R 118 CANYON STOCK R 160 CLUB GRAFFITI 243 DOORS PRESIDENT NC-17 300 FALCON VOLUME PG 13 1 314GHTAWAREAKER i special features Commentaries, Deleted Scenes Behind the Action Commentaries, Behind the Scenes Action Deleted Scenes Action Deleted Scenes Action Trailers, Commentaries, Deleted Scenes, Behil Action Trailers, Behind the Scenes Action Trailers, Behind the Scenes Action Commentaries, Deleted Scenes,Behind the Si Action Trailers Action Trailers, Commentaries, Behind the Scenes Action Trailers, Deleted Scenes Action Behind the Scenes Action Commentaries, Behind the Scenes Action Trailers Action Action Deleted Scenes Behind the Scenes Trailers, Deleted Scenes Animation Trailers, Deleted Scenes Animation Trailers, Commentaries, Deleted Scenes Behl'Animation Animation Commentaries, Behind the Scenes Commentais duodech. Animation 52 16 60 19 47 PG-13 49 100
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started