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.$)$