Prepare Interview

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 36. How do I find the first empty cell in column A?

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

Is it helpful? Add Comment View Comments
 

Ques 37. Which event do you use to check whether the Pivot Table is modified or not?

To check whether the pivot table is modified or not we use “PivotTableUpdate” in worksheet containing the pivot table.

Is it helpful? Add Comment View Comments
 

Most helpful rated by users:

©2024 WithoutBook