MS Excel MCQ Quiz with Answers

Which of the following stores the frequently used commands?

Which is also known as a floating toolbar?

What information is available at the account option in the home tab?

What are the features in the review tab?

What is the primary objective of the workbook?

How to get suggestions of the spellings in a workbook?

Why is adding a comment in a cell important?

What is the shortcut key to insert a new worksheet?

 What is the shortcut key to create a new workbook?

What is the output of below calculation?

23+8/(2*2)

What is the use of correl function in excel?

Write the syntax of COUPDAYS function in excel?

Which function returns true if there is an #N/A error in the cell?

 How to apply a color to the numbers in Excel?

12/2+4^2

How to refresh a pivot table?

What does the RAND function do?

What is the output of below code:

Code:

Sub calculate()

Dim a As Integer

ans1 = 5*10

MsgBox ans1

End Sub

What is the output of below code?

Code:

Private Sub logical_Click()

Dim a As Integer, b As Integer, output1 As String

a = 65

b = 55

If a >= 60 And Not b > 50 Then

    result = “pass”

Else

    result = “fail”

End If

Range(“C1”).Value = output1

End Sub

What is the assigned value to index 1 in the array?

arrData(0) = “Dharani” 

     arrData(1) = “Prasad” 

     arrData(2) = “Lily”