MCQ on Ms Excel Set 8

 

141.    To drag a selected range of data to another worksheet in the same workbook, use the

a.   Tab key

b.   Alt key

c.   Shift key

d.   Ctrl key

Correct Answer: d

 

142.    When creating a vertical page break

a.   The active cell must be A1

b.   The active cell can be anywhere in the worksheet

c.   The active cell must be in row 1

d.   The active cell must be in column A

Correct Answer: c

 

143.    to activate the previous cell in a pre-selected range, press

a.   the Alt key

b.   the Tab key

c.   the Enter key

d.   none of above

Correct Answer: d

 

144.    When the formula bar is activated, you can see

a.   The Edit Formula button

b.   The Cancel button

c.   The Enter button

d.   All of above

Correct Answer: d

 

145.    In a worksheet you can select

a.   The entire worksheet

b.   Rows

c.   Columns

d.   a, b, and c

Correct Answer: d

 

146.    when you print preview a worksheet

a.   the entire worksheet is displayed

b.   the selected range is displayed

c.   the active portion of the worksheet is displayed

d.   a, b and c

Correct Answer: d

 

147.    You can group noncontiguous worksheets with

a.   The group button on the standard toolbar

b.   The shift key and the mouse

c.   The ctrl key and mouse

d.   The alt+enter key

Correct Answer: c

 

148.    Weight refers to

a.   The print density of characters

b.   The height of the printed character

c.   Upright or slanted shape

d.   The design and appearance of characters

Correct Answer: a

 

149.    When you link data maintained in Excel workbook to a Word document

a.   The Word document cannot be edited

b.   The Word document contains a reference to the original source application

c.   The word document must contain a hyperlink

d.   The word document contains a copy of the actual data

Correct Answer: b. The Word document contains a reference to the original source application

 

150.    When you see a cell with a red triangle in the top right corner, what does this signify?

a.   There is an error in the cell

b.   There is a comment associated with the cell

c.   The font color for text in the cell is red

d.   A formula cannot be entered into the cell

Correct Answer: b