Microsoft Excel Quiz 2 | Online Test of Excel 2022

Preview

Microsoft Excel Quiz 2 | Online Test of Excel 2022



0%
9

Ms Excel Quiz | 20 Questions to test your Excel knowledge

1 / 20

1. An Excel file is a  _________

2 / 20

2. ____ feature of Excel can be used to make long text go across multiple lines within a cell. 

3 / 20

3. Functions in MS Excel must begin with ________

4 / 20

4. We can check the conditions against _____ when applying conditional formatting.

5 / 20

5. Which of the following is not a function in MS Excel?

6 / 20

6. Shortcut key to create a new workbook in Excel is _________

7 / 20

7. Shortcut keys to edit formula in a cell is  ________

8 / 20

8. Which symbol is used for multiplication in Excel?

9 / 20

9.

Which term is used to refer to mathematical equations in Excel ?

10 / 20

10. Shortcut key to jump from one worksheet to next worksheet in a workbook is called ____________

11 / 20

11. What symbol is used to designate an absolute cell reference?

12 / 20

12. _________ key can be used to move to next cell in Excel sheet.

13 / 20

13. Excel  feature that shows the data in a column according to specified criteria.

14 / 20

14. Gridlines can be enabled or disabled from  _______ tab.

15 / 20

15. Centering the text within a cell is known as __________ 

16 / 20

16. ______ function in MS Excel counts number of text values in a range of cells. 

17 / 20

17. Which tab can be used to open Excel sheet in Page Break Preview?

18 / 20

18. The cell in an Excel worksheet in which we can type data is called _________

19 / 20

19. _________  are vertical in Excel.

20 / 20

20. Which tool can be used to join cells and place their content at the middle of joined cell ?

Your score is

The average score is 64%

0%



 

MS Excel 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, Online Test of Excel 2022
Back to: Question Papers & Quizzes
Spread the love