MS Excel Mcqs

MS Excel Mcqs for NTS, PPSC, FPSC, SPSC, KPPSC, AJKPSC, PMS, PTS, Data Entry Operator, Computer Operator and all computer related exams.
[wpdreams_ajaxsearchlite]

Long text can be broken down into many lines within a cell. You can do this through?

by

(A) Wrap Text>Cells, Layout Tab (B) Justify in Edit>>Cells (C) Wrap Text from Home Tab (D) All of the above [showhide type=”post” more_text=”►Correct Option” less_text=”Show less…”] Correct Answer is: C [/showhide]

Which command is used to convert a column of data into row?

by

(A) Right Click>>Paste Special>>Transpose (B) Cut and Paste (C) Both of the above (D) None of the above [showhide type=”post” more_text=”►Correct Option” less_text=”Show less…”] Correct Answer is: A [/showhide]

Which among following option is not available in Paste Special dialog box?

by

(A) Divide (B) SQRT (C) Subtract (D) Add [showhide type=”post” more_text=”►Correct Option” less_text=”Show less…”] Correct Answer is: B [/showhide]

Which among following excel screen components can not be turned on or off?

by

(A) Toolbar (B) Status bar (C) Formula bar (D) None of the above [showhide type=”post” more_text=”►Correct Option” less_text=”Show less…”] Correct Answer is: D [/showhide]

Which button do you click to add up a series of numbers?

by

(A) The formula button (B) The quick button (C) The total button (D) The autosum button [showhide type=”post” more_text=”►Correct Option” less_text=”Show less…”] Correct Answer is: D [/showhide]

Which tool used to join some cells and place the content at the middle of joined cells?

by

(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 [showhide type=”post” more_text=”►Correct Option” less_text=”Show less…”] Correct Answer is: B [/showhide]

In worksheet cells we can enter which type of data?

by

(A) Labels and values but not formulas (B) Labels, Values, Formulas (C) Values and formulas but not labels (D) None of the above [showhide type=”post” more_text=”►Correct Option” less_text=”Show less…”] Correct Answer is: B [/showhide]

To hold row and columns titles in place so that they do not scroll when you scroll a worksheet click the?

by

(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 [showhide type=”post” more_text=”►Correct Option” less_text=”Show less…”] Correct Answer is: A [/showhide]