MS excel set 9 Detailed Explanation And More Example

Question : 1

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

Question : 2

In Excel to copy cell contents using drag and drop, press the

a) End key

b) Shift key

c) Esc key

d) None of above

Question : 3

An excel workbook is a collection of

a) Workbooks

b) Worksheets

c) Charts

d) Worksheets and charts

e) None of these

Question : 4

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 : 5

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 : 6

Except for the .......function, a formula with a logical function shows the word "TRUE" or "FALSE" as a result

a) IF

b) AND

c) OR

d) NOT

e) None of these