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.

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

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.

$\backslash$table$[[,$A$,$B$],[1,$Price,$35000],[2,\backslash$table$[[$Interest$],[($annual$)]],\backslash$table$[[$Loan term $($in$],[$months$)]]],[4,$Monthly payment,$]]$