HELP! notice that I uploaded the 4 images of the sheets. THANK YOU!

Summarize Data Using 3D References

1. Open JuneEntries.xlsx and save it with the name 4-JuneEntries.

2. With AttendanceSummary the active worksheet, summarize the data in the three park worksheets using 3D references as follows:

a. Make cell B7 the active cell and then create a 3D formula to sum the attendance values in the three park worksheets for day 1. Copy the formula into the remaining cells in column B to complete the summary to day 16.

b. Make cell E7 the active cell and then create a 3D formula to sum the attendance values in the three park worksheets for day 17. Copy the formula into the remaining cells in column E to complete the summary to day 30.

3. Type the label Total Vehicle and Individual Entrances in cell A24 and create a Sum formula in cell E24 to compute the grand total for the month. Apply the Comma format with no digits after the decimal point.

4. Preview the AttendanceSummary worksheet.

5. Save and then close 4-JuneEntries.xlsx.

http://www.nps.gov/brca Jun 2024 Private Vehicle and Individual Entrances Only \begin{tabular}{|c|c|r|} \hline 6 & Day & Entries \\ \cline { 2 - 3 } & 1 & 40 \\ \hline 8 & 2 & 55 \\ \hline 9 & 3 & 35 \\ \hline 10 & 4 & 31 \\ \hline 11 & 5 & 56 \\ \hline 12 & 6 & 32 \\ \hline 13 & 7 & 22 \\ \hline 14 & 8 & 25 \\ \hline 15 & 9 & 45 \\ \hline 16 & 10 & 19 \\ \hline 17 & 11 & 25 \\ \hline 18 & 12 & 65 \\ \hline 19 & 13 & 24 \\ \hline 20 & 14 & 30 \\ \hline 21 & 15 & 33 \\ \hline 22 & 16 & 42 \\ \hline \end{tabular} \begin{tabular}{|c|r|} \hline Day & Entries \\ \hline 17 & 68 \\ \hline 18 & 30 \\ \hline 19 & 47 \\ \hline 20 & 40 \\ \hline 21 & 65 \\ \hline 22 & 79 \\ \hline 23 & 58 \\ \hline 24 & 65 \\ \hline 25 & 40 \\ \hline 26 & 55 \\ \hline 27 & 58 \\ \hline 28 & 66 \\ \hline 29 & 87 \\ \hline 30 & 72 \\ \hline \end{tabular} R92 :\fx Jun 2024 Private Vehicle and Individual Entrances Only 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 \begin{tabular}{|c|r} \hline Day & Entries \\ \hline 17 & 175 \\ \hline 18 & 201 \\ \hline 19 & 212 \\ \hline 20 & 288 \\ \hline 21 & 196 \\ \hline 22 & 260 \\ \hline 23 & 230 \\ \hline 24 & 242 \\ \hline 25 & 250 \\ \hline 26 & 291 \\ \hline 27 & 310 \\ \hline 28 & 325 \\ \hline 29 & 389 \\ \hline 30 & 341 \\ \hline & \\ \hline \end{tabular} Ready {Accessibility:Goodtogoand