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

Deprecated: trim(): Passing null to parameter #1 ($string) of type string is deprecated in /home/u797631661/domains/codermantra.com/public_html/wp-includes/formatting.php on line 449

Deprecated: trim(): Passing null to parameter #1 ($string) of type string is deprecated in /home/u797631661/domains/codermantra.com/public_html/wp-includes/formatting.php on line 449
0 votes, 0 avg
137

Excel Questions

1 / 15

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

2 / 15

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

3 / 15

3. What is the correct value of the function? =ROUND (1.2345,2)

4 / 15

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

5 / 15

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

6 / 15

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

7 / 15

7. Which function is used to return the number of cells in a range that meet a condition set forth in the formula?

8 / 15

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

9 / 15

9. What is the keyboard shortcut to insert a new sheet in the current workbook in MS Excel?

10 / 15

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

11 / 15

11.  Excel is a ____ program developed by Microsoft.

12 / 15

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

13 / 15

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

14 / 15

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

15 / 15

15.  Which is not a Text function in MS Excel?

Your score is

The average score is 43%