f the values in a column are to be arranged in ascending  order then which of the following helps?Options :Drag row fieldDrag column fieldConditional formattingAll of the above

The option that helps to arrange the values in a column in ascending order is Conditional formatting. This feature in spreadsheet software like Excel allows you to format cells based on their content, which can be used to automatically sort values in ascending order.

Here are the steps to do it:

1. Select the column you want to sort.
2. Go to the "Home" tab in the ribbon.
3. Click on "Conditional Formatting" in the "Styles" group.
4. Hover over "Highlight Cell Rules" and then click on "More Rules" at the bottom of the menu.
5. In the "New Formatting Rule" dialog box, select "Format cells that are GREATER THAN/LESS THAN".
6. Enter the value you want to use as your threshold in the box next to "Format cells that are GREATER THAN/LESS THAN".
7. Click on the "Format" button to specify how you want to highlight cells that meet your criteria.
8. Click "OK" to close the dialog box. The cells in your selected column that meet your criteria will now be highlighted in the way you specified.

Please note that this will not physically reorder the cells in the column; it will simply change their formatting to make it easier to visually identify which cells meet your criteria. If you want to physically reorder the cells, you would need to use the "Sort & Filter" feature on the "Data" tab instead.

The option that helps to arrange the values in a column in ascending order is Conditional formatting. This feature in spreadsheet software like Excel allows you to format cells based on their content, which can be used to automatically sort values in ascending order.

Here are the steps to do it:

1. Select the column that you want to sort.
2. Go to the "Home" tab in the toolbar.
3. Click on "Conditional Formatting" in the "Styles" group.
4. Select "Sort Smallest to Largest" from the drop-down menu.
5. The values in the column will now be sorted in ascending order.

Please note that dragging row or column fields will not sort the values in a column. It will only change the position of the column or row in the spreadsheet.