Excel worksheet W$1$Q$1$ provides a database of a computer hardware distributor who sells to small businesses and offices. Each row is a record of contracts signed that day stating the number of items sold and profit per item of that contract. Complete the following:

Create a new column calculating the total profit per contract. Apply conditional formatting to this column to visually demonstrate the range of profits$/$contract$.$

Using only one excel function in one cell, calculate the total profit for the data. You cannot use the column you just created, you may only use the initially provided data.