Excel Basic Online Test Series 5234

590

Excel Basic Online Test Series 5234

1 / 30

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

.doc

.csv

.xlsx

.xls

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

3 / 30

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

CELL GROUP- SERIES OPTION

NONE OF THE ABOVE

CELL STYLES GROUP-CONDITIONAL FORMATTING OPTION

FONT GROUP- FILL COLOR OPTION

4 / 30

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

Review Tab – Cell Formatting Group

Insert Tab-Cell Styles Group

Home Tab – Styles Group

All of The Above

5 / 30

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

TOTAL()

COUNTIF()

SUM()

MAX()

6 / 30

Which function counts only numeric values in a range?

COUNTIF()

COUNTALL()

COUNTA()

COUNT()

7 / 30

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

8 / 30

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

17358

18996

16384

16375

9 / 30

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

10 / 30

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

Cells-17179869180

Cells-17179869184

Cells-17189969184

Cells-17179969184

11 / 30

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

Row-1048576 Or Column-16384

Row-1248576 Or Column-13384

Row-2048576 Or Column-15384

Row-2048576 Or Column-17384

12 / 30

Which function returns the current date?

NOW()

TODAY()

CURRENT()

DATE()

13 / 30

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

Copy

Drag and Fill

Paste

Insert

14 / 30

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

Ctrl+Shift+Donw Key

Ctrl + Page Down Key

Alt + Page Down Key

Shift + Page Down Key

15 / 30

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

All of The Above

Home Tab-Font Group

Home Tab-Clipboard Group

Insert Tab-Text Group

16 / 30

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

17 / 30

How do you start a new line within a cell?

Shift + Enter

Press Enter

Alt + Enter

Ctrl + Enter

18 / 30

What does the Fill Handle do?

Copies formulas

Moves cells

Deletes data

Fills formatting only

19 / 30

What symbol is used to begin a formula in Excel?

20 / 30

What chart type is best for showing trends over time?

Bar chart

Line chart

Column chart

Pie chart

21 / 30

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

ALT+ENTER KEY

CTRL+SHIFT+ENTER KEY

CTRL+ALT+ENTER KEY

CTRL+ENTER KEY

22 / 30

How are columns labeled in Excel?

By date

Numerically

Alphabetically

Randomly

23 / 30

What is a range in Excel?

A column

A group of cells

A formula

A single cell

24 / 30

Which tab contains the ‘Insert’ chart option?

View Tab

Data Tab

Insert Tab

Home Tab

25 / 30

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

Copy the Formatting

Object The Formatting

All of The Above

Text The Formatting

26 / 30

Which of the following is a valid cell address?

1B2

AA#

27 / 30

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

Address

Data

Box

Cell

28 / 30

Which menu is used to sort data?

Data

View

Insert

Home

29 / 30

What does the ‘AutoSum’ button do?

Adds values

Subtracts values

Averages values

Finds maximum

30 / 30

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

Ctrl + X

Ctrl + C

Ctrl + S

Ctrl + V

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

MS Word VedantSri me seekhna chahte hain?

VedantSri Computer Institute, Varanasi — Durgakund aur Rathyatra, dono branch. Roz subah 7 se raat 8 baje tak khula.

WhatsApp · Durgakund WhatsApp · Rathyatra

Call 8808888478 Call 9415802061

Saare course, fees aur syllabus: VedantSri Varanasi

VedantSri par MS Word ka naya content

A To Z Word Shortcut Online Test Series 2026 – Master Every MS Word Shortcut Key
A To Z Word Shortcut Online Test Series 2026 – Master Every MS Word Shortcut Key You are...
MS Word Home Menu Online Test
MS Word Home Menu Online Test Microsoft Word is an essential tool for anyone who works with documents....
50 Top MS Word Online Test, Quiz, Mock Exam 2026
50 Top MS Word Online Test, Quiz, Mock Exam 2026 Useful Link: -MS Word Course Details, Fees, Duration,...

Related Posts