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

The correct statement for deleting multiple rows in MS Excel 365 is:

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 ‘-‘.

Here's why:

  • Selecting Rows: You correctly select the rows by clicking and dragging over their row numbers.
  • Deleting Rows: The key combination "Ctrl + -" is a shortcut for deleting the selected rows.

Other options and their functions:

  • Ctrl + Space: This shortcut usually selects the entire column when a single cell within that column is selected.
  • Ctrl + +: This shortcut typically inserts a new row above the selected row.
  • Ctrl + Enter: This shortcut usually fills a formula or value across a selected range of cells.

By using this shortcut, you can quickly and efficiently delete multiple rows within your Excel spreadsheet.

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