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. Unlimited Access for Unlimited Time!
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 | |
b. |  Delete the Duplicate Entry from the Selected Cell – Choice B | |
c. |  Delete the Duplicate Entry from the Selected Cell – Choice C | |
d. |  Delete the Duplicate Entry from the Selected Cell – Choice D | |