Microsoft Excel MCQs for Competitive Exams

2071

If a cell shows a red triangle in its top right corner, this means:

A There is an error in the cell B The font in the cell is red C There is a comment on the cell D Formula cannot be entered

Answer & Solution Discuss Save Report

2072

When you link data maintained in an Excel workbook to a Word document:

A The Word document contains only a reference to the original application B The Word document can’t be edited C The Word document must contain a hyperlink D The Word document contains a data copy

Answer & Solution Discuss Save Report

2073

“Weight” in formatting refers to:

A Print density of characters B Height of characters C Shape (upright or slanted) D Look and appearance

Answer & Solution Discuss Save Report

2074

How do you group noncontiguous worksheets?

A The Ctrl key and mouse B Shift key and mouse C Group button on standard toolbar D Alt+Enter

Answer & Solution Discuss Save Report

2075

When you use Print Preview, you can display:

A Entire worksheet B Selected range C Active portion D All of the above

Answer & Solution Discuss Save Report

2076

In a worksheet you can select:

A Entire worksheet B Columns C Rows D All of the above

Answer & Solution Discuss Save Report

2077

When the formula bar is activated, you can see:

A Edit Formula button B Cancel button C Enter button D All of the above

Answer & Solution Discuss Save Report

2078

To move to the previous cell in a selected range, press:

A Tab B Alt C Enter D None of above

Answer & Solution Discuss Save Report

2079

To create a vertical page break, the active cell should be:

A Anywhere in the worksheet B A1 C In row 1 D In column A

Answer & Solution Discuss Save Report

2080

To drag a range of data to another worksheet, hold down the:

A Shift key B Ctrl key C Tab key D Alt key

Answer & Solution Discuss Save Report