MS Excel Quiz Online Test Mcqs

Photo of Maan Ali Maan AliLast Updated: January 29, 2021

MS Excel is a spreadsheet which was first launched by Microsoft in 1985 and now is a part of Microsoft Office. The software is widely used in the professional world that’s why its important to have knowledge about its various functions and shortcut keys. If you think you already have that knowledge, then simply attempt this quiz in order to find out.

MS Excel Quiz Online Test Mcqs Questions with Answers Objective Type PDF

 

Question 1 of 25

Uncategorized

1. To view a cell comment?

 

Question 1 of 25

Question 2 of 25

2. Which types of charts can excel produce?

Question 2 of 25

Question 3 of 25

3. When you insert an Excel file into a Word document, the data are?

Question 3 of 25

Question 4 of 25

4. Which of the following is a correct order of precedence in formula calculation?

Question 4 of 25

Question 5 of 25

5. You want to track the progress of the stock market on a daily basis. Which type of chart should you use?

 

Question 5 of 25

Question 6 of 25

6. Which of the following methods can not be used to edit the contents of a cell?

 

Question 6 of 25

Question 7 of 25

7. When you want to insert a blank imbedded excel object in a word document you can?

 

Question 7 of 25

Question 8 of 25

8. What does the VLOOKUP function do?

Question 8 of 25

Question 9 of 25

9. Which of the following is not a valid data type in excel?

Question 9 of 25

Question 10 of 25

10. You can open the consolidate dialog box by choosing Consolidate from the ….. menu?

Question 10 of 25

Question 11 of 25

11. Macros are “run” or executed from the ….. menu?

Question 11 of 25

Question 12 of 25

12. How are data organized in a spreadsheet?

Question 12 of 25

Question 13 of 25

13. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?

 

Question 13 of 25

Question 14 of 25

14. Except for the …… function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result?

Question 14 of 25

Question 15 of 25

15. Each excel file is called a workbook because?

Question 15 of 25

Question 16 of 25

16. What function  displays row data in a column or column data in a row?

Question 16 of 25

Question 17 of 25

17. Which of the following options is not located in the Page Setup dialog box?

 

Question 17 of 25

Question 18 of 25

18. To save a workbook, you?

 

Question 18 of 25

Question 19 of 25

19. The Paste Special command lets you copy and paste?

Question 19 of 25

Question 20 of 25

20. The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish this?

Question 20 of 25

Question 21 of 25

21. If you begin typing an entry into a cell and then realize that you don’t want your entry placed into a cell, you?

 

Question 21 of 25

Question 22 of 25

22. Gridlines?

Question 22 of 25

Question 23 of 25

23. All worksheet formula?

Question 23 of 25

Question 24 of 25

24. Excel worksheet cells work very similarly to what common element of the windows graphical user interface?

Question 24 of 25

Question 25 of 25

25. You can edit a cell by?

 

Question 25 of 25


 

You Can Learn and Gain more Knowledge through our Online Quiz and Testing system Just Search your desired Preparation subject at Gotest.
Photo of Maan Ali Maan AliLast Updated: January 29, 2021
Photo of Maan Ali

Maan Ali

Hey there! I'm Maan Ali, your online test prep pal. Join me in the adventure of acing exams with ease. I'll share tricks, practice tests, and all you need to rock your studies. Let's make learning fun and success a sure thing!

Your Related

Computer MS Access Shortcuts Keys Info Quiz 1 Online Important Questions Test

MS Word Shortcuts Keys Information Quiz Online Important Questions Answers

Computer Important Abbreviations Quiz Online Mcq’s

Computer General Knowledge Online Test 2 For Important Abbreviation Preparation

Adobe Flash Quiz Online Test Mcqs

ASP.NET Quiz Online Test Mcqs

Show 2 comments

2 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

© Copyright 2024, All Rights Reserved  |  Gotest
Back to top button