Excel Intermediate level Online Test Series 5239

Excel Intermediate Online Test Series 5239

0%
181
Excel Intermediate level Online Test Series 5239

Excel Intermediate Online Test Series 5239

Excel Intermediate Online Test Series 5239

1 / 40

Which formula returns the remainder of a division?

2 / 40

Which formula will add A1 through A5?

3 / 40

How do you apply filters in Excel?

4 / 40

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

5 / 40

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

6 / 40

What will =ROUND(23.567,1) return?

7 / 40

Which function is used to join text strings in Excel?

8 / 40

Which function gives the number of characters in a text?

9 / 40

Which function counts only numeric values?

10 / 40

How do you protect a worksheet?

11 / 40

What type of cell reference is A$1?

12 / 40

Which shortcut is used to open Format Cells dialog?

13 / 40

What does Ctrl + ; (semicolon) insert?

14 / 40

Which of the following is a logical function?

15 / 40

Which function checks whether a condition is true or false?

16 / 40

Which tab allows you to insert a PivotTable?

17 / 40

Which format shows numbers as currency?

18 / 40

Which chart type shows trends over time?

19 / 40

What does Data Validation do?

20 / 40

What does VLOOKUP do?

21 / 40

What does the “Remove Duplicates” tool do

22 / 40

What function is used to get today’s date?

23 / 40

Which feature summarizes data with total and count?

24 / 40

What does a green triangle in a cell corner indicate

25 / 40

What is the use of “Text to Columns”?

26 / 40

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

27 / 40

Which chart is best for showing proportions

28 / 40

How can you freeze the top row in Excel?

29 / 40

Which error shows when a number is too large?

30 / 40

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

31 / 40

Which tab is used to insert charts?

32 / 40

What is a cell in Excel?

33 / 40

What is the shortcut key for creating a new workbook?

34 / 40

Which feature helps in creating repetitive data entries quickly?

35 / 40

Which function removes extra spaces in a string?

36 / 40

What is the default row height in Excel?

37 / 40

What does Conditional Formatting do?

38 / 40

Which command is used to merge cells?

39 / 40

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

40 / 40

Which tab contains the Conditional Formatting option?

Your score is

0%

Pos.NameScoreDurationPoints
1Manish maurya100 %1 minutes 40 / 40
2Khushi gupta100 %1 minutes 4 seconds40 / 40
3Manish maurya100 %1 minutes 6 seconds40 / 40
4Shaan100 %1 minutes 6 seconds40 / 40
5Sonalika singh100 %1 minutes 9 seconds40 / 40
6Khushi gupta100 %1 minutes 12 seconds40 / 40
7Krishna Rawat100 %1 minutes 14 seconds40 / 40
8Sonalika singh100 %1 minutes 15 seconds40 / 40
9Anchal100 %1 minutes 17 seconds40 / 40
10Nancy gupta100 %1 minutes 17 seconds40 / 40
11Sonalika singh100 %1 minutes 18 seconds40 / 40
12Manish maurya100 %1 minutes 20 seconds40 / 40
13Sonalika singh100 %1 minutes 21 seconds40 / 40
14Sumit yadav100 %1 minutes 23 seconds40 / 40
15Karishma Kumari100 %1 minutes 26 seconds40 / 40
16Sonalika singh100 %1 minutes 28 seconds40 / 40
17Khushi Baranwal100 %1 minutes 28 seconds40 / 40
18Nancy gupta100 %1 minutes 28 seconds40 / 40
19Sonalika singh100 %1 minutes 29 seconds40 / 40
20Khushi Sharma100 %1 minutes 31 seconds40 / 40
21KHUSHI SHARMA100 %1 minutes 33 seconds40 / 40
22Nancy gupta100 %1 minutes 34 seconds40 / 40
23sumityadav100 %1 minutes 36 seconds40 / 40
24Sonalika singh100 %1 minutes 37 seconds40 / 40
25sumityadav100 %1 minutes 38 seconds40 / 40
26sumityadav100 %1 minutes 38 seconds40 / 40
27Sonalika singh100 %1 minutes 39 seconds40 / 40
28Shubham Yadav100 %1 minutes 39 seconds40 / 40
29Khushi gupta100 %1 minutes 47 seconds40 / 40
30Anchal100 %1 minutes 49 seconds40 / 40
31Anjali Pandey100 %1 minutes 49 seconds40 / 40
32Muskan Sharma100 %1 minutes 50 seconds40 / 40
33Khushi Sharma100 %1 minutes 55 seconds40 / 40
34Sonalika singh100 %1 minutes 57 seconds40 / 40
35Priyanka100 %1 minutes 58 seconds40 / 40
36Khushi gupta100 %1 minutes 58 seconds40 / 40
37Jyoti100 %2 minutes 8 seconds40 / 40
38Sonalika singh100 %2 minutes 12 seconds40 / 40
39Rimjhim Jaiswal100 %2 minutes 19 seconds40 / 40
40Priyanka100 %2 minutes 27 seconds40 / 40
41Mohanish100 %3 minutes 40 / 40
42Muskan Sharma100 %3 minutes 4 seconds40 / 40
43Priya Pandey100 %3 minutes 4 seconds40 / 40
44Sonalika singh100 %3 minutes 27 seconds40 / 40
45Astha Singh100 %3 minutes 47 seconds40 / 40
46Sonali Seth100 %4 minutes 21 seconds40 / 40
47Manish maurya98 %1 minutes 3 seconds39 / 40
48Manish maurya98 %1 minutes 3 seconds39 / 40
49Krishna rawat98 %1 minutes 19 seconds39 / 40
50Krishna rawat98 %1 minutes 20 seconds39 / 40
51Khushi Baranwal98 %1 minutes 21 seconds39 / 40
52Sonalika singh98 %1 minutes 24 seconds39 / 40
53Krishna Rawat98 %1 minutes 25 seconds39 / 40
54Mohit98 %1 minutes 36 seconds39 / 40
55Khushi Baranwal98 %1 minutes 38 seconds39 / 40
56Karishma Kumari98 %1 minutes 42 seconds39 / 40
57sumityadav98 %1 minutes 44 seconds39 / 40
58sumityadav98 %1 minutes 47 seconds39 / 40
59Nancy gupta98 %1 minutes 58 seconds39 / 40
60Krishna rawat98 %2 minutes 8 seconds39 / 40
61Rimjhim Jaiswal98 %2 minutes 15 seconds39 / 40
62Harsh98 %2 minutes 19 seconds39 / 40
63Anjali Pandey98 %2 minutes 19 seconds39 / 40
64Priya Pandey98 %2 minutes 32 seconds39 / 40
65Rimjhim98 %2 minutes 40 seconds39 / 40
66KHUSHI SHARMA98 %2 minutes 44 seconds39 / 40
67Harsh98 %2 minutes 54 seconds39 / 40
68Harsh98 %3 minutes 20 seconds39 / 40
69Khushi Sharma98 %3 minutes 52 seconds39 / 40
70Ritesh98 %4 minutes 56 seconds39 / 40
71Raushan98 %5 minutes 4 seconds39 / 40
72Manish maurya95 %1 minutes 25 seconds38 / 40
73Nancy gupta95 %1 minutes 35 seconds38 / 40
74Shaan khan95 %2 minutes 4 seconds38 / 40
75Shivangi95 %2 minutes 23 seconds38 / 40
76Manish maurya95 %2 minutes 34 seconds38 / 40
77Astha Singh95 %2 minutes 37 seconds38 / 40
78Nancy gupta95 %2 minutes 39 seconds38 / 40
79Astha Singh95 %3 minutes 20 seconds38 / 40
80Sristy kumari95 %3 minutes 24 seconds38 / 40
81Sristy kumari95 %3 minutes 28 seconds38 / 40
82Pooja maurya95 %3 minutes 35 seconds38 / 40
83Astha Singh95 %3 minutes 39 seconds38 / 40
84Harsh kumar singh95 %4 minutes 43 seconds38 / 40
85Rishabh95 %5 minutes 29 seconds38 / 40
86Rohit93 %1 minutes 12 seconds37 / 40
87Nancy gupta93 %1 minutes 23 seconds37 / 40
88Manish maurya93 %1 minutes 27 seconds37 / 40
89Manish maurya93 %1 minutes 40 seconds37 / 40
90Ranesh93 %1 minutes 45 seconds37 / 40
91Khushi Baranwal93 %1 minutes 50 seconds37 / 40
92Khushi Baranwal93 %1 minutes 53 seconds37 / 40
93Astha Singh93 %2 minutes 3 seconds37 / 40
94Astha Singh93 %2 minutes 13 seconds37 / 40
95Shobha93 %4 minutes 12 seconds37 / 40
96Rishabh93 %6 minutes 59 seconds37 / 40
97Khushi Baranwal90 %1 minutes 34 seconds36 / 40
98Sonam90 %1 minutes 37 seconds36 / 40
99Khushi Baranwal90 %1 minutes 43 seconds36 / 40
100Astha Singh90 %2 minutes 18 seconds36 / 40
Scroll to Top