MS excel set 3 Detailed Explanation And More Example

Question : 1

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

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

Concatenation of text can be done using

a) Apostrophe (')

b) Exclamation (!)

c) Hash(#)

d) Ampersand (&)

e) None of these

Question : 4

Which of the following is invalid regarding the Protection in Excel?

a) Protect Sheet

b) Protect Workbook

c) Protect Workspace

d) All of above are valid

e) None of these

Question : 5

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

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