Question

jin needs to add a row into his spreadsheet, but he does not want to remove any existing data. which combination of options should he use?
delete > shift cells left
insert > entire row
insert > shift cells down
delete > entire row

Explanation:

• Delete > Shift Cells Left: This option deletes data (opposite of what Jin wants as he doesn't want to remove existing data).
• Insert > Entire Row: This is the correct operation. When you insert an entire row in a spreadsheet (like in Excel), the existing rows below the inserted row are shifted down, and no existing data is removed.
• Insert > Shift Cells Down: This is not the standard way to insert an entire row. Usually, when inserting an entire row, the software (e.g., spreadsheet applications) has a specific "Insert Entire Row" option rather than a general "Shift Cells Down" for row - insertion (this option is more for inserting a single cell and shifting cells in a column - like context).
• Delete > Entire Row: This deletes a row (again, removes data which is not what Jin wants).

Answer:

Insert > Entire Row