Instructions: You will create and submit one Excel workbook $($xls or xlsx file extension$).$ On "Sheet $1"$ rename it to "Problems" and create a new sheet. Change its name from "Sheet $2"$ to "Solutions."

A$)$ Calculate the following in excel:

$3\mathrm{.}45*7\mathrm{.}535-(5+6\mathrm{.}7)*4\mathrm{.}567=?$

B$)$ Input the data below into a new sheet named "Scores". Then add three additional columns with headers for the Games. One labeled average, one labeled max, and one labeled totaled. Then complete those calculations for each city. At the bottom of each scoring groups determine the average for Score $1,$ Score $2,$ and Score $3.$ Lastly use the spread sheet to compare to see who had the single highest score for one game, and who one the overall series based on the average scores. Highlight your answers in different colors and make the text bold. For additional notes or comments you can insert a text box into the workbook.

ID $$City $$ Score $1$ Score $2$ Score $3$

$1$New York $889087$

$2$Los Angele $918589$

$3$Chicago $808279$

$4$Houston $898790$

$5$Phoenix $848682$

$6$Philadelphia $908891$

$7$San Antonio $788075$

$8$San Diego $929193$

$9$Dallas $838480$

$10$San Jose $939088$