Table 4-4 Cell CB C9 F4 G4 H4 =Pric =-PMT(Interest Rate/12, =Monthly Payment =12*Monthly Payment*Years+Down Payment =G4-Price 3. Use the Data Table button in the What-If Analysis gallery (Data tab | Forecast group) to define the range E4:H19 as a one-input data table. Use the Interest Rate in the Loan Pa Calculator as the column input cell. 4. Use the Page Setup dialog box to select the Fit to and 'Black and white' options. Select th range B2:C9 and then use the 'Set Print Area' command to set a print area. Use the Prim button on the Print screen in Backstage view to print the worksheet. Use the 'Clear Pri command to clear the print area. II th