microsoft excel q/a Practice Questions Answers Test with Solutions & More Shortcuts

Question : 6

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

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

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

Concatenation of text can be done using

a) Apostrophe (')

b) Exclamation (!)

c) Hash(#)

d) Ampersand (&)

e) None of these

Question : 10

How do you delete a column?

a) Select the column heading you want to delete and select the Delete Row button on the standard toolbar

b) Select the column heading you want to delete and select Insert Delete from the menu

c) Select the row heading you want to delete "and select Edit>Delete from the menu

d) Right click the column heading you want to delete and select delete from .the shortcut menu

e) None of these