Excel Questions

0 votes, 0 avg
135

Excel Questions

1 / 15

1.  What is the keyboard shortcut to switch between open Excel windows?

2 / 15

2. How can you remove borders applied in cells?

3 / 15

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

4 / 15

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

5 / 15

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

6 / 15

6. 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.

7 / 15

7.  Which function is used to create a date with year, month, and day?

8 / 15

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

9 / 15

9. What is the keyboard shortcut to insert a SUM formula in MS Excel?

10 / 15

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

11 / 15

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

12 / 15

12. Which function is used to remove extra spaces from the text in MS Excel?

13 / 15

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

14 / 15

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

15 / 15

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

Your score is

The average score is 44%