Deprecated: Using ${var} in strings is deprecated, use {$var} instead in /home/u797631661/domains/codermantra.com/public_html/wp-content/plugins/quiz-maker/includes/class-quiz-maker-data.php on line 1199

Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the quiz-maker domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /home/u797631661/domains/codermantra.com/public_html/wp-includes/functions.php on line 6121
Excel Test – CoderMantra
Menu

Excel Test


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
139

Excel Questions

1 / 15

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

2 / 15

2. Advanced Functions are used in higher-level operations such as in conditional and comparison equations to compute interest rates, due dates and payment terms, and financial projections.

3 / 15

3. Which function is used to get days, months, or years between two dates?

4 / 15

4. In MS Excel, 'Merge and Center' is used to ____.

5 / 15

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

6 / 15

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

7 / 15

7.  A function inside other function is called

8 / 15

8. The currently selected cell address is displayed in ____.

9 / 15

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

10 / 15

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

11 / 15

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

12 / 15

12. How can we provide a dynamic range in 'data Source' of pivot tables?

13 / 15

13. Which of the following is NOT a box in the PivotTable Fields List?

14 / 15

14. What is the extension of a Microsoft Excel file?

15 / 15

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

Your score is

The average score is 43%

LinkedIn Facebook Twitter VKontakte