What is the result of the formula in the last column and last row of the Mailing List table in the My Hot Holidays document?Group of answer choices185.230144.32138.04

Which of the following is the formula that you created in the total row of the Mailing List table?Group of answer choices= SUM(ABOVE)=AVERAGE(F2:F23)=AVERAGE(ABOVE)=SUM(F2:F23)

What is the result of the formula that you noted for the average deposit in the Mailing List table BEFORE you changed the value of the cell above the formula?Group of answer choices138.04185.230144.32

When you changed the value of a deposit in the Mailing List table, which of the following was true?Group of answer choicesThe formula had to be updated manuallyThe formula updated automaticallyThe formula had to be reformattedThe formula had to be recreated

Question 3In this spreadsheet, which function will extract Clay Casey’s four-digit postcode?ABCD1CustomerStreetTerritoryCountry2Terry Stewart707 Collins St, Docklands VIC 3008Australia3Che Price177 William St, Tennant Creek NT 0860Australia4Stanley Moss430 Little Collins St, CXI 6798Australia5Clay Casey250 Queen St, Sydney NSW 3000Australia1 point=LEFT(4,C5)=LEFT(C5,4)=RIGHT(4,C5)=RIGHT(C5,4)4.Question 4

Question 3In this spreadsheet, which function will extract Clay Casey’s four-digit postcode?(n/a)ABCD1CustomerStreetTerritoryCountry2Terry Stewart707 Collins St, Docklands VIC 3008Australia3Che Price177 William St, Tennant Creek NT 0860Australia4Stanley Moss430 Little Collins St, CXI 6798Australia5Clay Casey250 Queen St, Sydney NSW 3000Australia1 point=RIGHT(4,C5)=LEFT(4,C5)=RIGHT(C5,4)=LEFT(C5,4)