MS EXCEL MCQ Multiple Choice Questions Answers - Page 2 | Quiz for Practice
MS EXCEL MCQ Questions for Practice
31. The active cell:
Correct Answer is: It is the formula bar.
32. What is the AutoComplete feature of Excel?
Correct Answer is: It completes text entries that match an existing entry in the same worksheet
33. What does the NOW() function return?
Correct Answer is: It returns the serial number of the current time
34. Long text can be broken down into many lines within a cell. You can do this through
Correct Answer is: None of the above
35. In Excel, by default Numeric Values appears in.
Correct Answer is: Justify aligned
36. What are the tabs that appear at the bottom of each workbook called ?
Correct Answer is: None of the above
37. To record a sequence of keystrokes and mouse actions to play back later we use
Correct Answer is: Calculator
38. A function inside another function is called
Correct Answer is: None of the above
39. Which functionin Excel tells how many numeric entries are there ?
Correct Answer is: CHKNUM
40. Which of the following is not a valid data type in Excel ?
Correct Answer is: None of the above
41. Which setting you must modify to print a worksheet using letterhead?
Correct Answer is: Orientation
42. What type of chart is useful for comparing parts of a whole ?
Correct Answer is: Dot Graph
43. What type of chart is useful for comparing vaues over categories ?
Correct Answer is: Dot Graph
44. What type of chart is useful for showing trends or changes over time ?
Correct Answer is: Dot Graph
45. What do you use to create a chart?
Correct Answer is: Data Wizard
46. Which function is not available in the Consolidate dialog box?
Correct Answer is: Sum
47. Which of the following methods will not enter data in a cell?
Correct Answer is: Clicking the enter button to the formula bar
48. Getting data from a cell located in a different sheet is called
Correct Answer is: None of the above
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: Use the spacebar
50. Text formula:
Correct Answer is: None of the above
51. To return the remainder after a number is divided by a divisor in EXCEL we use the function ?
Correct Answer is: None of the above
52. Which of the following function will return a value of 8?
Correct Answer is: ROUND(8.4999, 0)
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: None of the above
54. What is the correct way to refer the cell A10 on sheet3 from sheet1?
Correct Answer is: A10
55. The Software which contains rows and columns is called
Correct Answer is: None of the above
56. It is a collection of data that is stored electronically as a series of records in a table.
Correct Answer is: MS Word
57. Which area in an Excel window allows entering values and formulas ?
Correct Answer is: None of the above
58. Excel displays the current cell address in the
