plete the Summany of Movies table below using the conditional functions. Use the data listed on the Sheet4Data tab. (3 marks) worksheet will also be used to enter new data through the New Movie Entry table, but before that you must protect the input fro he following conditions. Provide meaningful descriptions and error responses as well: a) The Date must be 1930 or later. (1 mark) b) The Time in Minutes can't have decimals. (1 mark) c) For the Format, allow the user to only choose from the list provided for you in the Possible Choices table. (1 mark) d) For the Category allow the user to choose from the list provided for you in the Possible Cholces table. (2 marks) \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline A & & B & C & & D & & E & F & G & H & 1 & J & K & L \\ \hline intle & & Subtitle & Date. & Time & in Minutes & & Format & Catesory & & & & & & \\ \hline & 300 & & & 2007 & & 116 & HD-DVD & Action & & & & & & \\ \hline & 300 & & & 2007 & & 116 & DVD & Action & & & & & & \\ \hline & 300 & & & 2007 & & 116 & Blu-ray & Action & & & & & & \\ \hline Bourne Ide & atity & & & 2002 & & 119 & HO-DVO & Action & & & & & & \\ \hline Serenity & & & & 2005 & & 119 & HD-DVD & Action & & & & & & \\ \hline 28 Days tat & & & & 2002 & & 113 & DVD & Horror & & & & & & \\ \hline 28 Weeks & ater & & & 2007 & & 100 & DVD & Horror & & & & & & \\ \hline Above the & Law & & & 1988 & & 99 & DVD & Action & & & & & & \\ \hline Akira & & & & 1987 & & 124 & DVD & Anime & & & & & & \\ \hline Arroy of Da & arkne & & & 1992 & & 81 & DVD & Hotror & & & & & & \\ \hline Alien vs Pro & odato & & & 2004 & & 100 & DVD & Action. & & & & & & \\ \hline Belly of the & e Bea & & & 2003 & & 91 & DVD & Action & & & & & & \\ \hline Black X-ma & & & & 2006 & & 91 & DVD & Horror & & & & & & \\ \hline Blood Ray & & & & 2005 & & 99 & DVD & Action & & & & & & \\ \hline Blood rov & ne 2 & Deliverance. & & 2003 & & 95 & DVD & Action & & & & & & \\ \hline Cannon Ba & all Run & & & 1981 & 7 & 96 & DVD & Comedy & & & & & & \\ \hline Catwoman & & & & 2004 & & 104 & DND & Action & & & & & & \\ \hline Clash of th & ve Tite & tans & & 1981 & & 118 & DVD & 5top-motion & & & & & & \\ \hline Cohra & & & & 1096 & & 871 & DVD & Action & & & & & & \\ \hline Constantin & & & & 2005 & & 121 & DVD & Action & & & & & & \\ \hline Dead Poet & ts 50c & ciety & & 1989 & & 129 & DVD & Action & & & & & & \\ \hline Dead Poet & 4550c & ciety & & 1989 & & 129 & VHS & Action & & & & & & \\ \hline Dawn of t & the De & ead & & 2004 & & 101 & DVD & Horror & & & & & & \\ \hline Desperado & & & & 1995 & & 103 & DVO & Action & & & & & & \\ \hline Devils Rej & ects & & & 2005 & & 109 & DVD & Horror & & & & & & \\ \hline Dead or A & Nive & & & 2006 & & 86 & 5 DVD & Action & & & & & & \\ \hline El Mariach & & & & 1993 & & 81 & DVD & Action & & & & & & \\ \hline Eleckara & & & & 2005 & & 96 & DVD & Action & & & & & & \\ \hline Escape fro & am Ne & lew York & & 1981 & & 99 & DVD & Action & & & & & & \\ \hline Evil Dead & & & & 1982 & & 85 & DVD & Horror & & & & & & \\ \hline Evir Dead & & & & 1987 & & 84 & DVO & Horror & & & & & & \\ \hline Exit Woun & nds & & & 2001 & & 101 & DVD & Action & & & & & & a. \\ \hline 1 Fire Down & a Belo & & & 1997 & & 105 & DVD & Action & & & & & & \\ \hline 4= & Sher & et1 I sheet? & Sheet] & Shoet 4 & Sheet4Da & & Sheets & & & & & & & \\ \hline \end{tabular} Sheet 4 plete the Summany of Movies table below using the conditional functions. Use the data listed on the Sheet4Data tab. (3 marks) worksheet will also be used to enter new data through the New Movie Entry table, but before that you must protect the input fro he following conditions. Provide meaningful descriptions and error responses as well: a) The Date must be 1930 or later. (1 mark) b) The Time in Minutes can't have decimals. (1 mark) c) For the Format, allow the user to only choose from the list provided for you in the Possible Choices table. (1 mark) d) For the Category allow the user to choose from the list provided for you in the Possible Cholces table. (2 marks) \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline A & & B & C & & D & & E & F & G & H & 1 & J & K & L \\ \hline intle & & Subtitle & Date. & Time & in Minutes & & Format & Catesory & & & & & & \\ \hline & 300 & & & 2007 & & 116 & HD-DVD & Action & & & & & & \\ \hline & 300 & & & 2007 & & 116 & DVD & Action & & & & & & \\ \hline & 300 & & & 2007 & & 116 & Blu-ray & Action & & & & & & \\ \hline Bourne Ide & atity & & & 2002 & & 119 & HO-DVO & Action & & & & & & \\ \hline Serenity & & & & 2005 & & 119 & HD-DVD & Action & & & & & & \\ \hline 28 Days tat & & & & 2002 & & 113 & DVD & Horror & & & & & & \\ \hline 28 Weeks & ater & & & 2007 & & 100 & DVD & Horror & & & & & & \\ \hline Above the & Law & & & 1988 & & 99 & DVD & Action & & & & & & \\ \hline Akira & & & & 1987 & & 124 & DVD & Anime & & & & & & \\ \hline Arroy of Da & arkne & & & 1992 & & 81 & DVD & Hotror & & & & & & \\ \hline Alien vs Pro & odato & & & 2004 & & 100 & DVD & Action. & & & & & & \\ \hline Belly of the & e Bea & & & 2003 & & 91 & DVD & Action & & & & & & \\ \hline Black X-ma & & & & 2006 & & 91 & DVD & Horror & & & & & & \\ \hline Blood Ray & & & & 2005 & & 99 & DVD & Action & & & & & & \\ \hline Blood rov & ne 2 & Deliverance. & & 2003 & & 95 & DVD & Action & & & & & & \\ \hline Cannon Ba & all Run & & & 1981 & 7 & 96 & DVD & Comedy & & & & & & \\ \hline Catwoman & & & & 2004 & & 104 & DND & Action & & & & & & \\ \hline Clash of th & ve Tite & tans & & 1981 & & 118 & DVD & 5top-motion & & & & & & \\ \hline Cohra & & & & 1096 & & 871 & DVD & Action & & & & & & \\ \hline Constantin & & & & 2005 & & 121 & DVD & Action & & & & & & \\ \hline Dead Poet & ts 50c & ciety & & 1989 & & 129 & DVD & Action & & & & & & \\ \hline Dead Poet & 4550c & ciety & & 1989 & & 129 & VHS & Action & & & & & & \\ \hline Dawn of t & the De & ead & & 2004 & & 101 & DVD & Horror & & & & & & \\ \hline Desperado & & & & 1995 & & 103 & DVO & Action & & & & & & \\ \hline Devils Rej & ects & & & 2005 & & 109 & DVD & Horror & & & & & & \\ \hline Dead or A & Nive & & & 2006 & & 86 & 5 DVD & Action & & & & & & \\ \hline El Mariach & & & & 1993 & & 81 & DVD & Action & & & & & & \\ \hline Eleckara & & & & 2005 & & 96 & DVD & Action & & & & & & \\ \hline Escape fro & am Ne & lew York & & 1981 & & 99 & DVD & Action & & & & & & \\ \hline Evil Dead & & & & 1982 & & 85 & DVD & Horror & & & & & & \\ \hline Evir Dead & & & & 1987 & & 84 & DVO & Horror & & & & & & \\ \hline Exit Woun & nds & & & 2001 & & 101 & DVD & Action & & & & & & a. \\ \hline 1 Fire Down & a Belo & & & 1997 & & 105 & DVD & Action & & & & & & \\ \hline 4= & Sher & et1 I sheet? & Sheet] & Shoet 4 & Sheet4Da & & Sheets & & & & & & & \\ \hline \end{tabular} Sheet 4