MS Excel Quiz Questions and Answers

 In which format, the file has to be saved if the user has written codes?

What is the purpose of subroutines in VBA?

What does object qualifier in VBA do?

Which is the right syntax for the function NOW in Excel?

 What is the use of Permut in Excel?

What is the use of the trunc function in Excel?

Write the syntax of a unicode function in Excel?

What is the use of Geomean in excel?

What is the use of the Index function in excel?

Visual Basic Application is also termed as?

Private Sub CommandButton1_Click()

Dim a As Integer, b As Integer, result As String

a = 65

b = 123

If a >= 60 And b > 100 Then

    result = “pass”

Else

    result = “fail”

End If

Range(“C1”).Value = result

End Sub

Which function returns the number of periods for an investment?

What is the use of the FV function in Excel?

What is the use of the Kurt function in Excel?

 What are the functions used to get the array length?

Which is not part of the VBA array and which has to be added using an external library?

What is the term used to refer to the place where the user writes the code?

When is the variable declared explicitly?

What is the use of the ISTEXT() function?

 What is the use of NA function in Excel?