Microsoft Excel Interview Questions and Answers
Ques. How can I identify which cells in my spreadsheet have a formula and which do not in MS Excel?Ans. Option A:
1. Choose Edit + Go To (or press Ctrl + F5).
2. Select Special.
3. Select Formulas.
4. Click OK.
1. Choose Tools + Options.
2. Select the View Tab
3. In Window Options choose the check box 'Formulas'.
4. Click OK
Is it helpful? Yes No
Most helpful rated by users: