(A) Wrap Text>Cells, Layout Tab
(B) Justify in Edit>>Cells
(C) Wrap Text from Home Tab
(D) All of the above
Tag: Excel Mcq
Which command is used to convert a column of data into row?
(A) Right Click>>Paste Special>>Transpose
(B) Cut and Paste
(C) Both of the above
(D) None of the above
Which among following option is not available in Paste Special dialog box?
(A) Divide
(B) SQRT
(C) Subtract
(D) Add
Which among following excel screen components can not be turned on or off?
(A) Toolbar
(B) Status bar
(C) Formula bar
(D) None of the above
Which button do you click to add up a series of numbers?
(A) The formula button
(B) The quick button
(C) The total button
(D) The autosum button
Which tool used to join some cells and place the content at the middle of joined cells?
(A) From insert tab choose Merge and Center
(B) Click on Merge and Center tool on Home Tab
(C) From view tab click on Merge cells check box
(D) None of the above
In worksheet cells we can enter which type of data?
(A) Labels and values but not formulas
(B) Labels, Values, Formulas
(C) Values and formulas but not labels
(D) None of the above
To hold row and columns titles in place so that they do not scroll when you scroll a worksheet click the?
(A) Freeze panes command on the view menu
(B) Hold titles command on the data menu
(C) Split command on the window menu
(D) None of the above