MS EXCEL MCQ Questions and Answers Quiz

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
Tags

MCQ Multiple Choice Questions and Answers on MS EXCEL

MS EXCEL Question and Answer