Excel Questions

March 14, 2023
| No Comments
0 votes, 0 avg
174

Excel Questions

1 / 15

1.  Which is not a Text function in MS Excel?

2 / 15

2. How can we provide a dynamic range in ‘data Source’ of pivot tables?

3 / 15

3. What function will result in the total number of entries in the cell range B5 to B14

4 / 15

4. You can select the current row in MS-Excel Worksheet by pressing?

5 / 15

5. The intersection of a column and a row in a worksheet is called ____.

6 / 15

6. Under which Tab, the chart options are available in MS Excel?

7 / 15

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

8 / 15

8. Which of the following is NOT a box in the PivotTable Fields List?

9 / 15

9. What is the keyboard shortcut to insert a SUM formula in MS Excel?

10 / 15

10. The currently selected cell address is displayed in ____.

11 / 15

11. Press _____ to bring up search box.

12 / 15

12. This is not a function category in Excel.

13 / 15

13.  IF Statement can be written to carry out an action

14 / 15

14.  What is the keyboard shortcut to switch between open Excel windows?

15 / 15

15. In MS Excel, ‘Merge and Center’ is used to ____.

Your score is

The average score is 43%

LinkedIn Facebook VKontakte

By WordPress Quiz plugin

Written by Shubhranshu Shekhar, who has trained 20000+ students in coding.

Questions, Quiz