C$.$ Write $\text{'}$T$\text{'}$ for True and $\text{'}F\text{'}$ for False statement. You can create only one scenario for data in a worksheet. A List is used to describe a type of data validation on data. The rows in an Excel table are displayed in banded colours for greater visibility Tables in Excel support subtotals. Goal Seek updates the value of the target cell based on the value in the source cell of a formula.