Microsoft%20Excel%20Interview%20Questions%20and%20Answers

Question: How can I identify which cells in my spreadsheet have a formula and which do not in MS Excel?

Answer: Option A: 
1. Choose Edit + Go To (or press Ctrl + F5). 
2. Select Special. 
3. Select Formulas. 
4. Click OK. 

Option B: 
1. Choose Tools + Options. 
2. Select the View Tab 
3. In Window Options choose the check box 'Formulas'. 
4. Click OK