13. Preview how the worksheet will look when printed, and then apply print settings to print the worksheet on a single page. Hint: If you have one of the charts selected, deselect it before previewing the worksheet. Preview the worksheet again when you are finished to check your work. a. Change the orientation so the page is wider than it is tall. b. Change the margins to the preset narrow option. c. Change the printing scale so all columns will print on a single page. 14. Top't Corn is considering a new truck purchase. Calculate the monthly loan payments and total cost of the loan. a. Insert a new worksheet between the MobileSales sheet and the OnlineSales sheets. b. Name the new worksheet: TruckLoan Change the color of the worksheet tab to Orange. Use the third color from the left in the row of Standard colors. 1 2 3 4 c. d. Enter the loan terms as shown below. Price A Interest (annual) Loan term (in months) Monthly payment 55000 3% 24 B Reset Progres

13. Preview how the worksheet will look when printed, and then apply print settings to print the worksheet on a single page Hint If you have one of the charts selected, deselect it before previewing the worksheet. Preview the worksheet again when you are finished to check your work. a. Change the orientation so the page is wider than it is tall. b. Change the margins to the preset narrow option. c. Change the printing scale so all columns will print on a single page. 14. Top' Corn is considering a new truck purchase. Calculate the monthly loan payments and total cost of the loan. a. Insert a new worksheet between the MobileSales sheet and the OnlineSales sheets. b. Name the new worksheet: TruckLoan c. Change the color of the worksheet tab to Orange. Use the third color from the left in the row of Standard colors. d. Enter the loan terms as shown below