Microsoft Excel Questions
Q31. Which of the following alignments will apply by default when some text is entered in a cell in a worksheet of Microsoft Excel
(a) Centre
(b) Left
(c) Right
(d) None of the above
Answer: (b) Left
Q32. Which of the following addressing modes can be used for writing formulas in a cell in a worksheet in Microsoft Excel
(a) Relative
(b) Absolute
(c) Mixed
(d) All of the above
Answer: (d) All of the above
Q33. Mixed cell reference in Excel is denoted by the Address parts as
(a) $A$4
(b) $A4
(c) A4
(d) $A4$
Answer: (b) $A4
Q34. Absolute cell reference in Excel is used to represent
(a) Relative cell address
(b) Actual cell address
(c) Circular cell address
(d) Mixed cell address
Answer: (b) Actual cell address
Q35. By default ____________ number of worksheet are present in a workbook
(a) 1
(b) 2
(c) 3
(d) 4
Answer: (c) 3
Practice Test Exam