Excel Intermediate Online Test Series 5239

132

Excel Intermediate level Online Test Series 5239

Excel Intermediate Online Test Series 5239

1 / 40

What is the default row height in Excel?

13.5

2 / 40

Which command is used to merge cells?

Alignment

Format Painter

Wrap Text

Merge & Center

3 / 40

Which formula returns the remainder of a division?

REM()

INT()

MOD()

ROUND()

4 / 40

What does the “Remove Duplicates” tool do

Removes formulas

Removes repeated rows

Deletes entire columns

Hides rows

5 / 40

How can you freeze the top row in Excel?

View → Freeze Panes → Freeze Top Row

Insert → Freeze

Data → Freeze Top Row

Home → Freeze

6 / 40

Which feature helps in creating repetitive data entries quickly?

Sort

Format Painter

Filter

Fill Handle

7 / 40

Which chart type shows trends over time?

Line

Bar

Area

Pie

8 / 40

Which tab allows you to insert a PivotTable?

View

Home

Insert

Review

9 / 40

How do you apply filters in Excel?

Insert → Filter

View → Filter

Data → Filter

Ctrl + F

10 / 40

What function is used to get today’s date?

NOW()

TIME()

DATE()

TODAY()

11 / 40

What does VLOOKUP do?

Summarizes data

Finds value in a table vertically

Filters data

Sorts data

12 / 40

What type of cell reference is A$1?

Relative

Constant

Mixed

Absolute

13 / 40

Which error shows when a number is too large?

#REF

#VALUE!

######

#NUM!

14 / 40

Which function is used to join text strings in Excel?

JOIN()

COMBINE()

CONCATENATE()

LINK()

15 / 40

Which function gives the number of characters in a text?

COUNT()

TEXT()

LEN()

FIND()

16 / 40

What is the use of “Text to Columns”?

Format text

Sort text

Merge text cells

Split a column into multiple columns

17 / 40

What does Conditional Formatting do?

Applies formatting based on condition

Sorts data

Formats text in uppercase

Splits text

18 / 40

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

65536

16384

32768

1048576

19 / 40

Which feature summarizes data with total and count?

PivotTable

Data Table

Formulas

Table Format

20 / 40

What will =ROUND(23.567,1) return?

23.6

23.5

21 / 40

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

.docx

.xlsx

.csv

.xls

22 / 40

Which of the following is a logical function?

COUNT

LEN

SUM

23 / 40

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

FALSE

TRUE

The third argument

24 / 40

What does Ctrl + ; (semicolon) insert?

Time

Date

Symbol

Formula

25 / 40

Which tab contains the Conditional Formatting option?

Review

File

Home

Insert

26 / 40

Which formula will add A1 through A5?

=A1+A5

=ADD(A1:A5)

=SUM(A1:A5)

=TOTAL(A1:A5)

27 / 40

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

Values

Column

Row

Filter

28 / 40

What does Data Validation do?

Formats the cell

Allows specific data entry

Filters duplicates

Sorts data

29 / 40

Which tab is used to insert charts?

Data

Review

Page Layout

Insert

30 / 40

What is the shortcut key for creating a new workbook?

Ctrl + Shift + N

Ctrl + O

Ctrl + W

Ctrl + N

31 / 40

Which function removes extra spaces in a string?

CLEAN()

REMOVE()

TRIM()

TEXT()

32 / 40

How do you protect a worksheet?

Review → Protect Sheet

File → Protect

Home → Protect

Data → Lock

33 / 40

Which shortcut is used to open Format Cells dialog?

Ctrl + 1

Ctrl + C

Ctrl + Shift + F

Alt + F4

34 / 40

What does a green triangle in a cell corner indicate

Formula error

Number format

Comment

Hidden text

35 / 40

Which function counts only numeric values?

COUNTIF()

COUNT()

COUNTA()

COUNTBLANK()

36 / 40

Which format shows numbers as currency?

Date

General

Accounting

Text

37 / 40

Which function checks whether a condition is true or false?

MATCH

FIND

38 / 40

What is a cell in Excel?

Intersection of a row and column

A graph

A chart

A formula

39 / 40

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

FALSE

The third argument

TRUE

40 / 40

Which chart is best for showing proportions

Column chart

Scatter plot

Line chart

Pie chart

Your score is

Pos.	Name	Score	Duration	Points
1	Khushi gupta	100 %	1 minutes 4 seconds	40 / 40
2	Sonalika singh	100 %	1 minutes 9 seconds	40 / 40
3	Khushi gupta	100 %	1 minutes 12 seconds	40 / 40
4	Sonalika singh	100 %	1 minutes 15 seconds	40 / 40
5	Nancy gupta	100 %	1 minutes 17 seconds	40 / 40
6	Sonalika singh	100 %	1 minutes 18 seconds	40 / 40
7	Sonalika singh	100 %	1 minutes 21 seconds	40 / 40
8	Karishma Kumari	100 %	1 minutes 26 seconds	40 / 40
9	Sonalika singh	100 %	1 minutes 28 seconds	40 / 40
10	Khushi Baranwal	100 %	1 minutes 28 seconds	40 / 40
11	Nancy gupta	100 %	1 minutes 28 seconds	40 / 40
12	Sonalika singh	100 %	1 minutes 29 seconds	40 / 40
13	Nancy gupta	100 %	1 minutes 34 seconds	40 / 40
14	Sonalika singh	100 %	1 minutes 37 seconds	40 / 40
15	Sonalika singh	100 %	1 minutes 39 seconds	40 / 40
16	Shubham Yadav	100 %	1 minutes 39 seconds	40 / 40
17	Khushi gupta	100 %	1 minutes 47 seconds	40 / 40
18	Anjali Pandey	100 %	1 minutes 49 seconds	40 / 40
19	Muskan Sharma	100 %	1 minutes 50 seconds	40 / 40
20	Sonalika singh	100 %	1 minutes 57 seconds	40 / 40
21	Priyanka	100 %	1 minutes 58 seconds	40 / 40
22	Khushi gupta	100 %	1 minutes 58 seconds	40 / 40
23	Jyoti	100 %	2 minutes 8 seconds	40 / 40
24	Sonalika singh	100 %	2 minutes 12 seconds	40 / 40
25	Rimjhim Jaiswal	100 %	2 minutes 19 seconds	40 / 40
26	Priyanka	100 %	2 minutes 27 seconds	40 / 40
27	Mohanish	100 %	3 minutes	40 / 40
28	Muskan Sharma	100 %	3 minutes 4 seconds	40 / 40
29	Priya Pandey	100 %	3 minutes 4 seconds	40 / 40
30	Sonalika singh	100 %	3 minutes 27 seconds	40 / 40
31	Astha Singh	100 %	3 minutes 47 seconds	40 / 40
32	Sonali Seth	100 %	4 minutes 21 seconds	40 / 40
33	Khushi Baranwal	98 %	1 minutes 21 seconds	39 / 40
34	Sonalika singh	98 %	1 minutes 24 seconds	39 / 40
35	Khushi Baranwal	98 %	1 minutes 38 seconds	39 / 40
36	Karishma Kumari	98 %	1 minutes 42 seconds	39 / 40
37	Nancy gupta	98 %	1 minutes 58 seconds	39 / 40
38	Rimjhim Jaiswal	98 %	2 minutes 15 seconds	39 / 40
39	Harsh	98 %	2 minutes 19 seconds	39 / 40
40	Anjali Pandey	98 %	2 minutes 19 seconds	39 / 40
41	Priya Pandey	98 %	2 minutes 32 seconds	39 / 40
42	Rimjhim	98 %	2 minutes 40 seconds	39 / 40
43	Harsh	98 %	2 minutes 54 seconds	39 / 40
44	Harsh	98 %	3 minutes 20 seconds	39 / 40
45	Ritesh	98 %	4 minutes 56 seconds	39 / 40
46	Raushan	98 %	5 minutes 4 seconds	39 / 40
47	Nancy gupta	95 %	1 minutes 35 seconds	38 / 40
48	Shivangi	95 %	2 minutes 23 seconds	38 / 40
49	Astha Singh	95 %	2 minutes 37 seconds	38 / 40
50	Nancy gupta	95 %	2 minutes 39 seconds	38 / 40
51	Astha Singh	95 %	3 minutes 20 seconds	38 / 40
52	Sristy kumari	95 %	3 minutes 24 seconds	38 / 40
53	Sristy kumari	95 %	3 minutes 28 seconds	38 / 40
54	Pooja maurya	95 %	3 minutes 35 seconds	38 / 40
55	Astha Singh	95 %	3 minutes 39 seconds	38 / 40
56	Harsh kumar singh	95 %	4 minutes 43 seconds	38 / 40
57	Rishabh	95 %	5 minutes 29 seconds	38 / 40
58	Nancy gupta	93 %	1 minutes 23 seconds	37 / 40
59	Khushi Baranwal	93 %	1 minutes 50 seconds	37 / 40
60	Khushi Baranwal	93 %	1 minutes 53 seconds	37 / 40
61	Astha Singh	93 %	2 minutes 3 seconds	37 / 40
62	Astha Singh	93 %	2 minutes 13 seconds	37 / 40
63	Shobha	93 %	4 minutes 12 seconds	37 / 40
64	Rishabh	93 %	6 minutes 59 seconds	37 / 40
65	Khushi Baranwal	90 %	1 minutes 34 seconds	36 / 40
66	Sonam	90 %	1 minutes 37 seconds	36 / 40
67	Khushi Baranwal	90 %	1 minutes 43 seconds	36 / 40
68	Astha Singh	90 %	2 minutes 18 seconds	36 / 40
69	Shivangi	90 %	2 minutes 51 seconds	36 / 40
70	Rimjhim	90 %	2 minutes 54 seconds	36 / 40
71	Sanjana sharma	90 %	2 minutes 55 seconds	36 / 40
72	Khushi Baranwal	88 %	1 minutes 27 seconds	35 / 40
73	Nancy gupta	88 %	1 minutes 50 seconds	35 / 40
74	Priya	88 %	3 minutes 14 seconds	35 / 40
75	Astha Singh	88 %	3 minutes 26 seconds	35 / 40
76	Sonalika singh	88 %	4 minutes 39 seconds	35 / 40
77	Mohanish	88 %	5 minutes 54 seconds	35 / 40
78	Vikash	88 %	5 minutes 55 seconds	35 / 40
79	Sanjana sharma	88 %	6 minutes 1 seconds	35 / 40
80	Astha Singh	85 %	2 minutes 3 seconds	34 / 40
81	Shobha	85 %	3 minutes 18 seconds	34 / 40
82	Sonalika Singh	85 %	3 minutes 58 seconds	34 / 40
83	Pooja maurya	85 %	4 minutes	34 / 40
84	Astha Singh	85 %	4 minutes 47 seconds	34 / 40
85	Smita	83 %	2 minutes 42 seconds	33 / 40
86	Rimjhim	83 %	4 minutes 24 seconds	33 / 40
87	Priya	83 %	6 minutes 16 seconds	33 / 40
88	Khushi baranwal	80 %	2 minutes 24 seconds	32 / 40
89	Smita	80 %	4 minutes 11 seconds	32 / 40
90	Sonalika singh	80 %	4 minutes 14 seconds	32 / 40
91	Harsh kumar singh	78 %	2 minutes 54 seconds	31 / 40
92	Sristy dubey	78 %	3 minutes 32 seconds	31 / 40
93	Priyanka	78 %	6 minutes 17 seconds	31 / 40
94	Rimjhim	75 %	3 minutes 3 seconds	30 / 40
95	Nancy gupta	75 %	4 minutes 15 seconds	30 / 40
96	Rimjhim	75 %	4 minutes 34 seconds	30 / 40
97	Astha Singh	73 %	6 minutes 18 seconds	29 / 40
98	Shivangi	70 %	3 minutes 51 seconds	28 / 40
99	Anjali Pandey	68 %	3 minutes 26 seconds	27 / 40
100	Ritesh tripathi	68 %	4 minutes 56 seconds	27 / 40

Related Posts