Excel Questions

0 votes, 0 avg
172

Excel Questions

1 / 15

1. You can select the current row in MS-Excel Worksheet by pressing?

2 / 15

2. Which bar show the used formula of selected active cell?

3 / 15

3. Which function returns the current date?

4 / 15

4.  IF Statement can be written to carry out an action

5 / 15

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

6 / 15

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

7 / 15

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

8 / 15

8. What function will produce results that indicate whether a student has passed or failed a course by enter the text “Pass” or “Fail”?

9 / 15

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

10 / 15

10.  A function inside other function is called

11 / 15

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

12 / 15

12. The intersection of a column and a row in a worksheet is called ____.

13 / 15

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

14 / 15

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

15 / 15

15. What is the collection of worksheets called?

Your score is

The average score is 43%

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