hamburger menu
All Coursesall course arrow
adda247
reward-icon
adda247
    arrow
    arrow
    arrow
    ​Which of the following is the correct way to sort a range of cells in ascending order in MS Excel 365?​
    Question

    ​Which of the following is the correct way to sort a range of cells in ascending order in MS Excel 365?​

    A.

    ​Select the range of cells and press ‘Ctrl + Shift + S’.​

    B.

    ​Click on the ‘Review’ tab and select ‘Sort’.​

    C.

    ​Click on the ‘OK’ button​

    D.

    In the ‘Sort’ dialog box, select the ‘Ascending’ option in the ‘Order’ section.

    Correct option is D

    The correct sequence for sorting a range of cells in ascending order in MS Excel 365 is:

    In the ‘Sort’ dialog box, select the ‘Ascending’ option in the ‘Order’ section.

    Here's how you do it:

    1. Select the range of cells: Click and drag your mouse over the cells you want to sort.
    2. Open the Sort dialog box:
      • Method 1: On the "Data" tab, in the "Sort & Filter" group, click "Sort."
      • Method 2: Right-click within the selected range and choose "Sort" from the context menu.
    3. Choose "Ascending": In the "Sort" dialog box, under "Order," select "Ascending."
    4. Click "OK": Excel will sort the selected range of cells in ascending order based on the selected column.

    This method allows you to access the full sorting options, including:

    • Sorting by multiple columns: You can specify additional sort criteria for subsequent columns.
    • Sorting options: Choose between ascending and descending order.
    • Header row options: Indicate whether your data has a header row.

    By using the "Sort" dialog box, you have more control over the sorting process and can easily customize it to fit your specific needs.

    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