Microsoft Excel Quiz 2 | Online Test of Excel 2022

Preview

Microsoft Excel Quiz 2 | Online Test of Excel 2022



0%
5

Ms Excel Quiz | 20 Questions to test your Excel knowledge

MS Excel Quiz - 1

1 / 20

1. Which symbol is used for multiplication in Excel?

2 / 20

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

3 / 20

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

4 / 20

4. An Excel file is a  _________

5 / 20

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

6 / 20

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

7 / 20

7. Functions in MS Excel must begin with ________

8 / 20

8. _________  are vertical in Excel.

9 / 20

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

10 / 20

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

11 / 20

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

12 / 20

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

13 / 20

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

14 / 20

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

15 / 20

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

16 / 20

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

17 / 20

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

18 / 20

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

19 / 20

19.

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

20 / 20

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

Your score is

The average score is 65%

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