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?
IT Exam Items Repository › Category: Data Analytics Essentials › 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?
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
Explanation: The steps to remove formatting of cells in Excel are:
- Highlight the data range desired to have formatting removed.
- Click the Home tab.
- Select Clear in the Editing portion.
- Select Clear Formats in the Clear drop-down menu.
Related exam: Module 2.4.2 Quiz – Getting started with Data Gathering and Investigation
About The Author
The ITExamAnswers Editorial Team is a dedicated group of certified IT professionals and network engineers. We rigorously review, verify, and update all exam materials to ensure you receive the most accurate and reliable resources for your certification journey.
