MS Excel MCQs

A. Sheet tabs can be colored

B. Some picture can be applied as a background of a sheet

C. You can set the column width automatically fit the amount of text

D. The width of a row and be specified manually or fit automatically

A. AutoFill

B. Auto correct

C. Auto sum

D. Auto format

A. Doctor’s symbol (Big Plus)

B. Small thin plus icon

C. Mouse Pointer with anchor at the tip

D. None of above

A. Date ()

B. Today ()

C. Now ()

D. Time ()

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. Go to Tools > Options > View tab and mark or remove the check box named Gridline

B. Click Gridline tool on Forms toolbar

C. Both of above

D. None of above

A. Home > Comments

B. Insert > Comment

C. Data > Comments

D. Review > Comments