Steps 12-15.

\begin{tabular}{c|l|} \hline 12 & The worksheet contains a circular error. Now you want to find and correct it. \\ On the Totals worksheet, check for errors and correct the formula with the circular reference. \\ \hline 13 & Youwanttocreateavalidationruletopreventtheuserfromenteringtoomanyseatssold.Fornow,youwillcreateavalidationforjustoneinputcell.IncellC6intheFridayworksheet,createavalidationruletoallowwholenumberslessthanorequaltodatastoredincellB6.EntertheinputmessagetitleSeatsSoldandtheinputmessageEnterthenumberofseatssold.(includingtheperiod).UsetheStopalertwiththeerroralerttitleInvalidNumberandtheerroralertmessageThenumbercannotexceedtotalseatsinsection.(includingtheperiod).Testthedatavalidationbyattemptingtoenter200incellC6andthencancelthechange. \\ \hline 14 & Youwanttounlockdata-entrycellssothattheusercanchangethenumberofseatssoldintheworksheets.GrouptheFriday,Saturday,andSundayworksheets.SelecttherangesC6:C8,C11:C13,andC16:C19andunlockthesecells. \\ \hline 15 & Nowthatyouunlockeddata-entrycells,youarereadytoprotecttheworksheetstopreventusersfromchangingdatainothercells.Individually,protecteachsheetusingthedefaultallowanceswiththepasswordExplorlng. \\ \hline \end{tabular} \begin{tabular}{c|l|} \hline 12 & The worksheet contains a circular error. Now you want to find and correct it. \\ On the Totals worksheet, check for errors and correct the formula with the circular reference. \\ \hline 13 & Youwanttocreateavalidationruletopreventtheuserfromenteringtoomanyseatssold.Fornow,youwillcreateavalidationforjustoneinputcell.IncellC6intheFridayworksheet,createavalidationruletoallowwholenumberslessthanorequaltodatastoredincellB6.EntertheinputmessagetitleSeatsSoldandtheinputmessageEnterthenumberofseatssold.(includingtheperiod).UsetheStopalertwiththeerroralerttitleInvalidNumberandtheerroralertmessageThenumbercannotexceedtotalseatsinsection.(includingtheperiod).Testthedatavalidationbyattemptingtoenter200incellC6andthencancelthechange. \\ \hline 14 & Youwanttounlockdata-entrycellssothattheusercanchangethenumberofseatssoldintheworksheets.GrouptheFriday,Saturday,andSundayworksheets.SelecttherangesC6:C8,C11:C13,andC16:C19andunlockthesecells. \\ \hline 15 & Nowthatyouunlockeddata-entrycells,youarereadytoprotecttheworksheetstopreventusersfromchangingdatainothercells.Individually,protecteachsheetusingthedefaultallowanceswiththepasswordExplorlng. \\ \hline \end{tabular}