Microsoft Excel Interview Questions and Answers
Ques 31. 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
Ques 32. How can I printout the formulas in an Excel spreadsheet - rather than the results?Ans. The trick is to change the way Excel displays the worksheet before you choose to print. Check the box Tools, Options, View, Formulas and you'll see the formulas appear in each cell (with the columns changed to fit). When you print the sheet the formulas will be printed instead of the values.
Ques 33. Is it possible to change the color and font of the sheet tabs?Ans. Yes we can change the color of sheet tabs. By right clicking on sheet tabs and you will get option change color but i didn't find any option to change the font of sheet tabs.
Ques 34. What you could do to stop the pivot table from loosing the column width upon refreshing?Ans.
Ques 35. How do I find the first empty cell in column A?Ans. If ActiveSheet.UsedRange.Count < 2 Then
MsgBox Columns("A:A").Find(What:="", LookAt:=xlWhole).Row
Most helpful rated by users: