After copying data firm the April worksheet to the May worksheet, you want to prepare the May worksheet for data.

In cell A$2,$ change April to May. Select the ranges A$5$:D$13$ and F$5$:G$13$ and clear cell contents but keep the formatting. In cell F$5,$ type $1.$ In cell $65,$ type $1.$ Copy the values to the range F$6$:G$13.$

ted On: $08101/2023$

Exp$22\_$Excel$\_$Ch$01\_$ML$2$

Excel $202$

Instructions

Step

Instructions

Po

Pos

$19$

The property listings dataset is small. To improve readability on the printed copy for the other real estate agents, you will increase the scaling.

Select both worksheets and apply $120\%$ scaling.

$20$

You want to apply page setup options to both sheets, so you need to group the sheets first.

Select both worksheets. Select Landscape orientation. Center the page horizontally and vertically between the margins.

$21$

With both worksheets still selected, insert a footer with the text Exploring Series on the left side, the sheet name code in the center, and the file name code on the right side.