Can you please solve these two questions:

$1.$ Go to the Customers worksheet. Ravi wants to create PivotTables that include customer, contract, and invoice data. He already added the tables containing this data to the Data Model. Ravi wants to list and total each contract amount by city and signing date.

Create a PivotTable that displays this information as follows:

a$.$ Use Power Pivot to create a PivotTable on a new worksheet, using Contracts by City as the name of the worksheet.

b$.$ Display the City field values from the Query $-$ Customer data source as row headings.

c$.$ Display the SigningDate field values from the Query $-$ Contract data source as column headings.

d$.$ Add the ContractAmt field from the Query $-$ Contract data source to the Values area to sum the field values. $($Ignore the alert that states "Relationships between tables may be needed.", these relationships will be created in a later step.$)$

e$.$ Group the signing dates to display them as years and quarters only. $($Hint: Expand the year headings to display the quarter headings, if necessary.$)$

$2.$ Ravi's plan is that when users click the Add Customer button in the range D$3$:E$3,$ the Customers worksheet opens and Excel adds a new, blank record to the Customer table, where users can insert the new customer information. Record a macro to automate the Add Customer button as follows:

a$.$ Enable all macros in the workbook, and then display the Developer tab on the ribbon.

b$.$ Record a macro stored in this workbook using Add$\_$Customer as the name of the macro.

c$.$ While recording the macro, display the Customers worksheet.

d$.$ Also, while recording the macro, add a new blank record to the end of the Customer table.

e$.$ Stop recording the macro.

f$.$ Assign the Add$\_$Customer macro to the Add Customer button and then run the Add$\_$Customer macro to make sure it inserts a new record at the bottom of the Customer table on the Customers worksheet.