Given below are two statements. Read the given statements and mark the correct relationship between

them in the given options.

S$1$:If you add either new rows or new columns to the PivotTable source data, the PivotTable is not updated

even when you click on 'Refresh Data'

S$2$:If the range is not provided dynamically, then the PivotTable source data has to be manually updated.

$S1$ and $S2$ are correct but $S2$ is not the correct explanation of $S1$

$S1$ and $S2$ are correct and S$2$ is the correct explanation of S$1$

S$2$ is incorrect and S$1$ is correct

$S1$ is incorrect but $S2$ is correct