Excel Questions

0 votes, 0 avg
173

Excel Questions

1 / 15

1. Which function will you use to enter current date and time in a worksheet cell?

2 / 15

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

3 / 15

3.  Which option allows you to display all numbers which are less than 0 (negative numbers) in red color in MS Excel?

4 / 15

4. Which bar show the used formula of selected active cell?

5 / 15

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

6 / 15

6. Which of following functions MS-Excel have 1 SUM 2 CONCATENATE?

7 / 15

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

8 / 15

8. ____ appear at the bottom of the Excel window.

9 / 15

9. Which feature is used to wrap extra-long text into multiple lines in MS Excel?

10 / 15

10. A features that displays only the data in column (s) according to specified criteria

11 / 15

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

12 / 15

12. Which logical function returns TRUE if all arguments evaluate TRUE; FALSE if not?

13 / 15

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

14 / 15

14.  Excel is a ____ program developed by Microsoft.

15 / 15

15. What command allows you to highlight the cell(s) in a data table that matches your set-up information?

Your score is

The average score is 43%

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