MS excel set 9 Detailed Explanation And More Example

Question : 1

By default the cell pointer moves down when you press Enter. From where can you change this setting?

a) Tools > > Options » View tab

b) Tools » Options » Calculation tab

c) Tools » Options » Edit tab

d) Tools » Options » Transition tab

e) None of these

Question : 2

When a row of data is to be converted into columns

a) Copy the cells in row, select the same number of cells in row and paste

b) Copy the cells in column then choose Edit > > Paste Special, then click Transpose and OK

c) Copy the cells then go to Format > > Cells then on Alignment tab click Transpose check box and click OK

d) Select the cells then place the cell pointer on new cell and choose Edit » Paste Special, mark Transpose check box and click OK.

e) None of these

Question : 3

To edit data 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

Question : 4

Excel is a

a) Graphic program

b) A spreadsheet

c) Word processor

d) All of Above

e) None of these

Question : 5

To delete an incorrect character in a document, __ to erase to the right of the insertion point.

a) press the left mouse key

b) double click the right mouse key

c) press the BACKSPACE key

d) press DELETE key

e) None of these

Question : 6

On an Excel sheet the active cell in indicated by

a) A dark wide border

b) A dotted border

c) A blinking border

d) All of above

e) None of these