Excel Basic Online Test Series 6125

198

Excel Basic Online Test Series 6125

1 / 30

1) A group of cells called a________

Cell range

Chart

Cell Cluster

Multicell

2 / 30

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

Formulas

Permissions

Number Formats

Worksheet

3 / 30

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

Chart

Sum

Worksheet

Cell

4 / 30

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

Counta()

Sum()

Count()

Subtract()

5 / 30

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

Sreenshot

Macro

None of these

Micro

6 / 30

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

Right

Left

Center

Forward

7 / 30

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

Win+H

F10

8 / 30

8) Formulas in Excel start with____

9 / 30

9) What is the extension name of Excel file

10 / 30

10) MS Excel is a

Presentation Software

Spreadsheet Software

Database Management Software

Workbook Software

11 / 30

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

=F2+F3+F+53

A3+100

=R2*D2

=5B+6B

12 / 30

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

False

True

13 / 30

13) What is the run command of MS excel

Ms excel

none of these

msexcel

excel

14 / 30

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

Merge and Center

Merge cells

None of these

Use the format cells dialog box

15 / 30

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

Ctrl+S

Ctrl+N

F12

16 / 30

16) What is a shortcut key for undo?

Ctrl+Z

Ctrl+X

Ctrl+Y

Ctrl+B

17 / 30

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

18 / 30

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

Filter

Sort

Auto Complete

Auto Sum

19 / 30

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

Ctrl+E

Ctrl+W

Ctrl+C

ESC

20 / 30

20) last column name is?

XFD

DXF

None of these

FXD

21 / 30

21) What is shortcut key of wrap text.

Alt+H, W

Alt+H, L

Alt+H, O

Alt+H, A, R

22 / 30

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

View

Review

Developer

Formula

23 / 30

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

$A$

#A2

A:2

24 / 30

24) What number format can you use in excel

All of these formats

Percentage

Decimal

FractIon

25 / 30

25) MS Excel stand for

26 / 30

26) MS Excel has column limit of______

84163

16384

18634

13684

28 / 30

28) last row name is?

1048687

1048567

1048576

1045867

29 / 30

29) last cell name is?

FXD1048567

XFD1048576

XFD1048567

XFD1048657

30 / 30

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

None of these

Use the format cells dialog box

Merge cells

Merge and Center

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