Online Quiz for beginners - Microsoft Excel Online Quiz

In this Post Online Quiz for beginners - Microsoft Excel Online Quiz included. The main aim of Online quiz making is to support computer beginners who have face problems preparing their quiz exams regarding the MS Excel MCQs. 

1.CTRL+SHIFT+& key is used to enters the

A) current date
B) current time
C) current day
D) none of these

... The answer is B)

2. One Workbook has in MS Excel?

A) Three Worksheets by default 
B) Two Worksheets by default 
C) One Worksheet by default
D) Four Worksheets by default

... The answer is A)

3. The short key unhide a column is in Excel 2010

A) CTRL+SHIFT+O
B) CTRL+SHIFT+P
C) CTRL+SHIFT+Z
D) CTRL+SHIFT+A

... Answer is A)

4. Purpose of MS Excel is the

A) to make CVs
B) to make a presentation
C) to make a calculation
D) none of above

... Answer is C)
"

5. CTRL+5 key is used to

A) sideline
B) outline
C) underline
D) unhide line

... The answer is D)

6. Key used to strike through

A) CTRL+5
B) CTRL+6
C) CTRL+2
D) CTRL+4

... The answer is A)

7. CTRL+1 key used to display the dialog box

A) merge cell
B) format cell
C) bold
D) italic

... The answer is B)

8. CTRL+3 key used to

A) merge cell
B) format cell
C) bold
D) italic

... The answer is D)

9. File extension of MS Excel 2010 file is

A) EXLX
B) EXCL
C) XELX
D) XLSX

... The answer is D)

10. File extension of MS Excel 2003 file is

A) EXLX
B) EXCL
C) XELX
D) XLS

... The answer is D)

11.Intersection of columns and rows are called

A) columns
B) cell
C) table
D) all of them

... The answer is B)

12.Self-made method of calculation is called

A) function
B) math equations
C) formula
D) none of the above

... The answer is C)

13.symbol is used in an absolute reference

A) &
B) $
C) #
D) none of the above

... Answer is B)

14.is the graphical representation of data

A) function
B) shapes
C) chart
D) none of the above

... Answer is C)

15.Pre-made method of calculation is called

A) function
B) math equation
C) formula
D) none of the above

... Answer is A)

16. No of rows in ms excel 2010 is?

A) 1048576
B)1047576
C) 1047576
D) None of these

... The answer is A)

17.last column label in ms excel 2010 previous version is?

A) XDF
B)XXL
C) XFD
D)XLC

... The answer is C)

18. Ms excel 2010 has a number of columns are?

A) 16384
B)15384
C) 14384
D)16348

... The answer is A)

19.the short key for wrap text in ms excel is?

A) alt+shift
B)shift+alt
C) alt+enter
D) None of these

... The answer is C)

20. the default alignment to date in ms excel is?

A) left bottom align
B)right bottom align
C) down bottom align
D)all of these

... The answer is B)

21.maximum font size in ms excel 2010 is?

A) 74
B)75
C) 77
D)72

... The answer is D)

22.the zoom range of ms excel 2010 is?

A)10-400
B)10-500
C)10-405
D)None of these

... The answer is A)

23.the short key to hide a column in ms excel 2010 is?

A)ctrl+P
B)ctrl+O
C)ctrl+H
D)None of these

... The answer is B)

24.the short key to hide a row in ms excel 2010 is?

A)ctrl+7
B)ctrl+8
C)ctrl+9
D)ctrl+3

... The answer is C)

25.the short key to unhide a row in ms excel is?

A)ctrl+shift+10
B)ctrl+shift+9
C)ctrl+9
D)ctrl+3

... The answer is B)

26.a cell cans only view 1024 no of characters and can contain characters are?

A)32368
B)32367
C)32767
D)None of these

... The answer is C)

27. Excel 2010 has an extension by default is?

A)xlsx
B)xlxs
C)xlxx
D)xll

... The answer is A)

28.to insert current date is used?

A)ctrl+;
B)ctrl+:
C)ctrl+D
D)None of these

... The answer is A)

29.Gridline option is available in?

A)insert tab
B)home tab
C)formulas
D)view tab

... The answer is D)

30.ctrl+shift+) is used for what option?

A)hide
B)unhide
C)marking
D)None of these

... The answer is B)