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- tracking exam pattern and syllabus. View the complete topic-wise distribution of questions. Unlimited Access, Unlimited Time, on Unlimited Devices!

View Sample Explanation or View Features.

Rs. 350.00 -OR-

How to register? Already Subscribed?

Question 1

MS-Excel

Question

MCQ▾

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 2

MS-Excel

Question

MCQ▾

What Term Describes Explanatory Text Attached to a cell?

Choices

Choice (4)Response

a.

Context

b.

Comment

c.

Dialog

d.

Callout

Question 3

MS-Excel

Question

MCQ▾

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 4

MS-Excel

Question

MCQ▾

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 5

MS-Excel

Question

MCQ▾

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 6

MS-Excel

Question

MCQ▾

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

Developed by: