In two to three sentences, describe how you would use the autofill shortcut.

When you fill in data based on adjacent cells by dragging the fill handle in Microsoft Excel, the Auto Fill Options button is displayed just below and to the right of your filled selection. When you click the

Auto Fill Options button, a list of options appears that allows you to choose to fill the cells with text or data, and whether or not to include the format of the initial selection or to copy only the format.

month 1 start amount =$3287.90 interest=(3287.90x0.0145/12)3.97 total to pay=$3291.81 paid =$1200 balance =$2,091.87

month 2 starting amount= $2,091.87 interest =$25.28 total to pay =$2117.15 paid =$1200 balance $917.15

month 3 starting amount =$917.15 interest =$11.08 total to pay =$928.23 paid =$928.23 balance =$0 total to pay 1200+1200+928.23 = $3328.23 it will take 3 months to pay a total of $3328.23

answerblank(1); fixed interval; blank(2) fixed ratio;