EXCEL PHASE-2 ADVANCED| Assignment3 | SEM3| 2024| DIGITAL SKILLS |💯✅👍

Sdílet
Vložit
  • čas přidán 11. 09. 2024
  • #naanmudhalvan
    #microsoft
    #digitalskills
    #microsoftexcel
    #answersdotcom
    #excel
    Assessment- 3
    Open MS Excel on your respective desktop / or www.office.com
    Open Microsoft Excel on your desktop or log on to www.office.com to use MS Excel
    Add the data to the spreadsheet.
    Add the data to the spreadsheet
    Use all functions of the Dynamic Array
    Sort
    Sort Function:
    The simple SORT function below has only 1 argument (A2:D15). By default, the SORT function sorts by the first column, in ascending order.
    Use the second argument of the SORT function to sort by a different column. The SORT function below sorts by the second column.
    Use the third argument of the SORT function to sort in a different order. The SORT function below sorts by the first column, in descending order.
    To sort on multiple columns, simply supply an array constant. For example, sort by Last Name first and Sales second.

Komentáře • 5