Microsoft Excel Quiz 1 | Multiple choice questions of MS Excel

Preview

Microsoft Excel Quiz 1 | Multiple choice questions of MS Excel



0%
2

Ms Excel Quiz -I | Multiple Choice Questions MS Excel

1 / 20

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

2 / 20

2. How are cells named in Excel?

3 / 20

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

4 / 20

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

5 / 20

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

6 / 20

6. In Excel, Columns are labelled as____

7 / 20

7. In Excel, Rows are labelled as____

8 / 20

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

 

9 / 20

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

10 / 20

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

11 / 20

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

12 / 20

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

13 / 20

13. What does the VLOOKUP function do?

14 / 20

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

15 / 20

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

16 / 20

16. What is the shortcut to save EXCEL file.

17 / 20

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

18 / 20

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

19 / 20

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

20 / 20

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

Your score is

The average score is 65%

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