Placement-ready Courses: Enroll Now, Thank us Later!
Microsoft Excel is a spreadsheet program that helps users to store huge amounts of data and we can edit it, view etc. It is useful widely in many business sectors. This excel MCQ quiz contains the questions which will help you to get strong at MS Excel basics. So take the quiz and evaluate yourself at MS-Excel Basics.
Time limit: 0
Quiz Summary
0 of 20 Questions completed
Questions:
Information
You have already completed the quiz before. Hence you can not start it again.
Which of the following stores the frequently used commands?
Correct
Incorrect
Question 2 of 20
2. Question
Which is also known as a floating toolbar?
Correct
Incorrect
Question 3 of 20
3. Question
What information is available at the account option in the home tab?
Correct
Incorrect
Question 4 of 20
4. Question
What are the features in the review tab?
Correct
Incorrect
Question 5 of 20
5. Question
What is the primary objective of the workbook?
Correct
Incorrect
Question 6 of 20
6. Question
How to get suggestions of the spellings in a workbook?
Correct
Incorrect
Question 7 of 20
7. Question
Why is adding a comment in a cell important?
Correct
Incorrect
Question 8 of 20
8. Question
What is the shortcut key to insert a new worksheet?
Correct
Incorrect
Question 9 of 20
9. Question
What is the shortcut key to create a new workbook?
Correct
Incorrect
Question 10 of 20
10. Question
What is the output of below calculation?
23+8/(2*2)
Correct
Incorrect
Question 11 of 20
11. Question
What is the use of correl function in excel?
Correct
Incorrect
Question 12 of 20
12. Question
Write the syntax of COUPDAYS function in excel?
Correct
Incorrect
Question 13 of 20
13. Question
Which function returns true if there is an #N/A error in the cell?
Correct
Incorrect
Question 14 of 20
14. Question
How to apply a color to the numbers in Excel?
Correct
Incorrect
Question 15 of 20
15. Question
12/2+4^2
Correct
Incorrect
Question 16 of 20
16. Question
How to refresh a pivot table?
Correct
Incorrect
Question 17 of 20
17. Question
What does the RAND function do?
Correct
Incorrect
Question 18 of 20
18. Question
What is the output of below code:
Code:
Sub calculate()
Dim a As Integer
ans1 = 5*10
MsgBox ans1
End Sub
Correct
Incorrect
Question 19 of 20
19. Question
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
Correct
Incorrect
Question 20 of 20
20. Question
What is the assigned value to index 1 in the array?
arrData(0) = “Dharani”
arrData(1) = “Prasad”
arrData(2) = “Lily”
Correct
Incorrect
Summary
Hope you got an idea about MS-Excel basics. If you didn’t know any answer, kindly go through the question along with the answer and explanation. Share your score and challenge others.
If you are Happy with DataFlair, do not forget to make us happy with your positive feedback on Google
DataFlair Team is a group of passionate educators and industry experts dedicated to providing high-quality online learning resources on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. With years of experience in the field, the team aims to simplify complex topics and help learners advance their careers. At DataFlair, we believe in empowering students and professionals with the knowledge and skills needed to thrive in today’s fast-paced tech industry. Follow us for Free courses, expert insights, tutorials, and practical tips to boost your learning journey.