Excel Intermediate Online Test Series 5239

284

Excel Intermediate Level Online Test Series 5239

Excel Intermediate Online Test Series 5239

1 / 40

Which of the following is a logical function?

LEN

COUNT

SUM

2 / 40

What does Conditional Formatting do?

Sorts data

Applies formatting based on condition

Splits text

Formats text in uppercase

3 / 40

Which formula returns the remainder of a division?

ROUND()

REM()

MOD()

INT()

4 / 40

What does VLOOKUP do?

Finds value in a table vertically

Filters data

Sorts data

Summarizes data

5 / 40

Which chart type shows trends over time?

Area

Pie

Line

Bar

6 / 40

What is the use of “Text to Columns”?

Sort text

Split a column into multiple columns

Merge text cells

Format text

7 / 40

Which tab is used to insert charts?

Insert

Page Layout

Data

Review

8 / 40

What is a cell in Excel?

A graph

A chart

Intersection of a row and column

A formula

9 / 40

Which shortcut is used to open Format Cells dialog?

Ctrl + Shift + F

Ctrl + C

Alt + F4

Ctrl + 1

10 / 40

What does Data Validation do?

Sorts data

Filters duplicates

Allows specific data entry

Formats the cell

11 / 40

What function is used to get today’s date?

DATE()

TIME()

NOW()

TODAY()

12 / 40

Which formula will add A1 through A5?

=TOTAL(A1:A5)

=ADD(A1:A5)

=SUM(A1:A5)

=A1+A5

13 / 40

What type of cell reference is A$1?

Absolute

Relative

Mixed

Constant

14 / 40

Which feature helps in creating repetitive data entries quickly?

Filter

Fill Handle

Format Painter

Sort

15 / 40

Which function is used to join text strings in Excel?

JOIN()

CONCATENATE()

LINK()

COMBINE()

16 / 40

What is the shortcut key for creating a new workbook?

Ctrl + O

Ctrl + N

Ctrl + W

Ctrl + Shift + N

17 / 40

Which error shows when a number is too large?

######

#VALUE!

#REF

#NUM!

18 / 40

Which command is used to merge cells?

Merge & Center

Alignment

Format Painter

Wrap Text

19 / 40

What does the IF function return if the condition is false?

FALSE

The third argument

TRUE

20 / 40

Which chart is best for showing proportions

Line chart

Pie chart

Scatter plot

Column chart

21 / 40

How do you protect a worksheet?

File → Protect

Home → Protect

Review → Protect Sheet

Data → Lock

22 / 40

Which format shows numbers as currency?

General

Text

Accounting

Date

23 / 40

Which feature summarizes data with total and count?

PivotTable

Formulas

Data Table

Table Format

24 / 40

Which function counts only numeric values?

COUNTBLANK()

COUNTA()

COUNTIF()

COUNT()

25 / 40

What is the maximum number of rows in Excel 2016-21?

65536

16384

1048576

32768

26 / 40

What does the IF function return if the condition is false?

FALSE

The third argument

TRUE

27 / 40

What is the default row height in Excel?

13.5

28 / 40

Which function checks whether a condition is true or false?

FIND

MATCH

29 / 40

Which field in a PivotTable is used for values to be summarized?

Row

Column

Filter

Values

30 / 40

Which function removes extra spaces in a string?

TRIM()

CLEAN()

REMOVE()

TEXT()

31 / 40

Which tab allows you to insert a PivotTable?

Insert

Home

Review

View

32 / 40

Which function gives the number of characters in a text?

LEN()

FIND()

TEXT()

COUNT()

33 / 40

What does a green triangle in a cell corner indicate

Comment

Hidden text

Formula error

Number format

34 / 40

What will =ROUND(23.567,1) return?

23.6

23.5

35 / 40

How can you freeze the top row in Excel?

Data → Freeze Top Row

View → Freeze Panes → Freeze Top Row

Insert → Freeze

Home → Freeze

36 / 40

What is the file extension of Excel 2016-21 file?

.docx

.xls

.csv

.xlsx

37 / 40

What does Ctrl + ; (semicolon) insert?

Time

Symbol

Date

Formula

38 / 40

How do you apply filters in Excel?

View → Filter

Ctrl + F

Insert → Filter

Data → Filter

39 / 40

Which tab contains the Conditional Formatting option?

Review

File

Home

Insert

40 / 40

What does the “Remove Duplicates” tool do

Deletes entire columns

Removes formulas

Hides rows

Removes repeated rows

Your score is

Pos.	Name	Score	Duration	Points
1	Manish maurya	100 %	1 minutes	40 / 40
2	Khushi gupta	100 %	1 minutes 4 seconds	40 / 40
3	Manish maurya	100 %	1 minutes 6 seconds	40 / 40
4	Shaan	100 %	1 minutes 6 seconds	40 / 40
5	Sonalika singh	100 %	1 minutes 9 seconds	40 / 40
6	Khushi gupta	100 %	1 minutes 12 seconds	40 / 40
7	Krishna Rawat	100 %	1 minutes 14 seconds	40 / 40
8	Sonalika singh	100 %	1 minutes 15 seconds	40 / 40
9	Anchal	100 %	1 minutes 17 seconds	40 / 40
10	Nancy gupta	100 %	1 minutes 17 seconds	40 / 40
11	Sonalika singh	100 %	1 minutes 18 seconds	40 / 40
12	Manish maurya	100 %	1 minutes 20 seconds	40 / 40
13	Sonalika singh	100 %	1 minutes 21 seconds	40 / 40
14	Sumit yadav	100 %	1 minutes 23 seconds	40 / 40
15	Shikha singh	100 %	1 minutes 25 seconds	40 / 40
16	Karishma Kumari	100 %	1 minutes 26 seconds	40 / 40
17	Sonalika singh	100 %	1 minutes 28 seconds	40 / 40
18	Khushi Baranwal	100 %	1 minutes 28 seconds	40 / 40
19	Nancy gupta	100 %	1 minutes 28 seconds	40 / 40
20	Sonalika singh	100 %	1 minutes 29 seconds	40 / 40
21	Khushi Sharma	100 %	1 minutes 31 seconds	40 / 40
22	KHUSHI SHARMA	100 %	1 minutes 33 seconds	40 / 40
23	Nancy gupta	100 %	1 minutes 34 seconds	40 / 40
24	sumityadav	100 %	1 minutes 36 seconds	40 / 40
25	Sonalika singh	100 %	1 minutes 37 seconds	40 / 40
26	sumityadav	100 %	1 minutes 38 seconds	40 / 40
27	sumityadav	100 %	1 minutes 38 seconds	40 / 40
28	Sonalika singh	100 %	1 minutes 39 seconds	40 / 40
29	Shubham Yadav	100 %	1 minutes 39 seconds	40 / 40
30	Khushi gupta	100 %	1 minutes 47 seconds	40 / 40
31	Anchal	100 %	1 minutes 49 seconds	40 / 40
32	Anjali Pandey	100 %	1 minutes 49 seconds	40 / 40
33	Muskan Sharma	100 %	1 minutes 50 seconds	40 / 40
34	Khushi Sharma	100 %	1 minutes 55 seconds	40 / 40
35	Praveen	100 %	1 minutes 56 seconds	40 / 40
36	Sonalika singh	100 %	1 minutes 57 seconds	40 / 40
37	Priyanka	100 %	1 minutes 58 seconds	40 / 40
38	Khushi gupta	100 %	1 minutes 58 seconds	40 / 40
39	Bhavya	100 %	2 minutes 7 seconds	40 / 40
40	Jyoti	100 %	2 minutes 8 seconds	40 / 40
41	Prateek kumar singh	100 %	2 minutes 11 seconds	40 / 40
42	Kushagra rai	100 %	2 minutes 11 seconds	40 / 40
43	Sonalika singh	100 %	2 minutes 12 seconds	40 / 40
44	Preeti	100 %	2 minutes 15 seconds	40 / 40
45	Bhavya shukla	100 %	2 minutes 18 seconds	40 / 40
46	Rimjhim Jaiswal	100 %	2 minutes 19 seconds	40 / 40
47	Bhavya shukla	100 %	2 minutes 22 seconds	40 / 40
48	Priyanka	100 %	2 minutes 27 seconds	40 / 40
49	Preeti	100 %	2 minutes 36 seconds	40 / 40
50	Mohanish	100 %	3 minutes	40 / 40
51	Bhavya shukla	100 %	3 minutes 3 seconds	40 / 40
52	Muskan Sharma	100 %	3 minutes 4 seconds	40 / 40
53	Priya Pandey	100 %	3 minutes 4 seconds	40 / 40
54	shivani singh	100 %	3 minutes 14 seconds	40 / 40
55	Bhavya shukla	100 %	3 minutes 23 seconds	40 / 40
56	Sonalika singh	100 %	3 minutes 27 seconds	40 / 40
57	Pooja Verma	100 %	3 minutes 41 seconds	40 / 40
58	Astha Singh	100 %	3 minutes 47 seconds	40 / 40
59	vanshika	100 %	3 minutes 48 seconds	40 / 40
60	Sonali Seth	100 %	4 minutes 21 seconds	40 / 40
61	Johnson	100 %	6 minutes 27 seconds	40 / 40
62	Manish maurya	98 %	1 minutes 3 seconds	39 / 40
63	Manish maurya	98 %	1 minutes 3 seconds	39 / 40
64	Krishna rawat	98 %	1 minutes 19 seconds	39 / 40
65	Krishna rawat	98 %	1 minutes 20 seconds	39 / 40
66	Khushi Baranwal	98 %	1 minutes 21 seconds	39 / 40
67	Sonalika singh	98 %	1 minutes 24 seconds	39 / 40
68	Krishna Rawat	98 %	1 minutes 25 seconds	39 / 40
69	Shikha singh	98 %	1 minutes 34 seconds	39 / 40
70	Mohit	98 %	1 minutes 36 seconds	39 / 40
71	Khushi Baranwal	98 %	1 minutes 38 seconds	39 / 40
72	Shikha singh	98 %	1 minutes 38 seconds	39 / 40
73	Shikha singh	98 %	1 minutes 39 seconds	39 / 40
74	Karishma Kumari	98 %	1 minutes 42 seconds	39 / 40
75	sumityadav	98 %	1 minutes 44 seconds	39 / 40
76	Aachal maurya	98 %	1 minutes 46 seconds	39 / 40
77	sumityadav	98 %	1 minutes 47 seconds	39 / 40
78	Palak modanwal	98 %	1 minutes 49 seconds	39 / 40
79	Nancy gupta	98 %	1 minutes 58 seconds	39 / 40
80	Bhavya shukla	98 %	2 minutes 5 seconds	39 / 40
81	Krishna rawat	98 %	2 minutes 8 seconds	39 / 40
82	Rimjhim Jaiswal	98 %	2 minutes 15 seconds	39 / 40
83	Harsh	98 %	2 minutes 19 seconds	39 / 40
84	Anjali Pandey	98 %	2 minutes 19 seconds	39 / 40
85	Preeti	98 %	2 minutes 28 seconds	39 / 40
86	Yuvraj Tiwari	98 %	2 minutes 28 seconds	39 / 40
87	Priya Pandey	98 %	2 minutes 32 seconds	39 / 40
88	Rimjhim	98 %	2 minutes 40 seconds	39 / 40
89	KHUSHI SHARMA	98 %	2 minutes 44 seconds	39 / 40
90	Shreya	98 %	2 minutes 52 seconds	39 / 40
91	Harsh	98 %	2 minutes 54 seconds	39 / 40
92	Harsh	98 %	3 minutes 20 seconds	39 / 40
93	Pooja Verma	98 %	3 minutes 28 seconds	39 / 40
94	Jaya	98 %	3 minutes 40 seconds	39 / 40
95	Khushi Sharma	98 %	3 minutes 52 seconds	39 / 40
96	ROSHANI KESHARII	98 %	3 minutes 54 seconds	39 / 40
97	Prateek shrivastav	98 %	4 minutes 18 seconds	39 / 40
98	Aniket Kumar Singh	98 %	4 minutes 35 seconds	39 / 40
99	Ritesh	98 %	4 minutes 56 seconds	39 / 40
100	Anshika Yadav	98 %	4 minutes 59 seconds	39 / 40

Related Posts