Excel Online Test Series 1991

132

Please Type Your Correct Name To See Test Result

1 / 39

What is a ‘Macro’ in MS Excel?

A feature for complex calculations

A feature that automatically fills in data based on a pattern

None of these

A set of pre-recorded commands to automate repetitive tasks

2 / 39

In which Tab ‘Wrap text’ feature in present in MS Excel?

Insert

View

Layout

Home

3 / 39

What do Excel Formula start with?

Formula

Function

Format

4 / 39

In Excel, by default save workbook name?

Sheet1

Document1

Book1

Excel file

5 / 39

What function do you use to calculate the average of a set of numbers in Excel?

MEDIAN

AUTOSUM

AVERAGE

MEAN

6 / 39

How do you freeze panes in Excel?

Double click the cell where you want to freeze panee

Use the shortcut Ctrl+F

Go to the view tab and click "Freeze panes"

Right click on a ce;; and select "Freeze panes"

7 / 39

What is MS Excel primary used for?

Database management

Word processing application

Spreadsheet calculations and data analysis

creating Presentation

8 / 39

MS Excel Stand for ________________ .

Managment Excel data

Microsoft Excess

Micromax Excel

Microsoft Excel

9 / 39

_________ is the programming language used to write a Macro in Excel?

C++

C+

Visual Basic

Java

10 / 39

Which command is used to close the Current Window of Excel?

Ctrl+W

Ctrl+F4

Alt+W

Shift+W

11 / 39

In MS Excel, the keyboard shortcut “Ctrl+S” can be used to ___________ .

Start New Worksheet

Save

Save as

12 / 39

In Excel, by default row height is__________ .

8.34

8.43

13 / 39

In MS Excel spreadsheets, Rows are designated as……… .

A1, B1, C1, D1, ……..

A, B, C, D, ………..

A1, A2, A3, A4,…….

1, 2, 3, 4, ……..

14 / 39

Another name for a pre-programmed formula in Excel is _______ .

Function

Cell

Option

Range

15 / 39

A file that contains one or more worksheets to organize data is known as __________ .

Workbook

Worksheet

Datasheet

Excelbook

16 / 39

Minimum and Maximum Excel Sheet Zoom out and Zoom in Percentage level?

400 and 10%

500 and 10%

10 and 500%

10 and 400%

17 / 39

The _______ feature of MS Excel quickly completes a series of data.

Auto fill

Auto Complete

Auto Adjust

Auto SUM

18 / 39

In Excel, what is used of Flash fill option?

A method to quickly delete cell contents

A tool to fill cells with a flash color

A feature that automatically fills in data based on a pattern

All of above

19 / 39

______ is not a function in Excel.

MIN

SUM

SUBTRACT

MAX

20 / 39

What function would you use to find the largest number in a range of cells?

=BIGGEST()

=MAX()

=LARGE()

=HIGHEST()

21 / 39

In Excel, Minimum and maximum Font size?

1 to 409

409 to 1

1638 to 1

1 to 1638

22 / 39

What does the “Merge & Center” feature do in Excel?

Combines multiple cells into and centers the content

Merge data from different cells

Merge data from different worksheets

Merge Duplicate data

23 / 39

What is VLOOKUP in Excel?

A function to validate data

A tool to visualize data lookup trends

A function to look up and retrieve data in a table

A feature to look for errors in formulas

24 / 39

How can you quickly remove duplicates data or value in Excel?

Use the 'Find and Replace' feature

Use the 'Data Validation' feature

Manually delete duplicates value

Use the 'Remove Duplicates' feature

25 / 39

In MS Excel, what is used of Name Box?

to show Active cell Address

to show Row Address

to show Column Address

to show applied Function

26 / 39

What is the row limit of MS excel?

16384

1048657

1048675

1048576

27 / 39

In Excel, Use of Alt, H, O, I _____________ .

Auto fill row height

Auto fit row height

Auto fit column width

Auto fill column width

28 / 39

In MS Excel, use the ___________ function to calculate the result in the data table.

Table

Result

Auto sum

Caltab

29 / 39

What is an Excel Feature that displays only the data in column (s) according to specified criteria?

Filtering

Formula

Pivot Table

Sorting

30 / 39

In MS Excel, Spreadsheets COLUMN are labelled as ____________ .

1, 2, 3, ………..

A, B, C, …………..

A1, B1, C1, ……..

A1, A2, A3, ……….

31 / 39

Which Excel feature automatically fills in values when you drag the handle?

Auto fill

Quick fill

Auto sum

Drag fill

32 / 39

What is the use of the “Sort” feature in MS Excel?

To add data to cells

To arrange data in a specific order

To change data format

To merge cells

33 / 39

How can you sum the values in cells A1 through A5 in Excel?

All of above

=SUM(A1,A2,A3,A4,A5)

=SUM(A1:A5)

=A1+A2+A3+A4+A5

34 / 39

In Excel, last cell address name of _________ .

1048567XFD

XFD1048567

1048576XFD

XFD1048576

35 / 39

The intersection of a column and row in a worksheet is called____ .

Column

Row

Cell

All of Above

36 / 39

How do you create a drop-down list in a cell in MS Excel?

Use the 'Drop Down' feature

Use the 'Data Validation' feature

Use the 'List Box' tool

Type in each item separated by a comma

37 / 39

………….. is correct syntax of IF() function.

=IF(logical_test,{[value_if_true}],{[value_if_false}])

=IF(logical_test,[value_if_true],[value_if_false])

=IF(logical_test:[value_if_true],[value_if_false])

All of above.

38 / 39

What is IF() function do in MS Excel?

Checks whether a condition is met and returns one value if true and another value if false

Filters data based on a value

Insert conditions

Increase font size

39 / 39

Run Commands of Excel?

Sheet

MS Excel

Excel

Xlsx

Your score is

Pos.	Name	Score	Duration	Points
1	Anushree Pandey	100 %	1 minutes 2 seconds	39 / 39
2	Anjali	100 %	1 minutes 15 seconds	39 / 39
3	Ashish patel	100 %	1 minutes 16 seconds	39 / 39
4	Kavita Choudhary	100 %	1 minutes 41 seconds	39 / 39
5	Diya	100 %	1 minutes 43 seconds	39 / 39
6	Ashish patel	100 %	1 minutes 46 seconds	39 / 39
7	Mihir	100 %	1 minutes 55 seconds	39 / 39
8	Mihir	100 %	1 minutes 58 seconds	39 / 39
9	Alimuddin	100 %	2 minutes 14 seconds	39 / 39
10	Shahid shaikh	100 %	2 minutes 16 seconds	39 / 39
11	Anchal pandey	100 %	2 minutes 17 seconds	39 / 39
12	Aarti kannaujiya	100 %	2 minutes 21 seconds	39 / 39
13	Savita Kumari	100 %	2 minutes 37 seconds	39 / 39
14	Savita Kumari	100 %	2 minutes 44 seconds	39 / 39
15	alam	100 %	3 minutes 9 seconds	39 / 39
16	chahat bind	100 %	3 minutes 35 seconds	39 / 39
17	ANIKET SINGH	100 %	4 minutes 21 seconds	39 / 39
18	bhagesh shah	100 %	4 minutes 41 seconds	39 / 39
19	RISHABHB VISHWAKARMA	100 %	5 minutes 15 seconds	39 / 39
20	sumit	100 %	6 minutes	39 / 39
21	VAIBHAV VISHWAKARMA	100 %	6 minutes 33 seconds	39 / 39
22	rishabh vishwawkarema	100 %	8 minutes 28 seconds	39 / 39
23	Rupali kashyap	97 %	1 minutes 26 seconds	38 / 39
24	Kavita Choudhary	97 %	1 minutes 58 seconds	38 / 39
25	Yash	97 %	2 minutes 10 seconds	38 / 39
26	Alimuddin	97 %	2 minutes 16 seconds	38 / 39
27	kavita choudhary	97 %	2 minutes 17 seconds	38 / 39
28	Shahid	97 %	2 minutes 29 seconds	38 / 39
29	Alimuddin ismaily	97 %	2 minutes 36 seconds	38 / 39
30	Anchal pandey	97 %	2 minutes 41 seconds	38 / 39
31	Chahat bind	97 %	4 minutes 26 seconds	38 / 39
32	ANIKET SINGH	97 %	4 minutes 30 seconds	38 / 39
33	ADITYA KUMAR GUPTA	97 %	7 minutes 18 seconds	38 / 39
34	VAIBHAV VISHWAKARMA	97 %	14 minutes 3 seconds	38 / 39
35	Alimuddin	95 %	2 minutes 36 seconds	37 / 39
36	Neha	95 %	2 minutes 41 seconds	37 / 39
37	Shahid	95 %	2 minutes 41 seconds	37 / 39
38	Aarti kannaujiya	95 %	2 minutes 45 seconds	37 / 39
39	Mihir	95 %	2 minutes 56 seconds	37 / 39
40	Harshita Singh	95 %	3 minutes 9 seconds	37 / 39
41	Alimuddin shaikh	95 %	3 minutes 17 seconds	37 / 39
42	Aarti kannaujiya	95 %	3 minutes 20 seconds	37 / 39
43	Savita Kumari	95 %	3 minutes 38 seconds	37 / 39
44	ANIKET SINGH	95 %	4 minutes 31 seconds	37 / 39
45	chahat bind	95 %	6 minutes 8 seconds	37 / 39
46	Priti Patel	95 %	13 minutes 27 seconds	37 / 39
47	Rashi	92 %	2 minutes 17 seconds	36 / 39
48	Mihir	92 %	2 minutes 45 seconds	36 / 39
49	Mihir	92 %	3 minutes 19 seconds	36 / 39
50	SIDDHARTH	92 %	3 minutes 26 seconds	36 / 39
51	Anchal pandey	92 %	3 minutes 42 seconds	36 / 39
52	Neha	92 %	4 minutes 23 seconds	36 / 39
53	alam	92 %	4 minutes 34 seconds	36 / 39
54	ANIKET SINGH	92 %	5 minutes 17 seconds	36 / 39
55	alam	92 %	5 minutes 22 seconds	36 / 39
56	Komal Srivastava	92 %	13 minutes 40 seconds	36 / 39
57	Mihir	90 %	3 minutes 9 seconds	35 / 39
58	RISHABH VISHWAKARMA	90 %	4 minutes 14 seconds	35 / 39
59	Anchal pandey	90 %	5 minutes 53 seconds	35 / 39
60	ADITYA KUMAR GUPTA	90 %	14 minutes 5 seconds	35 / 39
61	bhagesh shah	90 %	14 minutes 9 seconds	35 / 39
62	Kavita Choudhary	87 %	3 minutes 46 seconds	34 / 39
63	Harshita Singh	87 %	4 minutes 1 seconds	34 / 39
64	Savita Kumari	87 %	4 minutes 2 seconds	34 / 39
65	Shraddha choudhary	87 %	4 minutes 23 seconds	34 / 39
66	Aarti kannaujiya	87 %	4 minutes 26 seconds	34 / 39
67	Anchal pandey	87 %	5 minutes 18 seconds	34 / 39
68	kavita choudhary	85 %	2 minutes 24 seconds	33 / 39
69	Kavita Choudhary	85 %	2 minutes 39 seconds	33 / 39
70	Kavita Choudhary	85 %	2 minutes 49 seconds	33 / 39
71	Shahid	85 %	3 minutes 2 seconds	33 / 39
72	Firoz Ahmad	85 %	3 minutes 52 seconds	33 / 39
73	Alimuddin	85 %	4 minutes 8 seconds	33 / 39
74	ANIKET SINGH	85 %	9 minutes 4 seconds	33 / 39
75	alam	85 %	9 minutes 25 seconds	33 / 39
76	ANIKET SINGH	85 %	11 minutes 13 seconds	33 / 39
77	Priti Patel	85 %	16 minutes 37 seconds	33 / 39
78	kavita choudhary	82 %	2 minutes 47 seconds	32 / 39
79	kavita choudhary	82 %	6 minutes 14 seconds	32 / 39
80	Anchal pandey	82 %	8 minutes 16 seconds	32 / 39
81	Kavita Choudhary	79 %	2 minutes 2 seconds	31 / 39
82	Alimuddin	79 %	4 minutes 14 seconds	31 / 39
83	Neha	79 %	4 minutes 56 seconds	31 / 39
84	Tausif raza	79 %	5 minutes 4 seconds	31 / 39
85	shahid	79 %	16 minutes 40 seconds	31 / 39
86	Alimuddin shaikh	74 %	4 minutes 20 seconds	29 / 39
87	Mihir	72 %	4 minutes 42 seconds	28 / 39
88	Aarti kannaujiya	72 %	4 minutes 45 seconds	28 / 39
89	Wee	72 %	5 minutes 2 seconds	28 / 39
90	Komal Srivastava	72 %	16 minutes 24 seconds	28 / 39
91	Prashant Patel	69 %	3 minutes 27 seconds	27 / 39
92	Yu	69 %	4 minutes 53 seconds	27 / 39
93	Shraddha choudhary	69 %	7 minutes 12 seconds	27 / 39
94	Aarti kannaujiya	69 %	8 minutes 12 seconds	27 / 39
95	Sumit	69 %	11 minutes 23 seconds	27 / 39
96	Neha 1	67 %	9 minutes 44 seconds	26 / 39
97	abc	67 %	16 minutes 40 seconds	26 / 39
98	Savita Kumari	64 %	2 minutes 9 seconds	25 / 39
99	Babu	64 %	2 minutes 30 seconds	25 / 39
100	kavita choudhary	64 %	2 minutes 45 seconds	25 / 39

Related Posts