Case study related to the Excel test: CASE $03$: Francisco's Lawn Care

$1.)$ You can find the pricing guide on the Customers worksheet. Using an excel function please generate a new column that tells, how much each customer should pay to Mr$.$ Francisco per week $(=$Additional charge $+$ weekly charge$)($ Customers worksheet$)$

$2.)$ Create a Pivot table that answers the following question: Whose garden is going to be done on $2008\mathrm{.}04\mathrm{.}12.$ and what sizes of gardens they have? $($ Customers worksheet$)$

$3.)$ Mr$.$ Francisco would like to compare his revenue based on payment days $($days of the week$).$ Use the sumif$($ function to calculate this. Create a chart that visualizes this information. Mr$.$ Francisco would also like to see the amount payed on each payment day. $($ use the information based on the customers worksheet$)$