Troubleshooting the worksheet?

[fatmermaid]

This is the very last thing on my section for excel in class so any help would be appreciated. The task says to "demonstrate troubleshooting the worksheet" and what I would like to know is how to do that. How IS this done? I feel stupid for not knowing how to do it. Please help!!!!!

[Mordred]

Wouldn't that imply that you look for errors on your worksheet and fix them?

[fatmermaid]

Wouldn't that imply that you look for errors on your worksheet and fix them?

I have no idea. Any kind of help is appreciated. Please????? If it does imply to look for errors, how do I do that in the first place?

[Mordred]

Hard to tell without seeing the worksheet.

[fatmermaid]

Hard to tell without seeing the worksheet.

How so? I just need to know how to do it in general. Why would you need to see the worksheet? Do you need an example to show me how to do it?

[Mordred]

I don't know that there is a way to do what you want in "general". There are probably a thousand things that can happen to a worksheet to make it have errors or require troubleshooting. Think of it this way, it would be like you telling a mechanic that you want your car fixed without giving him/her your car to look at!

[romperstomper]

Formulas tab - Error Checking button.
Data tab - Data Validation dropdown - circle invalid data.

[Mordred]

Luckily for you, romperstomper is a mechanic that can fix a car before he looks at it!