data analyst sorts a spreadsheet range between cells d5 and m5. they sort in descending order by the third column, column f. what is the syntax they are using?

See Answers (1)

Accepted Answer

The syntax is :SORT(F19:F82, 3, TRUE).What is sorting?When sorting data in a worksheet, you can rearrange the data to quickly find values. Sorting a range or table of data on one or more columns of data is possible. You can, for example, sort employees first by department and then by last name.Sorting is the method of trying to arrange data into meaningful order in order to more effectively analyze it.Sort by multiple columns or rowsChoose a cell from the data range.Click Sort on the Data tab's Sort & Filter group.Select the first column to sort in the Sort dialog box, under Column, in the Sort by box.Select the type of sort under Sort On.Select how you want to order things under Order.To learn more about spreadsheet refer to :https://brainly.com/question/29036967#SPJ4

Related Question in Computers and Technology