MS EXCEL Quiz | MS EXCEL Question and Answer for Practice

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

41. Which setting you must modify to print a worksheet using letterhead?

1. Paper
2. Margin
3. Layout
4. Orientation

42. What type of chart is useful for comparing parts of a whole ?

1. Pie Chart
2. Column Chart
3. Line Chart
4. Dot Graph

43. What type of chart is useful for comparing vaues over categories ?

1. Pie Chart
2. Column Chart
3. Line Chart
4. Dot Graph

44. What type of chart is useful for showing trends or changes over time ?

1. Pie Chart
2. Column Chart
3. Line Chart
4. Dot Graph

45. What do you use to create a chart?

1. Pie Wizard
2. Excel Wizard
3. Data Wizard
4. Chart Wizard