Computer-MS-Excel (NCO- Cyber Olympiad (SOF) Class 12): Questions 1 - 6 of 27
Access detailed explanations (illustrated with images and videos) to 520 questions. Access all new questions we will add tracking exam-pattern and syllabus changes. Subscription can be renewed yearly absolutely FREE! View Sample Explanation or View Features.
Rs. 350.00 or
How to register?
Question number: 1
» Computer » MS-Excel
Question
What would be the output of the given function in MS-Excel 2010?
Choices
| Choice (4) | Response | |
|---|---|---|
| a. | 80 |
|
| b. | 72 |
|
| c. | 70 |
|
| d. | 64 |
|
Question number: 2
» Computer » MS-Excel
Question
What Term Describes Explanatory Text Attached to a cell?
Choices
| Choice (4) | Response | |
|---|---|---|
| a. | Context |
|
| b. | Comment |
|
| c. | Dialog |
|
| d. | Callout |
|
Question number: 3
» Computer » MS-Excel
Question
Which of the following function used to perform a vertical look up in the left column and return a value in the same row from a column?
Choices
| Choice (4) | Response | |
|---|---|---|
| a. | RAND () |
|
| b. | LEN () |
|
| c. | VLOOKUP () |
|
| d. | MEDIAN () |
|
Question number: 4
» Computer » MS-Excel
Question
Which of the following statement is CORRECT about embedded charts in MS-Excel 2010?
Choices
| Choice (4) | Response | |
|---|---|---|
| a. | You can move an embedded chart to another workbook only by “Cut” and “Paste” options. |
|
| b. | It does not allow you to resize a chart. |
|
| c. | If you paste an embedded chart in another workbook, it will be linked to the data in the original workbook. |
|
| d. | Both a. and c. are correct |
|
Question number: 5
» Computer » MS-Excel
Question
Which key is used to Drag a Selected Range of Data to Another Worksheet in the same Workbook?
Choices
| Choice (4) | Response | |
|---|---|---|
| a. | Ctrl |
|
| b. | Tab |
|
| c. | Alt |
|
| d. | Shift |
|
Question number: 6
» Computer » MS-Excel
Question
Which of the following Options is used to Delete the Duplicate Entry from the Selected cell Range in MS-Excel 2010?
Choices
| Choice (4) | Response | |
|---|---|---|
| a. |  Delete the Duplicate Entry from the Selected Cell – Choice A This icon shows to delete the duplicate entry from the selected cell |
|
| b. |  Delete the Duplicate Entry from the Selected Cell – Choice B This icon shows to delete the duplicate entry from the selected cell |
|
| c. |  Delete the Duplicate Entry from the Selected Cell – Choice C This icon shows to delete the duplicate entry from the selected cell |
|
| d. |  Delete the Duplicate Entry from the Selected Cell – Choice D This icon shows to delete the duplicate entry from the selected cell |
|