MS EXCEL MCQ Quiz - Multiple Choice Questions & Answers Page 4

31. The active cell:

1. is defined by a bold border around the cell.
2. Receives the data the user enters.
3. It is the formula bar.
4. Only A and B.

32. What is the AutoComplete feature of Excel?

1. It automatically completes abbreviated words
2. It completes text entries that match an existing entry in the same column
3. It completes text and numeric entries that match an existing entry in the same column
4. It completes text entries that match an existing entry in the same worksheet

33. What does the NOW() function return?

1. It returns the serial number of the current date and time
2. It returns the serial number of the current date
3. It returns the serial number of the current time
4. None of the above

34. Long text can be broken down into many lines within a cell. You can do this through

1. Justify
2. Wrap Text
3. Conditional Formatting
4. None of the above

35. In Excel, by default Numeric Values appears in.

1. Left aligned
2. Right aligned
3. Center aligned
4. Justify aligned

36. What are the tabs that appear at the bottom of each workbook called ?

1. Location tabs
2. Sheet tabs
3. Reference tabs
4. None of the above

37. To record a sequence of keystrokes and mouse actions to play back later we use

1. Media player
2. Sound Recorder
3. Calculator
4. Macro Recorder

38. A function inside another function is called

1. Nested function
2. Round function
3. Inner function
4. None of the above

39. Which functionin Excel tells how many numeric entries are there ?

1. NUM
2. COUNT
3. SUM
4. CHKNUM

40. Which of the following is not a valid data type in Excel ?

1. Number
2. Character
3. Label
4. None of the above