QUESTION TEN

I'm confused. If I click Edit, I see the options "Cut" and "Delete." If I right-click I see the option "Clear Contents." Which does what?

That can be confusing. We're used to the Cut option in Word, but Cut works differently in Excel. These explanations should help:

• Cut: This tool actually copies text for you to paste somewhere else. It then cuts -- erases -- the text from the original spot. Like Word's Copy-Cut-Paste in a single step.
• Delete: This tool deletes entire cells, rows, or columns, along with the text in those cells, rows, or columns.
• Clear Contents: You like the cells/rows/columns as they are and you don't need to move text (pasting as in the Cut feature). You just need to erase some of the text. Highlight the text to be deleted, right click, and select Clear Contents.

Note: If you've typed text in the wrong row or column, instead of cutting (copying/pasting), highlight the text and drag it to the correct location. It's the fastest way to get from there to here!

Next: Learn more.