Excel Basic Online Test Series 5234

544

Excel Basic Online Test Series 5234

1 / 30

How are columns labeled in Excel?

Randomly

Numerically

By date

Alphabetically

2 / 30

Excel में Merge Option के अंदर options की संख्या कितनी हैं ?

3 / 30

Which tab contains the ‘Insert’ chart option?

Insert Tab

View Tab

Data Tab

Home Tab

4 / 30

What chart type is best for showing trends over time?

Bar chart

Line chart

Pie chart

Column chart

5 / 30

Excel में format printer का यूज़ क्या हैं ?

Text The Formatting

All of The Above

Copy the Formatting

Object The Formatting

6 / 30

Which function is used to add the values in a range?

MAX()

TOTAL()

SUM()

COUNTIF()

7 / 30

Excel में Cells की संख्या कितनी हैं ?

Cells-17179869184

Cells-17189969184

Cells-17179869180

Cells-17179969184

8 / 30

What is the use of the ‘Freeze Panes’ feature?

To keep selected rows/columns visible

To save the file

To highlight text

To delete data

9 / 30

Excel में Row ओर Column की संख्या कितनी हैं ?

Row-2048576 Or Column-15384

Row-2048576 Or Column-17384

Row-1248576 Or Column-13384

Row-1048576 Or Column-16384

10 / 30

What is the intersection of a row and a column called?

Box

Cell

Address

Data

11 / 30

What is the shortcut key to save a workbook in Excel?

Ctrl + V

Ctrl + S

Ctrl + C

Ctrl + X

12 / 30

Which function counts only numeric values in a range?

COUNTALL()

COUNT()

COUNTIF()

COUNTA()

13 / 30

Which of the following is a valid cell address?

1B2

AA#

14 / 30

What is the default number of worksheets in a new workbook?

15 / 30

Excel में किसी दुसरे Sheet पर जाने के लिए, कोन सा Shortcut Key उपयोग करेंगे ?

Shift + Page Down Key

Ctrl+Shift+Donw Key

Ctrl + Page Down Key

Alt + Page Down Key

16 / 30

Excel में किसी Active Cell पर Auto Format Number कैसे सेट करे ?

CELL STYLES GROUP-CONDITIONAL FORMATTING OPTION

NONE OF THE ABOVE

FONT GROUP- FILL COLOR OPTION

CELL GROUP- SERIES OPTION

17 / 30

Which menu is used to sort data?

View

Data

Insert

Home

18 / 30

Which Excel feature helps to repeat the same value or formula across cells?

Copy

Drag and Fill

Insert

Paste

19 / 30

Which function returns the current date?

TODAY()

NOW()

CURRENT()

DATE()

20 / 30

Excel में Conditional Formatting किस Groups में पाया जाता हैं ?

All of The Above

Insert Tab-Cell Styles Group

Home Tab – Styles Group

Review Tab – Cell Formatting Group

21 / 30

Excel में Wrap Text का Shortcut Key क्या हैं ?

CTRL+SHIFT+ENTER KEY

CTRL+ENTER KEY

ALT+ENTER KEY

CTRL+ALT+ENTER KEY

22 / 30

Excel में Superscript ओर Subscript किस Group में पाया जाता हैं ?

All of The Above

Home Tab-Clipboard Group

Insert Tab-Text Group

Home Tab-Font Group

23 / 30

What does the function =AVERAGE(10, 20, 30) return?

24 / 30

Excel में XFD की संख्या क्या हैं ?

16375

18996

17358

16384

25 / 30

What does the Fill Handle do?

Moves cells

Fills formatting only

Copies formulas

Deletes data

26 / 30

How do you start a new line within a cell?

Alt + Enter

Press Enter

Ctrl + Enter

Shift + Enter

27 / 30

What symbol is used to begin a formula in Excel?

28 / 30

What is the file extension for an Excel workbook in Excel 2016 and later?

.doc

.csv

.xls

.xlsx

29 / 30

What does the ‘AutoSum’ button do?

Averages values

Subtracts values

Finds maximum

Adds values

30 / 30

What is a range in Excel?

A column

A formula

A group of cells

A single cell

Your score is

Pos.	Name	Score	Duration	Points
1	Vishwajeet Ghosh	100 %	48 seconds	30 / 30
2	Manish maurya	100 %	58 seconds	30 / 30
3	Manas	100 %	59 seconds	30 / 30
4	Sonalika singh	100 %	1 minutes 1 seconds	30 / 30
5	Jagriti	100 %	1 minutes 2 seconds	30 / 30
6	Sonalika singh	100 %	1 minutes 2 seconds	30 / 30
7	Shikha singh	100 %	1 minutes 3 seconds	30 / 30
8	Manish maurya	100 %	1 minutes 4 seconds	30 / 30
9	Sonalika singh	100 %	1 minutes 6 seconds	30 / 30
10	Khushi gupta	100 %	1 minutes 8 seconds	30 / 30
11	Krishna rawat	100 %	1 minutes 9 seconds	30 / 30
12	sumityadav	100 %	1 minutes 14 seconds	30 / 30
13	Aachal maurya	100 %	1 minutes 14 seconds	30 / 30
14	Sewani Thakur	100 %	1 minutes 15 seconds	30 / 30
15	Sonalika singh	100 %	1 minutes 16 seconds	30 / 30
16	KHUSHI SHARMA	100 %	1 minutes 17 seconds	30 / 30
17	Ayush Kumar Singh	100 %	1 minutes 18 seconds	30 / 30
18	Priya Pandey	100 %	1 minutes 18 seconds	30 / 30
19	Smita	100 %	1 minutes 22 seconds	30 / 30
20	Anchal	100 %	1 minutes 24 seconds	30 / 30
21	Abc	100 %	1 minutes 25 seconds	30 / 30
22	Khushi Sharma.	100 %	1 minutes 26 seconds	30 / 30
23	Palak modanwal	100 %	1 minutes 31 seconds	30 / 30
24	Jyoti	100 %	1 minutes 32 seconds	30 / 30
25	Palak modanwal	100 %	1 minutes 33 seconds	30 / 30
26	Khusbu Thakur	100 %	1 minutes 37 seconds	30 / 30
27	Shobha	100 %	1 minutes 38 seconds	30 / 30
28	HITESH PATWA	100 %	1 minutes 41 seconds	30 / 30
29	Shubhangi mishra	100 %	1 minutes 42 seconds	30 / 30
30	hitesh shah	100 %	1 minutes 43 seconds	30 / 30
31	Palak modanwal	100 %	1 minutes 44 seconds	30 / 30
32	Karishma Kumari	100 %	1 minutes 45 seconds	30 / 30
33	Shobha	100 %	1 minutes 47 seconds	30 / 30
34	Sonam Rajbhar	100 %	1 minutes 51 seconds	30 / 30
35	Afreen Bano	100 %	1 minutes 54 seconds	30 / 30
36	Diksha Singh	100 %	1 minutes 56 seconds	30 / 30
37	Aniket Kumar Singh	100 %	1 minutes 56 seconds	30 / 30
38	Anshika	100 %	1 minutes 57 seconds	30 / 30
39	Ankit sonkar	100 %	1 minutes 57 seconds	30 / 30
40	Anchal chaurasiya	100 %	2 minutes 4 seconds	30 / 30
41	Praveen Agrawal	100 %	2 minutes 6 seconds	30 / 30
42	MANAS	100 %	2 minutes 8 seconds	30 / 30
43	Bhavya	100 %	2 minutes 8 seconds	30 / 30
44	Mahendra Maurya	100 %	2 minutes 12 seconds	30 / 30
45	Himanshu Tiwari	100 %	2 minutes 13 seconds	30 / 30
46	Yuvraj Tiwari	100 %	2 minutes 14 seconds	30 / 30
47	Krishna Upadhyay	100 %	2 minutes 17 seconds	30 / 30
48	Deepika Singh	100 %	2 minutes 18 seconds	30 / 30
49	Anurag kumar bind	100 %	2 minutes 19 seconds	30 / 30
50	Sonalika singh	100 %	2 minutes 20 seconds	30 / 30
51	Ankita dubey	100 %	2 minutes 21 seconds	30 / 30
52	Priyanka	100 %	2 minutes 23 seconds	30 / 30
53	Sonalika singh	100 %	2 minutes 26 seconds	30 / 30
54	vanshika	100 %	2 minutes 28 seconds	30 / 30
55	Shreya singh	100 %	2 minutes 28 seconds	30 / 30
56	Shivangi	100 %	2 minutes 30 seconds	30 / 30
57	Preeti	100 %	2 minutes 33 seconds	30 / 30
58	Sonali Seth	100 %	2 minutes 35 seconds	30 / 30
59	Priyanka	100 %	2 minutes 36 seconds	30 / 30
60	Shreya upadhayay	100 %	2 minutes 37 seconds	30 / 30
61	Sonalika singh	100 %	2 minutes 37 seconds	30 / 30
62	Shri Dayal Gupta	100 %	2 minutes 50 seconds	30 / 30
63	Ayushi Mishra	100 %	2 minutes 51 seconds	30 / 30
64	Prateek kumar singh	100 %	2 minutes 55 seconds	30 / 30
65	Sonalika Singh	100 %	2 minutes 55 seconds	30 / 30
66	Shubham sharma	100 %	2 minutes 57 seconds	30 / 30
67	Kushagra rai	100 %	2 minutes 58 seconds	30 / 30
68	Priyanka	100 %	3 minutes 1 seconds	30 / 30
69	Ayush Vishwakarma	100 %	3 minutes 3 seconds	30 / 30
70	Priya Pandey	100 %	3 minutes 4 seconds	30 / 30
71	Astha Singh	100 %	3 minutes 13 seconds	30 / 30
72	abc	100 %	3 minutes 26 seconds	30 / 30
73	HIMANSHU YADAV	100 %	3 minutes 26 seconds	30 / 30
74	Prince Raj	100 %	3 minutes 45 seconds	30 / 30
75	kashish kannaujiya	100 %	3 minutes 47 seconds	30 / 30
76	Yash raj	100 %	3 minutes 49 seconds	30 / 30
77	Divyam	100 %	3 minutes 59 seconds	30 / 30
78	Sanju	100 %	4 minutes 45 seconds	30 / 30
79	Isha Singh	100 %	4 minutes 55 seconds	30 / 30
80	Manish maurya	97 %	1 minutes 1 seconds	29 / 30
81	Yuvraj Tiwari	97 %	1 minutes 4 seconds	29 / 30
82	Sonalika	97 %	1 minutes 6 seconds	29 / 30
83	Rahul	97 %	1 minutes 12 seconds	29 / 30
84	Manish maurya	97 %	1 minutes 16 seconds	29 / 30
85	Roshani Prajapati	97 %	1 minutes 19 seconds	29 / 30
86	Yuvraj Tiwari	97 %	1 minutes 19 seconds	29 / 30
87	Zara	97 %	1 minutes 20 seconds	29 / 30
88	Khushigupta	97 %	1 minutes 24 seconds	29 / 30
89	Ayush Kumar Singh	97 %	1 minutes 28 seconds	29 / 30
90	Smita	97 %	1 minutes 30 seconds	29 / 30
91	Aachal maurya	97 %	1 minutes 30 seconds	29 / 30
92	sumityadav	97 %	1 minutes 35 seconds	29 / 30
93	Smita	97 %	1 minutes 39 seconds	29 / 30
94	Muskan gupta	97 %	1 minutes 42 seconds	29 / 30
95	Aniket Kumar Singh	97 %	1 minutes 46 seconds	29 / 30
96	Jyoti	97 %	1 minutes 48 seconds	29 / 30
97	Shubham sharma	97 %	1 minutes 49 seconds	29 / 30
98	Abc	97 %	1 minutes 52 seconds	29 / 30
99	Aniket Singh	97 %	1 minutes 53 seconds	29 / 30
100	Harsh kumar singh	97 %	1 minutes 55 seconds	29 / 30

Related Posts