MS excel set 4 Detailed Explanation And More Example

Question : 1

In Excel you can zoom a worksheet

a) With the mouse pointer in Print Preview

b) With the zoom button on the Print Preview toolbar

c) With the Zoom command on the view menu

d) All of the above

Question : 2

While Finding and Replacing some data in Excel, which of the following statement is valid?

a) You can Find and Replace within the sheet or workbook

b) Excel does not have option to match case for find

c) Excel cannot replace

d) All of above

e) None of these

Question : 3

Which of the following displays the contents of the active cell?

a) Active cell

b) Formula bar

c) Menu bar

d) Name box

e) None of these

Question : 4

You can use drag-and-drop to embed excel worksheet data in a word document

a) By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key

b) By dragging a range of excel data to the word button on the taskbar while pressing Shift key

c) By dragging a range of excel data to the word button on the taskbar while pressing Alt key

d) All of above

e) None of these

Question : 5

In Excel when integrating word and excel, word is usually the

a) Server

b) Destination

c) Client

d) Both (A) and (C)

Question : 6

You can print only an embedded chart by

a) Moving the chart to a chart sheet before you print.

b) Formatting the chart before you print

c) Selecting the chart before you print

d) a and c

e) None of these