Microsoft Excel Quiz 1 | Multiple choice questions of MS Excel

Preview

Microsoft Excel Quiz 1 | Multiple choice questions of MS Excel



0%
1

Ms Excel Quiz -I | Multiple Choice Questions MS Excel

1 / 20

1. Which function finds maximum among a list of values in EXCEL?

2 / 20

2. Data in MS Excel can be sorted in ________ Order

3 / 20

3. Excel is a program that is used to prepare a

4 / 20

4. Which tab contains "wrap text " feature in MS Excel?

5 / 20

5. The ___ feature of MS Excel quickly completes a series of data

6 / 20

6. What is the shortcut to save EXCEL file.

7 / 20

7. Which function of EXCEL can be used to display current date only.

8 / 20

8. In Excel, which of the following represents a range from cell B1 through E5

9 / 20

9. Which function of Excel checks whether a condition is true or not?

10 / 20

10. Data is organized in a spreadsheet in the form of  _______________

 

11 / 20

11. In Excel, Columns are labelled as____

12 / 20

12. How are cells named in Excel?

13 / 20

13. Which tab is used to include pivot table, charts, hyperlinks to spread sheet?

14 / 20

14. We can specify background of an Excel worksheet using ______ tab.

15 / 20

15. Which tab is used for creating, formatting and editing a spreadsheet?

16 / 20

16. What is the default extension of  excel file in EXCEL 2010 and above?

17 / 20

17. Mathematical calculations and preparation graphs can be done using ________

18 / 20

18. The box inside a worksheet where we enter data in Excel is called a _____________

19 / 20

19. What does the VLOOKUP function do?

20 / 20

20. In Excel, Rows are labelled as____

Your score is

The average score is 50%

0%



 

MS Word Quiz – 1

MS Word Quiz – 2

MS Word Quiz – 3

Spread the love
Lesson tags: Microsoft Excel Quiz 1, Multiple choice questions of MS Excel
Back to: Question Papers & Quizzes
Spread the love