Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I'm taking a certification course for Microsoft Excel 2010. I'm taking a class that goes over it and we all just got hit with this question:

61. In Excel 2010, which of the following can you use to erase or clear a cell or range of cells?

    A. Cell Styles Button, Shortcut menu, and Fill Handle

    B. Quick Access Toolbar, Shortcut menu, and Cell Styles button

    C. Fill Handle, Delete Key, and Quick Access Toolbar

    D. Cell Styles Button, Shortcut menu, and Undo button

The answer we got from the test booklet is A. The problem is, none of us can figure out how to clear a cell using the "Cell Styles Button".

Does anyone know how to do this, or is there a better answer?

share|improve this question
1  
That IS sketchy, I can't see how that could help either, since there doesn't seem to be a "Turn This Blank" style. :) –  techie007 Oct 24 '11 at 15:06
add comment

3 Answers

up vote 1 down vote accepted

The closest I think you can come is to blank the cell by applying a custom style that looks like this:

_);_);_);_)

While this is nicer than, say, setting a white font on a white background, it still isn't really a erasing or clearing the cell (per their question), but it is 'blanking' the cell (per yours). Caveats:

  1. That style would be added to the cell styles, so that it could be applied with a click as described.

  2. As mentioned, this doesn't actually delete the cell value; if you refer to that cell from another one, you will see the value is still there.

EDIT: Plus, you have the possibility of bonus points for answering with one of the weirdest emoticons yet!

share|improve this answer
add comment

Since three of the four answers include the Cell Styles button, and as it makes no sense to use the Cell Styles button for this, and furthermore, since the one answer that doesn't include the Cell Styles button also doesn't include the right-click menu (which has the Clear Contents button), and moreover, since the Fill Handle is a dubious method for deleting cell contents (you could almost as sensibly say cut the cell contents and paste to another temporary worksheet), and finally, since these types of questions say so little about one's Excel skills:

I propose instead to change the question to the following:

"What is the name of the Cell Styles button?"

share|improve this answer
    
Would you say C is a more correct answer for that reason though? It is possible to clear the contents with all three listed, just not the best way. –  Xan Oct 24 '11 at 21:04
    
If I have to be serious, I'd say sure, since they all theoretically work. But including the QAT bugs me, as it's only true if you've added a Clear Contents button to it. –  Doug Glancy Oct 24 '11 at 21:17
add comment

Cell styles doesn't delete anything, it would just hide the data; it's approximately the same as setting text color to the same as background color.

If you want to delete everything, that is, contents (formula or value), format (colors, frames, number format etc), comments ++:

Home --> Clear --> Clear all

From this Clear-menu, you can also choose to delete just format etc.

Home refers to the "ribbon".

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.