What action should be taken to add a new row or column in a spreadsheet?

Correct option is A

To add a new row or column in a spreadsheet, the simplest method is to right-click on the row or column header and select the ‘Insert’ option from the context menu. This action automatically creates space for the new row or column by shifting existing data downward or to the right.
Important Key Points:
1. Right-clicking and selecting ‘Insert’ is a universally supported action across spreadsheet applications like Excel and Google Sheets.
2. The process is efficient and avoids manual adjustments to existing data.
3. This feature can also be accessed from the ribbon menu but is less direct than the context menu option.
Knowledge Booster:
· Find and Replace: This is used to locate or update data in a spreadsheet and is unrelated to inserting rows or columns.
· Delete: This action removes cells, rows, or columns but does not create new ones.
· Ctrl+X and Ctrl+V: These shortcuts are for cutting and pasting data, not for adding new rows or columns.