MS Office MCQs

A. Data will be entered in the adjacent cells

B. No data will be entered in the adjacent cells

C. There is no suitable abbreviation for the text

D. There is not time to format the text

A. Wrap Text in Format > Cells

B. Justify in Edit > Cells

C. Text Wrapping in Format > Cells

D. All of above

A. 0

B. 1

C. 5

D. 10

A. You can add more than one condition to check

B. You can set condition to look for Bold and apply Italics on them

C. You can apply Font, border and pattern formats that meets the specified conditions

D. You can delete any condition from Conditional Formatting dialog box if it is not requried

A. The cell content of selected cells disappear from cell and stored in clipboard

B. The cells selected are marked for cutting

C. The selected cells are deleted and the cells are shifted left

D. The selected cells are deleted and cells are shifted up

A. Shows the name of workbook currently working on

B. Shows the name of worksheet currently working on

C. Shows the name of cell or range currently working on

D. None of above

A. Cut and Paste

B. Paste Special > Transpose

C. Both of above

D. None of above

A. From Format Cells dialog box click on Merge Cells check box

B. From Format Cells dialog box select the Centered alignment

C. From Format Cells dialog box choose Merge and Center check box

D. Click on Merge and Center tool on formatting toolbar

A. Right align the content of cell

B. Remove the cell contents of selected cells

C. Fill the selection with active cells to the right

D. None of above

A. Area

B. Line

C. Pie

D. All of the above