Prev 1 2 3 4 5 Next
31. The currently selected cell address is displayed in ____.
A. Name Box
B. Formula Bar
C. Both A and B
D. None of the above
ANSWER:A
SOLUTION : Currently selected cell address is displayed in the Name Box.
32. Which programming language is used to write a Macro in MS Excel?
A. C
B. C++
C. Java
D. Visual Basic
ANSWER:D
SOLUTION: Visual Basic is the programming language that is used to write a Macro in MS Excel.
33. What is the correct value of the function? =ROUND (1.2345,2)
A. 24
B. 23
C. 25
D. 2
ANSWER:B
SOLUTION: The function =ROUND (1.2345,2) will return 1.23
34. What is the correct value of the function? =ROUND (1.9867,2)
A. 1.98
B. 1.99
C. 2
D. 1.00
ANSWER:B
SOLUTION: The function =ROUND (1.9867,2) will return 1.99
35. In MS Excel, ‘Merge and Center’ is used to ____.
A. Combine and centre the content of the selected cell
B. Combine and centre the content of the current row
C. Concatenate the text of the two cells and returns the text
D. None of the above
ANSWER:A
SOLUTION: In MS Excel, ‘Merge and Center’ is used to combine and centre the content of the selected cell.
36. Which feature is used to wrap extra-long text into multiple lines in MS Excel?
A. Word Wrap
B. Letter Wrap
C. Text Wrap
D. Wrap Text
ANSWER:D
SOLUTION :In MS Excel, ‘Wrap Text’ feature is used to wrap extra-long text into multiple lines so that you can see all text.
37. Which keyboard shortcut is used to apply ‘Wrap Text’ on the selected text?
A. Ctrl + H + W
B. Alt + W + H
C. Alt + H + W
D. Alt + W
ANSWER: C
SOLUTION:The keyboard shortcut used to apply ‘Wrap Text’ on the selected text is Alt + H + W
38. Which feature is used to rotate the text diagonally or vertically of the selected cells in MS Excel?
A. Orientation
B. Text Layout
C. Text Flip
D. Cell Orientation
ANSWER:A
SOLUTION:In MS Excel, the ‘Orientation’ feature is used to rotate the text diagonally or vertically of the selected cells.
39. Steps for protecting a sheet by password in MS Excel?
A. Under the Review Tab, Click on Protect Current Sheet
B. Under Insert Tab, Click on Protect Sheet
C. Under Data Tab, Click on Protect Sheet
D. Under the Review Tab, Click on Protect Sheet
ANSWER:D
SOLUTION: In MS Excel, to protect a sheet by password. Under the Review Tab, Click on Protect Sheet.
40. Under which Tab, the chart options are available in MS Excel?
A. Data
B. Insert
C. Review
D. View
ANSWER:B
SOLUTION: In MS Excel, the chart options are available in Insert Tab.