Excel Questions

0 votes, 0 avg
163

Excel Questions

1 / 15

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

2 / 15

2. Shortcut key CTRL + D is used to ____.

3 / 15

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

4 / 15

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

5 / 15

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

6 / 15

6. The total number of rows in a worksheet?

7 / 15

7. Press _____ to bring up search box.

8 / 15

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

9 / 15

9. This is not a function category in Excel.

10 / 15

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

11 / 15

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

12 / 15

12.  What function displays row data in a column or column data in a row?

13 / 15

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

14 / 15

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

15 / 15

15.  MS-Excel uses the ______ Function when creating a data table

Your score is

The average score is 44%

Written by Shubhranshu Shekhar, who has trained 20000+ students in coding.