MS EXCEL MCQ Multiple Choice Questions Answers - Page 2 for Practice
31. The active cell:
Correct Answer is: Only A and B.
32. What is the AutoComplete feature of Excel?
Correct Answer is: It completes text entries that match an existing entry in the same column
33. What does the NOW() function return?
Correct Answer is: None of the above
34. Long text can be broken down into many lines within a cell. You can do this through
Correct Answer is: Wrap Text
35. In Excel, by default Numeric Values appears in.
Correct Answer is: Right aligned
36. What are the tabs that appear at the bottom of each workbook called ?
Correct Answer is: Sheet tabs
37. To record a sequence of keystrokes and mouse actions to play back later we use
Correct Answer is: Macro Recorder
38. A function inside another function is called
Correct Answer is: Nested function
39. Which functionin Excel tells how many numeric entries are there ?
Correct Answer is: COUNT
40. Which of the following is not a valid data type in Excel ?
Correct Answer is: Character
41. Which setting you must modify to print a worksheet using letterhead?
Correct Answer is: Margin
42. What type of chart is useful for comparing parts of a whole ?
Correct Answer is: Pie Chart
43. What type of chart is useful for comparing vaues over categories ?
Correct Answer is: Column Chart
44. What type of chart is useful for showing trends or changes over time ?
Correct Answer is: Line Chart
45. What do you use to create a chart?
Correct Answer is: Chart Wizard
46. Which function is not available in the Consolidate dialog box?
Correct Answer is: Pmt
47. Which of the following methods will not enter data in a cell?
Correct Answer is: Pressing the Esc key
48. Getting data from a cell located in a different sheet is called
Correct Answer is: Referencing
49. If you want to have a blank line after the title in a worksheet, what is the best thing for you to do?
Correct Answer is: Insert a row
50. Text formula:
Correct Answer is: Concatenate and manipulate text
51. To return the remainder after a number is divided by a divisor in EXCEL we use the function ?
Correct Answer is: MOD ( )
52. Which of the following function will return a value of 8?
Correct Answer is: Only B and C
53. You are editing a worksheet that you had previously saved. If you want to save the edited sheet without losing the original one, which command should you use ?
Correct Answer is: Save
54. What is the correct way to refer the cell A10 on sheet3 from sheet1?
Correct Answer is: sheet3!A10
55. The Software which contains rows and columns is called
Correct Answer is: Spreadsheet
56. It is a collection of data that is stored electronically as a series of records in a table.
Correct Answer is: database
57. Which area in an Excel window allows entering values and formulas ?
Correct Answer is: Formula Bar
58. Excel displays the current cell address in the
