Excel Intermediate Online Test Series 6129

1 / 40

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

F11

2 / 40

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

Data

Home

Review

Insert

3 / 40

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

Edit

Ignore all

Ignore

Change

4 / 40

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

Alphabetic

Numeric

Alphanemeric

Special Characters

5 / 40

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

Pressing the Esc key

Pressing the tab key

clicking the enter button to the formula bar

Pressing on arrow key

6 / 40

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

Current Cell

Previous Cell

Next Cell

formula Bar

7 / 40

7) You can group noncontiguous worksheets with

The Alt+Enter Key

The Ctrl key and mouse

The Shift key and the mouse

The group button on the standard toolbar

8 / 40

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

General

Union

Range

Formula

9 / 40

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

LOWER()|

MAX()

IF()

NOW()

10 / 40

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

Database

Spreadsheet

Drawing

Word Processing

11 / 40

11) the default header for a worksheet is __

None

Data and Time

Sheet Tab Name

Username

12 / 40

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

Status Bar

Title Bar

Ruler

Scroll Bar

13 / 40

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

Single Engineering

Double Accounting

Double

Single Accounting

14 / 40

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

Home

Page Up

Ctrl+Page Up

Ctrl +Home

15 / 40

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

Home

Data

Review

Insert

16 / 40

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

Moves cell pointer to next column

Moves cell pointer previous row

Moves cell pointer to previous column

Moves cell pointer next row

17 / 40

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

NOW()

SING

COUNT()

MID()

18 / 40

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

Ctrl+Enter

SHift+Enter

Alt+Enter

Tab+Enter

19 / 40

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

Formula

Sort

Filter

FInd

20 / 40

20) What is short cut key of slicer?

Alt+N,S,L

Alt+N,S,E

Alt+N,S,F

Alt+N,S,D

21 / 40

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

Find

Filter

Sort

Format

22 / 40

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

Moves cell pointer to previous column

Moves cell pointer to next row

Moves cell pointer to next column

Moves cell pointer to previous row

23 / 40

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

Trim()

Mode

Median()

Mid()

24 / 40

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

Page Layout

Review

View

Data

25 / 40

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

LEN

Celling

DMAX

MAX

26 / 40

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

Sumif()

ABS()

Sum()

Count()

27 / 40

27) 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 ?

Relative

Mixed

Absolute

General

28 / 40

28) The spelling tool is placed on toolbar

Formatting

Standard

Drawing

Review

29 / 40

29) How cells are maned MS Excel

Special character

Alphanumerically

Alphabetically

Numerically

30 / 40

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

Review

Formula

Data

Insert

31 / 40

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

View>Show/hide>formula bar

Insert>Show/hide> formula bar

Home>Show/hide>formula bar

Data>Show/hide>formula bar

32 / 40

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

Count()

Sumif()

Sum()

ABS()

33 / 40

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

Access

Power Point

Word

Excel

34 / 40

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

F11

35 / 40

35) A function inside another function is called__

Sum Function

Text Function

Nested Functon

Round Function

36 / 40

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

G1.M12

G2-M12

G2:M12

G2;M12

37 / 40

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

F12

38 / 40

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

Page Layout View

Full Screen View

Custom View

Page Break View

39 / 40

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

Insert

Data

Review

Page layout

40 / 40

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

MID()

MOD()

FIND()

NOW()

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