What happens when you right-click on a row number and select Insert in MS Excel 2021?

Bihar NHM CHO-2025

Health Information and Technology (Basic Computer)

Easy

Appeared in: Bihar NHM CHO-2025

Explanation

In MS Excel, the 'Insert' command for a selected row always adds a new row directly above the selection.
This action pushes the selected row and all subsequent rows down by one position.
This is a standard, consistent behavior across recent versions of MS Excel, including 2021.
The purpose is to allow users to add new data without overwriting or manually shifting existing data.

Option B: This describes the 'Delete' function, not the 'Insert' function. Selecting 'Delete' after right-clicking a row number removes that row entirely.
Option C: This action pertains to columns, not rows. Inserting a column is done by right-clicking a column letter (e.g., A, B, C), not a row number.
Option D: This describes the process of adding a new sheet to the workbook, which is a different operation from inserting a row within a sheet.

Visual 1: GIF - A short animated GIF showing a cursor right-clicking on a row number in Excel, selecting 'Insert' from the menu, and a new row appearing above the selected one.
Visual 2: Screenshot - A static image of the right-click context menu in Excel with the 'Insert' option highlighted for a selected row.

Clinical Relevance

Nursing practice connection: This is primarily an exam-oriented knowledge point with limited direct bedside application, so retain Basic row manipulation functions in MS Excel as background academic context rather than a clinical decision trigger.
Proficiency in spreadsheet software like MS Excel is a valuable administrative skill for nurses. It is often used for non-clinical tasks such as creating staff schedules, tracking patient education materials, managing inventory lists, or organizing research data.
Knowing how to quickly insert rows allows a nurse to add new information (e.g., a new staff member to a schedule, a new item to an inventory list) without disrupting the existing data structure.
What if the nurse needed to add a new column instead? They would right-click the column letter to the right of where they want the new column and select 'Insert'. This is useful for adding a new data category, such as a 'Date of Training Completion' column to a staff roster.

How to Approach the Question

Identify the key elements of the question: the software (MS Excel), the object (a row number), and the action (right-click and select 'Insert').
Visualize or recall the standard behavior of the software for this specific sequence of actions.
The 'Insert' command in Excel is context-sensitive. For a row, it means adding a new row. For a column, it means adding a new column.
Remember the rule of placement: Excel inserts rows above the selection and columns to the left of the selection.
Evaluate each option against this rule. Option A correctly describes the action for inserting a row.
Eliminate the other options by identifying the different actions they describe (deleting a row, inserting a column, inserting a worksheet).

Concept Tested & Keywords

QzJFlBOGFgzRN0yRBEnVYn