Excel Basic Online Test Series 6125

202

Excel Basic Online Test Series 6125

1 / 30

1) How do you merge two or more cells in Excel?

Merge and Center

Merge cells

None of these

Use the format cells dialog box

2 / 30

2) In MS Excel, Ctrl+S can be used to?

3 / 30

3) Formulas in Excel start with____

4 / 30

4) Which tab of the ribbon should you go to for removing gridlines on a worksheet?

View

Developer

Formula

Review

5 / 30

5) In an MS Excel workbook, can it be closed using a keyboard shortcut?

Ctrl+E

Ctrl+W

Ctrl+C

ESC

6 / 30

6) You can view a formula by double-clicking the cell that contains the formula.

True

False

7 / 30

7) Which of the following is not a type of alignment in Excel

Center

Right

Left

Forward

8 / 30

8) The intersection of a row and a column is called a_____

Sum

Chart

Worksheet

Cell

10 / 30

10) Which key is used to help in MS Excel?

Win+H

F10

11 / 30

11) Which of the following is not a valid function in ms excel

Count()

Subtract()

Counta()

Sum()

12 / 30

12) What is a shortcut key for undo?

Ctrl+X

Ctrl+Z

Ctrl+B

Ctrl+Y

13 / 30

13) What number format can you use in excel

Percentage

FractIon

All of these formats

Decimal

14 / 30

14) last row name is?

1048576

1045867

1048687

1048567

15 / 30

15) In MS Excel ____the feature makes it easier to add repetitive data to a a worksheet

Auto Complete

Sort

Auto Sum

Filter

16 / 30

16) MS Excel is a

Database Management Software

Workbook Software

Spreadsheet Software

Presentation Software

17 / 30

17) Which of the formulas below are valid? Select all that apply

=5B+6B

A3+100

=R2*D2

=F2+F3+F+53

18 / 30

18) MS Excel stand for

19 / 30

19) What is the extension name of Excel file

20 / 30

20) What is shortcut key of wrap text.

Alt+H, O

Alt+H, A, R

Alt+H, L

Alt+H, W

21 / 30

21) MS Excel has column limit of______

13684

18634

16384

84163

22 / 30

22) In MS Excel, the keyboard shortcut keys to open the Save As dialog box is_______

Ctrl+N

F12

Ctrl+S

23 / 30

23) last cell name is?

XFD1048567

FXD1048567

XFD1048576

XFD1048657

24 / 30

24) You can click the tabs at the bottom of a workbook to switch between?

Permissions

Number Formats

Formulas

Worksheet

25 / 30

25) How do you merge two or more cells in Excel?

None of these

Merge and Center

Use the format cells dialog box

Merge cells

26 / 30

26) What is the run command of MS excel

msexcel

Ms excel

none of these

excel

27 / 30

27) last column name is?

XFD

FXD

None of these

DXF

28 / 30

28) You can record the mouse and keyboard actions and use them later using ______option.

None of these

Macro

Micro

Sreenshot

29 / 30

29) Which of the following is an absolute cell reference?

A:2

#A2

$A$

30 / 30

30) A group of cells called a________

Chart

Cell range

Cell Cluster

Multicell

Your score is

Pos.	Name	Score	Duration	Points
1	Joe	100 %	1 minutes 20 seconds	30 / 30
2	Pawan	100 %	1 minutes 22 seconds	30 / 30
3	Joe	100 %	1 minutes 23 seconds	30 / 30
4	Pramila yadav	100 %	1 minutes 23 seconds	30 / 30
5	Rk	100 %	1 minutes 27 seconds	30 / 30
6	Homelander 💀	100 %	1 minutes 30 seconds	30 / 30
7	Nishant Kumar	100 %	1 minutes 30 seconds	30 / 30
8	Pramila	100 %	1 minutes 32 seconds	30 / 30
9	Homelander 👿	100 %	1 minutes 34 seconds	30 / 30
10	Chahat	100 %	1 minutes 35 seconds	30 / 30
11	Akash	100 %	1 minutes 38 seconds	30 / 30
12	Nishant Kumar	100 %	1 minutes 45 seconds	30 / 30
13	Pinki	100 %	1 minutes 47 seconds	30 / 30
14	Ansh	100 %	1 minutes 47 seconds	30 / 30
15	Neha Patel	100 %	1 minutes 49 seconds	30 / 30
16	Ygg	100 %	2 minutes 2 seconds	30 / 30
17	Diksha	100 %	2 minutes 11 seconds	30 / 30
18	Joe	100 %	2 minutes 13 seconds	30 / 30
19	Neha Patel	100 %	2 minutes 31 seconds	30 / 30
20	Priya Raj	100 %	2 minutes 35 seconds	30 / 30
21	RUCHI PANDEY	100 %	3 minutes 21 seconds	30 / 30
22	Saijal Vishwakarma	100 %	3 minutes 41 seconds	30 / 30
23	Harsh Vardhan Singh	100 %	4 minutes 42 seconds	30 / 30
24	Samiksha	97 %	1 minutes 29 seconds	29 / 30
25	Shivani chaurasiya	97 %	1 minutes 48 seconds	29 / 30
26	Shivani chaurasiya	97 %	1 minutes 51 seconds	29 / 30
27	Ashish	97 %	1 minutes 57 seconds	29 / 30
28	Shivani chaurasiya	97 %	1 minutes 58 seconds	29 / 30
29	Riya	97 %	1 minutes 59 seconds	29 / 30
30	Nishant Kumar	97 %	2 minutes	29 / 30
31	Pramila yadav	97 %	2 minutes	29 / 30
32	Riya	97 %	2 minutes 1 seconds	29 / 30
33	Mamta kumari	97 %	2 minutes 12 seconds	29 / 30
34	Nishant Kumar	97 %	2 minutes 13 seconds	29 / 30
35	Diksha singh	97 %	2 minutes 15 seconds	29 / 30
36	pawan	97 %	2 minutes 15 seconds	29 / 30
37	Gfgg	97 %	2 minutes 15 seconds	29 / 30
38	MOHIT	97 %	2 minutes 22 seconds	29 / 30
39	Ashwani Yadav	97 %	2 minutes 37 seconds	29 / 30
40	Pooja	97 %	2 minutes 38 seconds	29 / 30
41	Pramila	97 %	2 minutes 41 seconds	29 / 30
42	Jagriti srivastava	97 %	2 minutes 53 seconds	29 / 30
43	Tyy	97 %	2 minutes 56 seconds	29 / 30
44	Ujala Kumari	97 %	2 minutes 58 seconds	29 / 30
45	Pramila yadav	97 %	2 minutes 58 seconds	29 / 30
46	Priya	97 %	3 minutes 3 seconds	29 / 30
47	Pramila yadav	97 %	3 minutes 4 seconds	29 / 30
48	Zaid	97 %	3 minutes 8 seconds	29 / 30
49	MD Zaid	97 %	3 minutes 22 seconds	29 / 30
50	Mamta kumari	97 %	3 minutes 27 seconds	29 / 30
51	Mamta kumari	97 %	3 minutes 31 seconds	29 / 30
52	arfat	97 %	4 minutes 2 seconds	29 / 30
53	xswtyyt	97 %	4 minutes 23 seconds	29 / 30
54	Mohit Srivastav	97 %	4 minutes 59 seconds	29 / 30
55	Shahjadi jaismin	97 %	5 minutes 1 seconds	29 / 30
56	Neha Patel	97 %	5 minutes 18 seconds	29 / 30
57	Priyanjli	93 %	1 minutes 47 seconds	28 / 30
58	Ansh	93 %	2 minutes 1 seconds	28 / 30
59	Pinki	93 %	2 minutes 6 seconds	28 / 30
60	Shivani chaurasiya	93 %	2 minutes 7 seconds	28 / 30
61	Diksha singh	93 %	2 minutes 8 seconds	28 / 30
62	Pinki	93 %	2 minutes 15 seconds	28 / 30
63	Ygy	93 %	2 minutes 16 seconds	28 / 30
64	Raj	93 %	2 minutes 27 seconds	28 / 30
65	ANSH BARANWAL	93 %	2 minutes 31 seconds	28 / 30
66	Riya	93 %	2 minutes 35 seconds	28 / 30
67	Mahi	93 %	2 minutes 38 seconds	28 / 30
68	anita	93 %	2 minutes 39 seconds	28 / 30
69	Vidya dubey	93 %	2 minutes 54 seconds	28 / 30
70	Nishant Kumar	93 %	3 minutes 8 seconds	28 / 30
71	Pramila	93 %	3 minutes 15 seconds	28 / 30
72	Shivani chaurasiya	93 %	3 minutes 24 seconds	28 / 30
73	Vidya Dubey	93 %	3 minutes 56 seconds	28 / 30
74	aqsa	93 %	4 minutes 7 seconds	28 / 30
75	Anu	93 %	4 minutes 51 seconds	28 / 30
76	Prince pandey	93 %	5 minutes 9 seconds	28 / 30
77	RUCHI PANDEY	93 %	5 minutes 36 seconds	28 / 30
78	Samiksha	90 %	1 minutes 50 seconds	27 / 30
79	Akash.	90 %	1 minutes 52 seconds	27 / 30
80	Khushi sahani	90 %	1 minutes 59 seconds	27 / 30
81	Raj	90 %	2 minutes 3 seconds	27 / 30
82	Ansh baranwal	90 %	2 minutes 6 seconds	27 / 30
83	Samiksha	90 %	2 minutes 16 seconds	27 / 30
84	Raj	90 %	2 minutes 20 seconds	27 / 30
85	Samiksha	90 %	2 minutes 28 seconds	27 / 30
86	Vidya dubey	90 %	2 minutes 38 seconds	27 / 30
87	Mohit Srivastav	90 %	3 minutes 16 seconds	27 / 30
88	Diksha singh	90 %	3 minutes 18 seconds	27 / 30
89	samiksha	90 %	3 minutes 40 seconds	27 / 30
90	aqsa	90 %	4 minutes 56 seconds	27 / 30
91	Saijal Vishwakarma	90 %	5 minutes 45 seconds	27 / 30
92	Mamta kumari	90 %	5 minutes 56 seconds	27 / 30
93	Khushi baranwal	87 %	1 minutes 59 seconds	26 / 30
94	Ashwani Yadav	87 %	2 minutes 58 seconds	26 / 30
95	Vidya Dubey	87 %	3 minutes 8 seconds	26 / 30
96	MOHIT	87 %	3 minutes 12 seconds	26 / 30
97	Ashwani Yadav	87 %	3 minutes 19 seconds	26 / 30
98	Tygy	87 %	3 minutes 27 seconds	26 / 30
99	Vidya dubey	87 %	3 minutes 36 seconds	26 / 30
100	Yash	87 %	3 minutes 39 seconds	26 / 30

Related Posts