Calculate Chi-square p-value using pivot table in Microsoft Excel sheet

How to use the Chi-Square test of independence formula in Excel
Easy way to populate the table using pivot table
Using F4 function (press twice) to replicate the calculation in each rows