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

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

Question 4A data analyst summarizes their data. They sort, reorganize, and average the data. What tool are they using to do this?1 pointA functionA dashboardA pivot tableA report

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 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)

hich of the following statements accurately describe sorting and filtering? Select all that apply.1 pointSorting can be performed in spreadsheets, but not SQL databases.Sorting can be used to group similar data together by a classification. Filtering involves showing data that meets a specified criteria while hiding the rest.Data professionals sort data to make it easier to understand, analyze, and visualize.