1.Question 1Which menu function sorts all spreadsheet data by the ranking of a specific sorted column?1 pointSort sheet Sort by rankSort range Sort data

Question 8Which function sorts a spreadsheet range between cells K1 and L80 in ascending order by the first column, Column K?1 point=SORT(K1:L80, A, TRUE)=SORT(K1:L80, A, FALSE)=SORT(K1:L80, 1, FALSE)=SORT(K1:L80, 1, TRUE)

Question 1A data analyst at a high-tech manufacturer sorts inventory data in a spreadsheet. They sort all data by ranking in the Order Frequency column, keeping together all data across rows. What spreadsheet tool are they using? 1 pointSort SheetSort TogetherSort RowsSort Column

Question 9You tried to sort your spreadsheet by the values in a particular column. You notice that one of the columns doesn’t seem to be correctly associated with the rest of the dataset. On closer examination, you realize that only that column was sorted, instead of the entire sheet. How can you sort the entire spreadsheet? Select all that apply. 1 pointThe Sort by row optionThe SORT functionThe Sort range optionThe Sort sheet option

Question 8Which function sorts a spreadsheet range between cells C1 and D70 in ascending order by the first column, Column C?

The price of various food items were entered in adjacent cells on a spreadsheet. Hannah wants to arrange the list of prices in descending order, from highest to lowest. Which of the following step(s) should be followed?1 pointSelect the list of prices and then click the icon labelled " Sort A to Z"Select the lsit of prices and then click the icon labelled " Sort Z to A'Click the icon labelled " Sort A to Z"Click the icon labelled " Sort Z to A"