Excel Questions

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

Excel Questions

1 / 15

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

2 / 15

2. What is the correct syntax of IF() function?

3 / 15

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

4 / 15

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

5 / 15

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

6 / 15

6. The total number of columns in a worksheet?

7 / 15

7. What is the collection of worksheets called?

8 / 15

8. Which option is used to quickly convert a range of cells to a table with its own style converted in MS Excel?

9 / 15

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

10 / 15

10. Getting data from a cell located in a different worksheet is called?

11 / 15

11. When you insert an Excel file into a Word document, the data are

12 / 15

12. An array is a systematic arrangement of similar objects, usually in rows and columns.

13 / 15

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

14 / 15

14. _____ are equations that perform calculations on values in your worksheet.

15 / 15

15.  What is the first step for creating a Pivot Table?

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