MS excel set 6 Detailed Explanation And More Example

Question : 1

In Excel you can use the horizontal and vertical scroll bars to

a) Split a worksheet into two panes

b) View different rows and columns edit the contents of a cell

c) Edit the contents of a cell

d) View different worksheets

Question : 2

In Excel the keyboard shortcut (button or buttons to be presse(D) for creating a chart from the selected cells

a) F3

b) F5

c) F7

d) F11

Question : 3

You can merge the main document with data source in Excel. In mail merge operation, Word is usually

a) server

b) source

c) client

d) none

e) None of these

Question : 4

Which of the following methods cannot be used to edit the content of cell?

a) Pressing the Alt key

b) Clicking the formula bar

c) Pressing F2

d) Double clicking the cell

e) None of these

Question : 5

Which menu option can be used to split windows Into two?

a) Format •> Widow

b) View •> Widow=> Split

c) Window->Spilt

d) View->Spilt

e) None of these

Question : 6

To edit in an embedded excel worksheet object in a word document

a) Use the excel menu bar and toolbars inside the word application

b) Edit the hyperlink

c) Edit the data in a excel source application

d) Use the word menu bar and toolbars

e) None of these