Question

Which option is selected in the Sort dialog box, if the selected range consists of columns and headings?

Has headers

My data has headers

Headers not required​

Answer 1

Answer:

My data has headers

Explanation:

steps:-

• Select a cell in the dataset.
• On the Data tab, select Sort.
• If the data has a header row, but Excel doesn't recognize it, select the My Data Has Headers check box.
• From the Sort By drop-down, select the first column header by which to sort.
• From the Sort On drop-down, select Values.

Answer 2

Questions:

which option is selected in the sort dialogue box, if if the selected range consists of columns and headings ?

Answer:

b) My data has headers