Excel Basic Online Test Series 6125

184

Excel Basic Online Test Series 6125

1 / 30

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

Worksheet

Cell

Chart

Sum

2 / 30

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

Ctrl+W

Ctrl+C

Ctrl+E

ESC

3 / 30

3) What is shortcut key of wrap text.

Alt+H, W

Alt+H, O

Alt+H, A, R

Alt+H, L

5 / 30

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

Micro

Macro

None of these

Sreenshot

6 / 30

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

None of these

Merge and Center

Use the format cells dialog box

Merge cells

7 / 30

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

Auto Complete

Auto Sum

Sort

Filter

8 / 30

8) MS Excel stand for

9 / 30

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

Merge cells

None of these

Merge and Center

Use the format cells dialog box

10 / 30

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

Sum()

Subtract()

Counta()

Count()

11 / 30

11) What is a shortcut key for undo?

Ctrl+B

Ctrl+Y

Ctrl+Z

Ctrl+X

12 / 30

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

True

False

13 / 30

13) last cell name is?

FXD1048567

XFD1048576

XFD1048657

XFD1048567

14 / 30

14) Formulas in Excel start with____

15 / 30

15) last row name is?

1045867

1048567

1048687

1048576

16 / 30

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

Formula

Developer

Review

View

17 / 30

17) What number format can you use in excel

Decimal

Percentage

FractIon

All of these formats

18 / 30

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

F10

Win+H

19 / 30

19) last column name is?

FXD

XFD

None of these

DXF

20 / 30

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

$A$

#A2

A:2

21 / 30

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

Number Formats

Worksheet

Permissions

Formulas

22 / 30

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

Left

Right

Forward

Center

23 / 30

23) A group of cells called a________

Cell range

Chart

Cell Cluster

Multicell

24 / 30

24) What is the run command of MS excel

excel

none of these

msexcel

Ms excel

25 / 30

25) MS Excel is a

Database Management Software

Workbook Software

Spreadsheet Software

Presentation Software

26 / 30

26) What is the extension name of Excel file

27 / 30

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

28 / 30

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

A3+100

=R2*D2

=F2+F3+F+53

=5B+6B

29 / 30

29) MS Excel has column limit of______

84163

18634

13684

16384

30 / 30

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

Ctrl+S

Ctrl+N

F12

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

Related Posts