Excel Questions

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

Excel Questions

1 / 15

1.  What is the keyboard shortcut for creating a chart from the selected cell range?

2 / 15

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

3 / 15

3.  What is the keyboard shortcut to display the Format Cells dialog box in MS Excel?

4 / 15

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

5 / 15

5. The NOW function calculates the difference in days between two dates.

6 / 15

6. How can you remove borders applied in cells?

7 / 15

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

8 / 15

8.  What function displays row data in a column or column data in a row?

9 / 15

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

10 / 15

10. What is the keyboard shortcut to insert a new sheet in the current workbook in MS Excel?

11 / 15

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

12 / 15

12. Press _____ to bring up search box.

13 / 15

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

14 / 15

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

15 / 15

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

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