Excel Questions

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

Excel Questions

1 / 15

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

2 / 15

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

3 / 15

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

4 / 15

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

5 / 15

5.  Which option displays the total number of cells, formulas, charts, tables, sheets, etc. in a Workbook?

6 / 15

6. What command allows you to highlight the cell(s) in a data table that matches your set-up information?

7 / 15

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

8 / 15

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

9 / 15

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

10 / 15

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

11 / 15

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

12 / 15

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

13 / 15

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

14 / 15

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

15 / 15

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

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