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

Edit
MCQ▾

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

Edit
MCQ▾

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

Edit
MCQ▾

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

Edit
MCQ▾

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

Edit
MCQ▾

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

Edit
MCQ▾

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

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

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

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

Delete the Duplicate Entry from the Selected Cell – Choice D

This icon shows to delete the duplicate entry from the selected cell

Developed by: