What should you do to prevent headers from being sorted with data?

• A. Uncheck 'Data has header' before sorting
• B. Check the "Data has header" checkbox when sorting
• C. Move headers to a separate sheet
• D. Sort only one column

Answer: (B)

Ensuring the sort recognizes the top row as headers prevents the header row from being shuffled with the data. When you check the option indicating that Data has header, the sorting tool treats the first row as labels and excludes it from the sort operation, so only the data rows get reordered. This keeps the column headings at the top and preserves the correct alignment between headers and their data. Without this setting, the header row can move around with the data, making the sheet confusing and misaligned. Other approaches like moving headers to another sheet or sorting a single column won’t reliably keep the header fixed, whereas marking the top row as headers does.