arrow
arrow
arrow
In MS Excel 365, which of the following statements related to deleting rows in an Excel sheet is correct?
Question



In MS Excel 365, which of the following statements related to deleting rows in an Excel sheet is correct?

A.

If you want to delete multiple rows at once, simply select the rows by clicking and dragging over the row numbers, and then press ‘Ctrl’ and ‘space’.

B.

If you want to delete multiple rows at once, simply select the rows by clicking and dragging over the row numbers, and then press ‘Ctrl’ and ‘-’.

C.

If you want to delete multiple rows at once, simply select the rows by clicking and dragging over the row numbers, and then press ‘Ctrl’ and ‘+’.

D.

If you want to delete multiple rows at once, simply select the rows by clicking and dragging over the row numbers, and then press ‘Ctrl’ and ‘Enter’.

Correct option is B

In MS Excel 365, to delete multiple rows at once:
1. Select the rows by clicking and dragging over the row numbers.
2. Use the shortcut Ctrl + - (minus key) to delete the selected rows. This action deletes the selected rows and shifts the remaining rows upward.
Important Key Points:
1. Ctrl + -: Deletes selected rows or columns.
2. Select rows by dragging over their numbers in the row header on the left.
3. Deleted rows cause the rows below to shift upward automatically.
Knowledge Booster:
· Ctrl + Space: Selects the entire column of the active cell.
· Ctrl + + (Plus): Inserts new rows or columns, not deletes.
· Ctrl + Enter: Used to fill the selected cells with the current entry, not for deleting rows.

Free Tests

Free
Must Attempt

SSC GD PYP (Held on 4 Feb 2025 S1)

languageIcon English
  • pdpQsnIcon80 Questions
  • pdpsheetsIcon160 Marks
  • timerIcon60 Mins
languageIcon English
Free
Must Attempt

Hindi Section Test 1

languageIcon English
  • pdpQsnIcon20 Questions
  • pdpsheetsIcon40 Marks
  • timerIcon12 Mins
languageIcon English
Free
Must Attempt

SSC GD Constable Full Mock Test 1

languageIcon English
  • pdpQsnIcon80 Questions
  • pdpsheetsIcon160 Marks
  • timerIcon60 Mins
languageIcon English
test-prime-package

Access ‘Delhi Police Constable’ Mock Tests with

  • 60000+ Mocks and Previous Year Papers
  • Unlimited Re-Attempts
  • Personalised Report Card
  • 500% Refund on Final Selection
  • Largest Community
students-icon
368k+ students have already unlocked exclusive benefits with Test Prime!
Our Plans
Monthsup-arrow