Excel Questions

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

Excel Questions

1 / 15

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

2 / 15

2. This is not a function category in Excel.

3 / 15

3.  In MS-Excel to protect a worksheet, you can choose Protection and the Protect Sheet from the _______ menu

4 / 15

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

5 / 15

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

6 / 15

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

7 / 15

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

8 / 15

8. The total number of columns in a worksheet?

9 / 15

9. What is the correct value of the function? =ROUND (1.9867,2)

10 / 15

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

11 / 15

11. Which function is used to get the location of text in a string in MS Excel?

12 / 15

12. Which function is used to return the number of cells in a range that meet a condition set forth in the formula?

13 / 15

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

14 / 15

14. Press _____ to bring up search box.

15 / 15

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

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