A data analyst is performing data cleaning on an Excel spreadsheet that contains collected data. The data records have been marked with mixed formatting. The analyst wants to remove all formatting and reformat data. Which operation should the analyst perform to remove current formatting?
- Highlight data range -> Home tab -> Clear -> Clear Formats
- Home tab -> Clear Formats -> Highlight data range -> Clear All
- Highlight data range -> Home tab -> Clear Formats -> Clear All
- Home tab -> Clear Formats -> Clear All -> Highlight data range
| Answers Explanation & Hints:
This will clear the formatting of the highlighted data range, removing any mixed formatting that may exist. The analyst can then apply the desired formatting to the data. |