Exams Attended

Mock Exams

Make Homepage

Bookmark this page

Subscribe Email Address

Microsoft Excel Interview Questions and Answers

Test your skills through the online practice test: Microsoft Excel Quiz Online Practice Test

Ques 31. How can I identify which cells in my spreadsheet have a formula and which do not in MS Excel?

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 

Is it helpful? Add Comment View Comments

Ques 32. How can I printout the formulas in an Excel spreadsheet - rather than the results?

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.

Is it helpful? Add Comment View Comments

Ques 33. Is it possible to change the color and font of the sheet tabs?

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. 

Is it helpful? Add Comment View Comments

Ques 34. What you could do to stop the pivot table from loosing the column width upon refreshing?

Format loss in pivot table can be stopped simply by changing the pivot table options.  Under the “Pivot Table Options” turn on the “Enable Preserve Formatting” and disable “ Auto Format” option.

Is it helpful? Add Comment View Comments

Ques 35. How do I find the first empty cell in column A?

If ActiveSheet.UsedRange.Count < 2 Then
MsgBox 1
MsgBox Columns("A:A").Find(What:="", LookAt:=xlWhole).Row
End If 

Is it helpful? Add Comment View Comments

Most helpful rated by users:

©2023 WithoutBook