Excel Questions

0 votes, 0 avg
184

Excel Questions

1 / 15

1. Which symbol is used to specify the fixed columns or rows in the formula?

2 / 15

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

3 / 15

3. What dialog box allows you to change a field name in a PivotTable?

4 / 15

4.  Steps for protecting a sheet by password in MS Excel?

5 / 15

5.  Under which tab and in which function group will you find the option to insert a Pivot Table?

6 / 15

6.  The ____ function is used to convert to text in a number format in MS Excel.

7 / 15

7. Which function is used to remove extra spaces from the text in MS Excel?

8 / 15

8. You can select the current Column in MS-Excel Worksheet by pressing?

9 / 15

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

10 / 15

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

11 / 15

11.  A function inside other function is called

12 / 15

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

13 / 15

13. Which function is used to get a date n working days in the future or past?

14 / 15

14. Which function is used to trap and handle errors?

15 / 15

15.  MS-Excel uses the ______ Function when creating a data table

Your score is

The average score is 42%

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

Scroll to Top