Step $1$: Complete the OrderInfo Worksheet

$1.$ Add columns to the OrderInfo worksheet so that your column headers in row $1$ are organized like shown below:

$2.$ Using an Excel function, add the customer name to all rows in the Customer$\_$Name column.

$3.$ Using an Excel Function, combine Make, Model, and Engine in the Vehicle column, separating each attribute with a hyphen $($e$.$g$.,$ General Motors$-$Safari$-$V$6).$

$4.$ Using an Excel Function add the appropriate price for each vehicle sold in the Price column for each row.