MS excel set 3 Detailed Explanation And More Example

Question : 1

Which command will you choose to convert a column of data into row?

a) Cut and Paste

b) Edit » Paste Special » Transpose

c) Both of above

d) Press F7

e) None of these

Question : 2

Which of the cell pointer indicate that you can move the content to other cell?

a) Doctor's symbol (Big Plus)

b) small thin plus icon

c) Mouse Pointer with anchor at the tip

d) All of above

e) None of these

Question : 3

In Excel how do you insert a row?

a) Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu

b) Select the row heading where you want to insert the new row and select Edit >Row from the menu

c) Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar

d) All of the above

Question : 4

The box on the chart that contains the name of each Individual record Is called the__.

a) cell

b) title

c) axis

d) legend

e) None of these

Question : 5

The cell reference from a range of cells that starts in cell Bl and goes over to column G and down to row lOis......

a) DB1-G10

b) B1.G10

c) B1;G10

d) B1:G10

e) None of these

Question : 6

The short cut key Ctrl +R is used in Excel to

a) Right align the content of cell

b) Remove the cell contents of selected cells

c) Fill the selection with active t cells to the right

d) All of above

e) None of these