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

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.  Under which tab and in which function group will you find the option to insert a Pivot Table?

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. What dialog box allows you to change a field name in a PivotTable?

4 / 15

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

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 currently selected cell address is displayed in ____.

7 / 15

7. Which of following functions MS-Excel have 1 SUM 2 CONCATENATE?

8 / 15

8. An array is a systematic arrangement of similar objects, usually in rows and columns.

9 / 15

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

10 / 15

10.  What is the keyboard shortcut for creating a chart from the selected cell range?

11 / 15

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

12 / 15

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

13 / 15

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

14 / 15

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

15 / 15

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

Your score is

The average score is 43%

LinkedIn Facebook Twitter VKontakte