Excel Questions


Deprecated: round(): Passing null to parameter #1 ($num) of type int|float is deprecated in /home/u797631661/domains/codermantra.com/public_html/wp-content/plugins/quiz-maker/public/class-quiz-maker-public.php on line 1335

Deprecated: Implicit conversion from float 0.16666666666666666 to int loses precision in /home/u797631661/domains/codermantra.com/public_html/wp-content/plugins/quiz-maker/includes/class-quiz-maker-data.php on line 1008

Deprecated: Implicit conversion from float 0.16666666666666666 to int loses precision in /home/u797631661/domains/codermantra.com/public_html/wp-content/plugins/quiz-maker/includes/class-quiz-maker-data.php on line 1008
0 votes, 0 avg
139

Excel Questions

1 / 15

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

2 / 15

2. Which logical function returns TRUE if one or more arguments evaluates to TRUE; FALSE if all arguments evaluate to FALSE?

3 / 15

3. Which function is used to compare a cell value to an array of cells and return a value that matches the location of the value in the array, and is used when there are more than two columns in the array

4 / 15

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

5 / 15

5. What function will result in the total number of entries in the cell range B5 to B14

6 / 15

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

7 / 15

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

8 / 15

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

9 / 15

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

10 / 15

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

11 / 15

11.  What is the default file name of Microsoft Excel file?

12 / 15

12. Which option is used to quickly convert a range of cells to a table with its own style converted in MS Excel?

13 / 15

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

14 / 15

14. In MS Excel, ‘Merge and Center’ is used to ____.

15 / 15

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

Your score is

The average score is 43%