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"

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)

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

Which of the following are valid sorting orders you can choose when adding sorting levels to your data? Select all that apply.1 pointZ to AOldest to NewestYoungest to Oldest Smallest to Largest

Question 10A data professional wants the data in column A to be in alphabetical order from A to Z. What spreadsheet feature would enable them to accomplish this task?(n/a)ABC1DecianiLin332RobertsJeremy283StorelliHyun644PiotrowskiSook845MondekPriscilla426LamApril961 pointSort rangeFormattingChart editorDragging

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