Excel Questions

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

Excel Questions

1 / 15

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

2 / 15

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

3 / 15

3. Which of the following is an example of text in a spreadsheet?

4 / 15

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

5 / 15

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

6 / 15

6.  Excel is a ____ program developed by Microsoft.

7 / 15

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

8 / 15

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

9 / 15

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

10 / 15

10. Which function is used to get days, months, or years between two dates?

11 / 15

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

12 / 15

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

13 / 15

13. Statistical calculations and preparation of tables and graphs can be done using

14 / 15

14. Advanced Functions are used in higher-level operations such as in conditional and comparison equations to compute interest rates, due dates and payment terms, and financial projections.

15 / 15

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

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