MS Excel Question & Answer MCQ SET 4
31.The cell reference for cell range of G2 to M12 is ________
A) G2.M12
B) G2;M12
C) G2:M12
D) G2-M12
ANSWER: OPTION C
32.What do you mean by a Workspace?
A) Group of Columns
B) Group of Worksheets
C) Group of Rows
D) Group of Workbooks
ANSWER: OPTION D
33.One can find “Autosum” option under
A) View tab
B) Insert tab
C) Data tab
D) Home tab
ANSWER: OPTION D
34.In Excel, by default Numeric Values appears in
A) Left aligned
B) Right aligned
C) Center aligned
D) Justify aligned
ANSWER: OPTION B
35.How are data organized in a spreadsheet?
A) Height and width
B) Lines and spaces
C) Rows and columns
D) Layers and planes
ANSWER: OPTION C
36.A function inside another function is known as?
A) Round function
B) Sandwich function
C) Switch function
D) Nested function
ANSWER: OPTION D
37.By default, How many sheets are there in Excel – 2003 or 2007 file?
A) 4
B) 3
C) 5
D) None
ANSWER: OPTION B
38.“Goal Seek” can be applied on
A) Single Records
B) Multiple Records
C) Either A or B
D) None of the above
ANSWER: OPTION A
39.$A$2 ia an example of:
A) Absolute Reference
B) Relative Reference
C) Mixed Reference
D) None of the above
ANSWER: OPTION A
40.Predict the output of the following function: power(5,2)
A) 32
B) 25
C) 10
D) None of the above
ANSWER: OPTION B
0 Comments