hamburger menu
All Coursesall course arrow
adda247
reward-icon
adda247
    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
    354k+ students have already unlocked exclusive benefits with Test Prime!
    Our Plans
    Monthsup-arrow