Step $7$: Next, you want to insert a SUM function with a $3-$D reference on the Qtr $2$ worksheet. Click cell B$12$ and insert the SUM function with a $3-$D reference to total the rent amount for all three months. Copy the function in cell B$12$ to the range B$1$:B$20.$

Step $10$: Use the data in the four worksheets to enter data in the range E$7$:E$12$ in the Analysis section to provide either a text or a number that relates to the labels in the range F$7$:F$12.$