Which command clears everything (contents and formatting) from the selected cell?

Which command clears everything (contents and formatting) from the selected cell?

• A. On the Home tab, in the Editing group, click the Clear button. Choose Clear All.
• B. On the Home tab, in the Editing group, click the Clear button. Choose Clear Formats.
• C. On the Home tab, in the Editing group, click the Clear button. Choose Clear Contents.
• D. On the Home tab, in the Editing group, click the Clear button. Select Clear All.

Answer: (D)

To remove everything from a cell, you use Clear All. The Clear button on the Home tab’s Editing group opens a dropdown with options, and you need to select Clear All. This clears both the cell’s contents (values or formulas) and its formatting (fonts, colors, borders, number formats), effectively leaving the cell blank with default formatting. The other options clear only one aspect—either contents or formats—so they don’t achieve the “everything” result.

To remove everything from a cell, you use Clear All. The Clear button on the Home tab’s Editing group opens a dropdown with options, and you need to select Clear All. This clears both the cell’s contents (values or formulas) and its formatting (fonts, colors, borders, number formats), effectively leaving the cell blank with default formatting. The other options clear only one aspect—either contents or formats—so they don’t achieve the “everything” result.