Without Book Interview Questions and Answers | Online Test | Moct Test
Download Android App in your Android Device from Google Play Store
- Search for "Withoutbook Practice Exam Test" in Mobile/Tablet Play Store
Institute Training Search by Name or Email

Exams Attended

Make Homepage

Bookmark this page

Subscribe Email Address

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. 

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?
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.
Is it helpful? Add Comment View Comments
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. 
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?
Ans. 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:

©2016 WithoutBook