MS Excel Questions and Answers Online test: Microsoft Excel may be a spreadsheet software and is a component of the widely used MS Office Package. Here you’ll find an excellent collection of Multiple Choice (MCQs) Questions within the category of Microsoft Excel with answers. Most of the questions are applicable to all or any versions of MS Excel (including Excel 97-2003, XP, 2007, 2010, etc.). Sometimes questions from this category are asked as a part of the pc operation public knowledge section of basic computer awareness test.
MS Excel MCQ Question with Answer
Here you’ll find an inventory of common important questions on Microsoft excel in MCQ quiz style with answers for competitive exams and interviews. These commonly asked sample questions on MS Excel are given with the right choice of answer that you simply can check instantly.
Presently we’ve added a complete of 5 sets of questions on Microsoft excel for you to practice. We’ll keep adding more questions and supply this question bank in PDF format in order that you’ll download them instantly within the E-book style.
Here is that the list of most vital MS Excel Mcqs for the preparation of tests like computer operator, data entry operator in NTS, KPPSC, FPSC, PPSC. Here we present MS Office MCQ Question and this post contains multiple-choice questions for Microsoft Excel. These are the primary 100 Mcqs of this series. A replacement MCQ Questions assail the category of Microsoft Excel. Here during this set, .Select your answer first then ask the given correct answer. Correct answers to those questions are given at the top of this question set. Below may be a few MS Excel MCQ test that checks your basic knowledge of MS Excel. This MS Excel Test contains around 100 questions of multiple choice with 4 options. You’ve got to pick the proper answer to an issue. You’ll see the right answer by clicking the view answer.
Microsoft Excel MCQS Microsoft Excel 2007, Microsoft Excel 2009 MCQS, Microsoft Excel 2013 MCQS Microsoft Excel 2016 MCQS, Microsoft Excel 2017 MCQs. All MS Excel MCQS, MS Excel Design, MS Excel Page layout MCQS, MS Excel Best MCQS, MS Excel Online MCQS MS Excel Pages, MS Excel toolbar MCQs, MS Excel Formulas MCQS, MS Excel shortcuts MCQs, MS Excel Spreadsheet MCQs, best spreadsheet MCQs online, MCQs about excel formulas. Better of Microsoft Excel MCQs for FPSC exams preparation BPSC exams preparation PPSC exams preparation SPSC exams preparation KPPSC exams preparation NTS tests preparation OTS tests preparation CTS tests preparation PTS, BTS, CTSP tests preparation
The following section consists of some important multiple-choice questions (MCQs) on Microsoft excel with answers
Quiz-summary
0 of 98 questions completed
Questions:
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
- 53
- 54
- 55
- 56
- 57
- 58
- 59
- 60
- 61
- 62
- 63
- 64
- 65
- 66
- 67
- 68
- 69
- 70
- 71
- 72
- 73
- 74
- 75
- 76
- 77
- 78
- 79
- 80
- 81
- 82
- 83
- 84
- 85
- 86
- 87
- 88
- 89
- 90
- 91
- 92
- 93
- 94
- 95
- 96
- 97
- 98
Information
Excel
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading...
You must sign in or sign up to start the quiz.
You have to finish following quiz, to start this quiz:
Results
0 of 98 questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 points, (0)
Average score |
|
Your score |
|
Categories
- m.s excel 0%
-
Best of luck>>>>>>>>>>>>>
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
- 53
- 54
- 55
- 56
- 57
- 58
- 59
- 60
- 61
- 62
- 63
- 64
- 65
- 66
- 67
- 68
- 69
- 70
- 71
- 72
- 73
- 74
- 75
- 76
- 77
- 78
- 79
- 80
- 81
- 82
- 83
- 84
- 85
- 86
- 87
- 88
- 89
- 90
- 91
- 92
- 93
- 94
- 95
- 96
- 97
- 98
- Answered
- Review
-
Question 1 of 98
1. Question
5 pointsIn Microsoft Excel, which of the following methods cannot be used to enter data in a cell.
Correct
Incorrect
-
Question 2 of 98
2. Question
5 pointsWhich of the following will not cut information?
Correct
Incorrect
-
Question 3 of 98
3. Question
5 pointsWhich of the following os not a way to complete a cell entry?
Correct
Incorrect
-
Question 4 of 98
4. Question
5 pointsyou can activate a cell by
Correct
Incorrect
-
Question 5 of 98
5. Question
5 pointsText formulas
Correct
Incorrect
-
Question 6 of 98
6. Question
5 pointsHow do you insert a row?
Correct
Incorrect
-
Question 7 of 98
7. Question
5 pointswhich of the following is not a basic step in creating a worksheet ?
Correct
Incorrect
-
Question 8 of 98
8. Question
5 pointsHow do you select an entire column?
Correct
Incorrect
-
Question 9 of 98
9. Question
5 pointsHow can you print three copies of a workbook ?
Correct
Incorrect
-
Question 10 of 98
10. Question
5 pointsTo create a formula, you first :
Correct
Incorrect
-
Question 11 of 98
11. Question
5 pointsto center worksheet titles across a range of cells, you must
Correct
Incorrect
-
Question 12 of 98
12. Question
5 pointshow do you delete a column?
Correct
Incorrect
-
Question 13 of 98
13. Question
5 pointsHow can you find specific information in a list?
Correct
Incorrect
-
Question 14 of 98
14. Question
5 pointsWhen integrating word and excel, word is usually the
Correct
Incorrect
-
Question 15 of 98
15. Question
5 pointsWhen a label is too long to fit within a worksheet cell, you typically must
Correct
Incorrect
-
Question 16 of 98
16. Question
5 pointsThe name box
Correct
Incorrect
-
Question 17 of 98
17. Question
5 pointsComments put in cells are called
Correct
Incorrect
-
Question 18 of 98
18. Question
5 pointsWhich is used to perform what if analysis?
Correct
Incorrect
-
Question 19 of 98
19. Question
5 pointsYou can use the horizontal and vertical scroll bars to
Correct
Incorrect
-
Question 20 of 98
20. Question
5 pointsMultiple calculation can be made in a single formula using
Correct
Incorrect
-
Question 21 of 98
21. Question
5 pointshyperlink can be
Correct
Incorrect
-
Question 22 of 98
22. Question
5 pointsTo activate the previous cell in a pre-selected range, press
Correct
Incorrect
-
Question 23 of 98
23. Question
5 pointsWhich button do you click to add up a series of numbers?
Correct
Incorrect
-
Question 24 of 98
24. Question
5 pointsWhen the formula bar is active, you can see
Correct
Incorrect
-
Question 25 of 98
25. Question
1 pointsto copy formatting from one area in worksheet and apply it to another area you would use
Correct
Incorrect
-
Question 26 of 98
26. Question
5 pointsIn a worksheet you can select
Correct
Incorrect
-
Question 27 of 98
27. Question
5 pointsWhen you link data maintained in an excel workbook to a word document
Correct
Incorrect
-
Question 28 of 98
28. Question
5 pointsWhich area in an excel window allows entering values and formulas
Correct
Incorrect
-
Question 29 of 98
29. Question
5 pointsTo hold row and column titles in place so that they do not scroll when you scroll a worksheet click the
Correct
Incorrect
-
Question 30 of 98
30. Question
5 pointsTo edit in an embedded excel work sheet object in a word document
Correct
Incorrect
-
Question 31 of 98
31. Question
5 pointsTo create a formula, you can use:
Correct
Incorrect
-
Question 32 of 98
32. Question
5 pointsStatus indicators are located on the
Correct
Incorrect
-
Question 33 of 98
33. Question
5 pointsWhich of the following is the oldest spreadsheet package?
Correct
Incorrect
-
Question 34 of 98
34. Question
5 pointsRounding errors can occur
Correct
Incorrect
-
Question 35 of 98
35. Question
5 pointsYou can copy data or formulas
Correct
Incorrect
-
Question 36 of 98
36. Question
5 pointsyou cannot link excel worksheet data to a word document
Correct
Incorrect
-
Question 37 of 98
37. Question
5 pointsWhich of the following is a popular DOS based spreadsheet package?
Correct
Incorrect
-
Question 38 of 98
38. Question
5 pointsAn excel wordbook is a collection of
Correct
Incorrect
-
Question 39 of 98
39. Question
5 pointsExcel files have a default extension of
Correct
Incorrect
-
Question 40 of 98
40. Question
5 pointsyou can use the format painter multiple times before you turn it off by
Correct
Incorrect
-
Question 41 of 98
41. Question
5 pointsYou can use the formula palette to
Correct
Incorrect
-
Question 42 of 98
42. Question
5 pointsYou can convert existing excel worksheet data an charts to an HTML document by using
Correct
Incorrect
-
Question 43 of 98
43. Question
5 pointsA circular reference is
Correct
Incorrect
-
Question 44 of 98
44. Question
5 pointsWhich of following in Not one of Excel’s what-if functions ?
Correct
Incorrect
-
Question 45 of 98
45. Question
5 pointsWhen you insert an excel file into a word document. The data are
Correct
Incorrect
-
Question 46 of 98
46. Question
5 pointsWhich of the following is not information you can specify using the solver ?
Correct
Incorrect
-
Question 47 of 98
47. Question
5 pointseach excel file is called a workbook because
Correct
Incorrect
-
Question 48 of 98
48. Question
5 pointsexcel probably considers the cell entry January 1,2000 to be a
Correct
Incorrect
-
Question 49 of 98
49. Question
5 pointsYou can enter which types of data into worksheet cells?
Correct
Incorrect
-
Question 50 of 98
50. Question
5 pointsAll worksheet formula
Correct
Incorrect
-
Question 51 of 98
51. Question
5 pointsWhich of the following is a correct order of precedence in formula calculation ?
Correct
Incorrect
-
Question 52 of 98
52. Question
5 pointsThe paste Special command lets you copy and paste:
Correct
Incorrect
-
Question 53 of 98
53. Question
5 pointsThe numbers in our worksheet look like this. You want them to look like this: $1,000. How can you accomplish this?
Correct
Incorrect
-
Question 54 of 98
54. Question
5 pointsWhich of the following is not a valid data type in excel ?
Correct
Incorrect
-
Question 55 of 98
55. Question
5 pointsExcel worksheet cells work very similarly to what common element of the windows graphical user interface
Correct
Incorrect
-
Question 56 of 98
56. Question
5 pointsWhich of the following options is not located in the Page Setup dialog box?
Correct
Incorrect
-
Question 57 of 98
57. Question
5 pointsYou want to track the progress of the stock market on a daily basis. Which type of chart should you use?
Correct
Incorrect
-
Question 58 of 98
58. Question
5 pointsWithout using the mouse or the arrow keys what is the fastest way of getting to cell Al in a spreadsheet?
Correct
Incorrect
-
Question 59 of 98
59. Question
5 pointsWhich of the following methods cannot be used to edit the contents of a cell ?
Correct
Incorrect
-
Question 60 of 98
60. Question
5 pointsif you begin typing an entry into a cell and then realize that you don’t want your entry placed into a cell, you:
Correct
Incorrect
-
Question 61 of 98
61. Question
5 pointsto view a cell comment
Correct
Incorrect
-
Question 62 of 98
62. Question
5 pointsWhen you wnat to insert a blank imbedded excel object in a word document you can
Correct
Incorrect
-
Question 63 of 98
63. Question
5 pointsTo save a workbook, you
Correct
Incorrect
-
Question 64 of 98
64. Question
5 pointsyou can edit a cell by
Correct
Incorrect
-
Question 65 of 98
65. Question
5 pointsyou can select a single range of cells by
Correct
Incorrect
-
Question 66 of 98
66. Question
5 pointswhich elements of worksheet can be protected from accidental modification ?
Correct
Incorrect
-
Question 67 of 98
67. Question
5 pointsyou can use the drag and drop methods to
Correct
Incorrect
-
Question 68 of 98
68. Question
5 pointsIt is acceptable to let long text flow into adjacent cells on a worksheet when
Correct
Incorrect
-
Question 69 of 98
69. Question
5 pointsHow can you delete a record ?
Correct
Incorrect
-
Question 70 of 98
70. Question
5 pointsRight clicking something in Excel
Correct
Incorrect
-
Question 71 of 98
71. Question
5 pointsDocumentation should include
Correct
Incorrect
-
Question 72 of 98
72. Question
5 pointsFiles created with Lotus 1-2-3 have an extension
Correct
Incorrect
-
Question 73 of 98
73. Question
5 pointsTo delete an embedded objects, first
Correct
Incorrect
-
Question 74 of 98
74. Question
5 pointscomments can be added to cells using
Correct
Incorrect
-
Question 75 of 98
75. Question
5 pointsWhich of the following is not a worksheet design criterion?
Correct
Incorrect
-
Question 76 of 98
76. Question
5 pointsTo copy cell contents using drag and drop press the
Correct
Incorrect
-
Question 77 of 98
77. Question
5 pointswhich of the following is the largest version of Excel ?
Correct
Incorrect
-
Question 78 of 98
78. Question
5 pointsWhen you copy a formula
Correct
Incorrect
-
Question 79 of 98
79. Question
5 pointsThe auto fill feature
Correct
Incorrect
-
Question 80 of 98
80. Question
5 pointswhich menu option can be sued to split windows into two ?
Correct
Incorrect
-
Question 81 of 98
81. Question
5 pointsExcel uniquely identifies cells within a worksheet with a cell name
Correct
Incorrect
-
Question 82 of 98
82. Question
5 pointsWhat symbol is used before a number to make it a label ?
Correct
Incorrect
-
Question 83 of 98
83. Question
5 pointsThe auto calculate feature
Correct
Incorrect
-
Question 84 of 98
84. Question
5 pointsWhich of the following formulas is entered correctly?
Correct
Incorrect
-
Question 85 of 98
85. Question
5 pointsWhich of the following formulas will Excel Not be able to calculate?
Correct
Incorrect
-
Question 86 of 98
86. Question
5 pointsA typical worksheet has……Number of columns
Correct
Incorrect
-
Question 87 of 98
87. Question
5 pointsHow many character can be typed in a angle cell in Excel ?
Correct
Incorrect
-
Question 88 of 98
88. Question
5 pointsA worksheet can have a maximum or Number of rows ?
Correct
Incorrect
-
Question 89 of 98
89. Question
5 pointsWhich of the following is not an example of a value ?
Correct
Incorrect
-
Question 90 of 98
90. Question
5 pointsThe chart wizard term data series refers to
Correct
Incorrect
-
Question 91 of 98
91. Question
5 pointsThe chard wizard term data categories refer to ;
Correct
Incorrect
-
Question 92 of 98
92. Question
5 pointsA worksheet range is a
Correct
Incorrect
-
Question 93 of 98
93. Question
5 pointsGetting data from a cell located in different sheet is called
Correct
Incorrect
-
Question 94 of 98
94. Question
5 pointsTab scrolling button
Correct
Incorrect
-
Question 95 of 98
95. Question
5 pointsA numeric value can be treated as a label value if it precedes with
Correct
Incorrect
-
Question 96 of 98
96. Question
5 pointsconcatenation of text can be done using
Correct
Incorrect
-
Question 97 of 98
97. Question
5 pointsData can be arranged in a worksheet in a easy to understand manner using
Correct
Incorrect
-
Question 98 of 98
98. Question
5 pointsYou can use drag and drop to embed excel worksheet data in word document
Correct
Incorrect