Excel Chapter 1
Change the scaling to fit each selected worksheet on one page.
1. On the Page Layout tab, in the Scale to Fit group, click the Page Setup Dialog Box Launcher. 2. In the Page Setup dialog box, on the Page tab, click the Fit to option.
Enter the first profit margin formula
=(Sale Price-Cost)/Sale Price, CTRL+ENTER
Use semi-selection to enter the first sale price formula
=Retail Price-(Retail Price*Percent Off) , CTRL+ENTER
Enter the first profit amount formula
=Sale Price-Cost
Use the Formula Bar to compare the contents of cell H6 and cell H20. Apply bold to the cell that contains a value instead of a formula.
Click cell H6, and then click cell H20. On the Home tab, in the Font group, click Bold.
Display cell formulas
On the Formulas tab, in the Formula Auditing group, click Show Formulas.
Select both the September and Formulas sheet tabs. Select landscape orientation.
Right-click either sheet tab, and from the shortcut menu, click Select All Sheets, Click Page Layout-Orientation- Landscape
