Excel Intermediate Online Test Series 6129

1 / 40

1) The software which contains rows and columns is called?

Spreadsheet

Word Processing

Drawing

Database

2 / 40

2) Which of the following in not an option of the spelling dialog box ?

Change

Ignore

Ignore all

Edit

3 / 40

3) What is the purpose of ‘Enter key’ in MS Excel?

Moves cell pointer to previous row

Moves cell pointer to next column

Moves cell pointer to next row

Moves cell pointer to previous column

4 / 40

4) Which type of key should combine with Ctrl Key to create a macro key in Excel?

Alphanemeric

Alphabetic

Numeric

Special Characters

5 / 40

5) Which type of addressing is used to keep rows constant and column changes and vice versa while copying a formula from one area of the worksheet to another in Excel ?

General

Absolute

Mixed

Relative

6 / 40

6) The cell reference for cell range of G2 to M12 is

G2;M12

G2-M12

G1.M12

G2:M12

7 / 40

7) Which function is used to add the values in a range?

Count()

Sumif()

ABS()

Sum()

8 / 40

8) Which function key is used to open go to dialogue box in MS Excel?

F11

9 / 40

9) Which view in Excel display the pages exactly as they appear

Custom View

Page Layout View

Full Screen View

Page Break View

10 / 40

10) The spelling tool is placed on toolbar

Review

Formatting

Drawing

Standard

11 / 40

11) Which option in MS Excel is used to display the row that meet certain conditions?

Filter

FInd

Formula

Sort

12 / 40

12) Which tool in MS office is best for organizing data and making lists?

Word

Excel

Access

Power Point

13 / 40

13) Which tab is used for creating, formatting and editing a spreadsheet?

Data

Insert

Home

Review

14 / 40

14) Which function in Excel is used to find the biggest value in a range?

MAX

Celling

LEN

DMAX

15 / 40

15) Which tap in Excel is used when importing ,querying, outlining and subtotaling the data placed into a worksheet’s data list?

Data

Formula

Insert

Review

16 / 40

16) What is the purpose ‘Tab’ key in MS Excel?

Moves cell pointer previous row

Moves cell pointer to next column

Moves cell pointer to previous column

Moves cell pointer next row

17 / 40

17) Which one of the following is Date and Time function in Excel?

MOD()

FIND()

NOW()

MID()

18 / 40

18) Which function is used to count the numbers in a range?

ABS()

Sumif()

Sum()

Count()

19 / 40

19) What is short cut key of slicer?

Alt+N,S,L

Alt+N,S,E

Alt+N,S,D

Alt+N,S,F

20 / 40

20) What is the keyboard shortcut for creating a chart from the selected cell range?

F11

21 / 40

21) Which tap is used to include pivot table, charts and hyperlinks to a spread sheet?

Data

Review

Insert

Page layout

22 / 40

22) Which tab is used for tables ,illustration and tours and mores

Insert

Home

Data

Review

23 / 40

23) Which key is used to move the insertion point to the beginning of the current sheet?

Page Up

Ctrl +Home

Ctrl+Page Up

Home

24 / 40

24) A function inside another function is called__

Nested Functon

Round Function

Sum Function

Text Function

25 / 40

25) Which of the following methods will not enter data in a cell?

Pressing on arrow key

Pressing the tab key

clicking the enter button to the formula bar

Pressing the Esc key

26 / 40

26) You can group noncontiguous worksheets with

The group button on the standard toolbar

The Alt+Enter Key

The Ctrl key and mouse

The Shift key and the mouse

27 / 40

27) Which option in Excel is used to rearrange the rows base on the content of a particular column?

Format

Find

Sort

Filter

28 / 40

28) Which function key is used to open save as dialogue box in MS Excel?

F12

29 / 40

29) Which of the following is not an underline option in the format cells dialog box?

Single Engineering

Single Accounting

Double

Double Accounting

30 / 40

30) Where does the result display when a formula is entered in Excel?

Current Cell

Previous Cell

Next Cell

formula Bar

31 / 40

31) Which one of the following is a text function in MS Excel?

SING

COUNT()

NOW()

MID()

32 / 40

32) Which sequence of operation is used to insert the hidden formula bar in Excel worksheet?

Home>Show/hide>formula bar

Insert>Show/hide> formula bar

View>Show/hide>formula bar

Data>Show/hide>formula bar

33 / 40

33) Which key is used to make multiple line in a single cell?

SHift+Enter

Alt+Enter

Tab+Enter

Ctrl+Enter

34 / 40

34) Which one of the following is ‘No Argument’ function?

MAX()

NOW()

LOWER()|

IF()

35 / 40

35) What do you mean by A3,B13:B20,C7 reference in Excel?

Union

Formula

General

Range

36 / 40

36) Which function is used to find the middle number in a range?

Mid()

Mode

Median()

Trim()

37 / 40

37) the default header for a worksheet is __

Username

Data and Time

Sheet Tab Name

None

38 / 40

38) How cells are maned MS Excel

Alphabetically

Numerically

Alphanumerically

Special character

39 / 40

39) Which bar lies top of the window in MS Excel?

Ruler

Title Bar

Status Bar

Scroll Bar

40 / 40

40) Which tab is used to change the display of worksheet area and the data it co0ntains?

Data

Review

Page Layout

View

Your score is

Pos.	Name	Score	Duration	Points
1	Samiksha Yadav	100 %	1 minutes 59 seconds	40 / 40
2	Roli	100 %	2 minutes 12 seconds	40 / 40
3	Pawan	100 %	2 minutes 20 seconds	40 / 40
4	Prince Pandey	100 %	2 minutes 30 seconds	40 / 40
5	Aditya Patel	100 %	2 minutes 32 seconds	40 / 40
6	Akash singh	100 %	2 minutes 41 seconds	40 / 40
7	Pramila yadav	100 %	2 minutes 50 seconds	40 / 40
8	Shivani chaurasiya	100 %	3 minutes 13 seconds	40 / 40
9	Mamta kumari	100 %	3 minutes 16 seconds	40 / 40
10	Arfat	100 %	5 minutes 46 seconds	40 / 40
11	Nishant Kumar	98 %	1 minutes 35 seconds	39 / 40
12	Ching chong	98 %	3 minutes	39 / 40
13	Neha patel	98 %	3 minutes 4 seconds	39 / 40
14	Jivika	98 %	3 minutes 29 seconds	39 / 40
15	Shivani chaurasiya	98 %	3 minutes 52 seconds	39 / 40
16	aqsa	98 %	5 minutes 15 seconds	39 / 40
17	Nishant Kumar	95 %	1 minutes 30 seconds	38 / 40
18	Amit	95 %	1 minutes 34 seconds	38 / 40
19	Amit	95 %	1 minutes 35 seconds	38 / 40
20	Arfat	95 %	1 minutes 37 seconds	38 / 40
21	Amit	95 %	1 minutes 47 seconds	38 / 40
22	Pawan	95 %	2 minutes 5 seconds	38 / 40
23	Samiksha Yadav	95 %	2 minutes 7 seconds	38 / 40
24	Jivuka	95 %	3 minutes 32 seconds	38 / 40
25	Pinki kumari	95 %	3 minutes 39 seconds	38 / 40
26	Shivani chaurasiya	95 %	3 minutes 54 seconds	38 / 40
27	Monu	95 %	4 minutes 6 seconds	38 / 40
28	Shahjadi jaismin	95 %	5 minutes	38 / 40
29	Ujala Kumari	95 %	5 minutes 6 seconds	38 / 40
30	Nishant Kumar	93 %	1 minutes 36 seconds	37 / 40
31	Nishant Kumar	93 %	1 minutes 39 seconds	37 / 40
32	Amit	93 %	1 minutes 42 seconds	37 / 40
33	Nishant Kumar	93 %	1 minutes 42 seconds	37 / 40
34	Arfat	93 %	1 minutes 49 seconds	37 / 40
35	Amit	93 %	2 minutes 4 seconds	37 / 40
36	Khushi sahani	93 %	3 minutes 1 seconds	37 / 40
37	Khushi sahani	93 %	3 minutes 4 seconds	37 / 40
38	Neha patel	93 %	3 minutes 39 seconds	37 / 40
39	Amit	90 %	1 minutes 42 seconds	36 / 40
40	Amit	90 %	1 minutes 43 seconds	36 / 40
41	Amit	90 %	1 minutes 46 seconds	36 / 40
42	Amit	90 %	2 minutes	36 / 40
43	Mamta kumari	90 %	3 minutes 7 seconds	36 / 40
44	monu	90 %	3 minutes 26 seconds	36 / 40
45	U	90 %	4 minutes 50 seconds	36 / 40
46	Ujala Kumari	90 %	4 minutes 53 seconds	36 / 40
47	aqsa	90 %	6 minutes 48 seconds	36 / 40
48	Amit	88 %	2 minutes 23 seconds	35 / 40
49	Pramila yadav	88 %	3 minutes 23 seconds	35 / 40
50	Mamta kumari	88 %	4 minutes 30 seconds	35 / 40
51	aqsa	88 %	10 minutes 2 seconds	35 / 40
52	Amit	85 %	2 minutes 9 seconds	34 / 40
53	Mamta kumari	85 %	3 minutes 37 seconds	34 / 40
54	Jivika	85 %	5 minutes 2 seconds	34 / 40
55	Monu	85 %	6 minutes 40 seconds	34 / 40
56	Ritik	83 %	5 minutes 48 seconds	33 / 40
57	Mohammad Zaid	83 %	11 minutes 6 seconds	33 / 40
58	Amit	80 %	3 minutes 26 seconds	32 / 40
59	Pinki kumari	80 %	5 minutes 58 seconds	32 / 40
60	Pinki kumari	78 %	9 minutes 14 seconds	31 / 40
61	Amit	73 %	3 minutes 23 seconds	29 / 40
62	Jivuka	73 %	3 minutes 41 seconds	29 / 40
63	Monu	73 %	4 minutes 34 seconds	29 / 40
64	joe	73 %	5 minutes 32 seconds	29 / 40
65	Shahjadi jaismin	73 %	8 minutes 40 seconds	29 / 40
66	Monu	73 %	11 minutes 50 seconds	29 / 40
67	Rinku	70 %	3 minutes 45 seconds	28 / 40
68	Jivika	68 %	6 minutes 16 seconds	27 / 40
69	Monu	65 %	8 minutes 53 seconds	26 / 40
70	Jivika	60 %	5 minutes 22 seconds	24 / 40
71	Isneha	60 %	11 minutes 38 seconds	24 / 40
72	Shahjadi jaismin	60 %	12 minutes 29 seconds	24 / 40
73	Amit	53 %	3 minutes 18 seconds	21 / 40
74	Ujala Kumari	53 %	6 minutes 49 seconds	21 / 40
75	CAROLINE	50 %	7 minutes 19 seconds	20 / 40
76	H	50 %	8 minutes 23 seconds	20 / 40
77	caroline	50 %	8 minutes 51 seconds	20 / 40
78	Ujala Kumari	48 %	9 minutes 9 seconds	19 / 40
79	ravi	38 %	4 minutes 53 seconds	15 / 40
80	Amit	33 %	6 minutes 2 seconds	13 / 40
81	K	33 %	8 minutes 36 seconds	13 / 40
82	H	30 %	1 minutes 32 seconds	12 / 40
83	Jivika	30 %	8 minutes 59 seconds	12 / 40
84	Dharmendra dhakak	28 %	2 minutes 34 seconds	11 / 40
85	Monu	28 %	13 minutes 6 seconds	11 / 40
86	Shivani chaurasiya	25 %	12 minutes 46 seconds	10 / 40
87	Khushi sahani	23 %	8 minutes 11 seconds	9 / 40
88	Isneha	20 %	16 minutes 40 seconds	8 / 40
89	Dibya	18 %	3 minutes 15 seconds	7 / 40
90	CAROLINE	5 %	16 minutes 40 seconds	2 / 40
91	Guest	0 %	0 second	0 / 0
92	Guest	0 %	0 second	0 / 0
93	Guest	0 %	0 second	0 / 0
94	Guest	0 %	0 second	0 / 0
95	Guest	0 %	0 second	0 / 0
96	Guest	0 %	0 second	0 / 0
97	Guest	0 %	0 second	0 / 0
98	Mr. Suryakant Dubey	0 %	0 second	0 / 0
99	Guest	0 %	0 second	0 / 0
100	Guest	0 %	0 second	0 / 0

Related Posts