MS EXCEL Multiple Choice Questions and Answers

21. What is the shortcut key to insert a new comment in a cell ?

1. Ctrl + F2
2. Shift + F2
3. None of the above
4. 3

22. Functions in MS Excel must begin with…………………………………

1. An Equal Sign
2. A Plus Sign
3. A > Sign
4. 2

23. What happens when dollar signs ($) are entered in a cell address? (ex. $B$2:$B$10)

1. Cell address will change when it is copied to another cell.
2. The sheet tab is changed.
3. The status bar does not display the cell address.
4. 1

24. A numeric value can be treated as label value if …… precedes it.

1. Exclamation (!)
2. Hash (#)
3. Tilde (~)
4. 1

25. Concatenation of text can be done using

1. Exclamation (!)
2. Hash (#)
3. Ampersand (&)
4. 4

26. The name box

1. Appears to the left of the formula bar
2. Shows the location of the previously active cell
3. None of the above
4. 2

27. Which Chart can be created in Excel?

1. Line
2. Pie
3. All of the above
4. 4

28. The Greater Than sign is an example of …………………….. operator.

1. Logical
2. Conditional
3. Greater
4. 2

29. NOT, AND, OR and XOR are

1. Relational operators
2. Logical Operators
3. None of the above
4. 3

30. The process of arrenging the items of a column in some sequence or order is known as :

1. Autofill
2. Sorting
3. Filtering
4. 3