Skills Approach $2019$ Student Learning Objectives

Compute the monthly cost of gas.

a$.$ In cell C$21,$ enter a formula to calculate the number of miles you expect

to drive each month. Divide the value of number of miles $($cell A$5$ from

the Data sheet$)$ by the average MPG for the vehicle multiplied by the

price of a gallon of gas $($cell A$6$ from the Data sheet$).$

$1.$simneton$/$ine$.$com$/$sp$/$assignments$/$projects$/$details$/9015572$

Complete the Analysis section using formulas with statistical functions. Use

named ranges instead of cell references in the formulas.

a$.$ Price

b$.$ MPG City

c$.$ MPG Highway

d$.$ Average MPG

e$.$ Maintenance$/$Year

f$.$ Registration Fee

g$.$ Insurance$/$Near

h$.$ Amount to Borrow

i$.$ APR

j$.$ Years

imneton$/$ine$.$com$/$sp$/$assignments$/$projects$/$details$/9015572$

Excel $2019$ Skills Approach $-$ Ch $3$ Challenge Yourself $3\mathrm{.}3-$ SIMnet

k$.$ Loan Payment

I. $$ Gas

m$.$ Maintenance$/$Month

n$.$ Insurance$/$Month

o$.$ Total Monthly

Hint: Select cells B$7$:F$24$ and use Excel's Create from Selection command to

create named ranges for each row using the labels at the left side of the

range as the names.

Hint: Open the Name Manager and review the names Excel created. Notice

that any spaces or special characters in the label names are converted to $\_$

characters in the names.

Hint: To avoid typos as you create each formula, try using Formula

AutoComplete to select the correct range name.

$$ Before finishing the project, check the worksheet for errors.