Computers-MS-Excel (NCO- Cyber Olympiad (SOF) Class 10): Questions 1 - 5 of 6

Access detailed explanations (illustrated with images and videos) to 461 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. 300.00 or

How to register?

Question number: 1

» Computers » MS-Excel

Edit

Appeared in Year: 2011

MCQ▾

Question

Which of these statements on Vlookup () is false?

Choices

Choice (4) Response

a.

The values of the first column must be in descending order.

b.

With this function, the comparison table is always read vertically.

c.

The Vlookup function can be used to compare a value that’s between two values or for an exact value.

d.

When this function is used to find a value between, you must always place the smallest possible value first in the first column.

Question number: 2

» Computers » MS-Excel

Edit
MCQ▾

Question

The Autosum button is present in the ________ tab.

Choices

Choice (4) Response

a.

Home

b.

Insert

c.

Formulas

d.

Data

Question number: 3

» Computers » MS-Excel

Edit
MCQ▾

Question

The range of cells in Column A and rows 1 through 8 would be represented as ________.

Choices

Choice (4) Response

a.

b.

c.

d.

Question does not provide sufficient data or is vague

Question number: 4

» Computers » MS-Excel

Edit
MCQ▾

Question

While working in MS-Excel cell address $A4 in a formula means it is a ________.

Choices

Choice (4) Response

a.

Initial cell reference

b.

Relative cell reference

c.

Absolute cell reference

d.

Mixed cell reference

Question number: 5

» Computers » MS-Excel

Edit

Appeared in Year: 2011

MCQ▾

Question

What tool is used to split the window into different parts of the same worksheet?

Choices

Choice (4) Response

a.

The title bar

b.

The toolbar

c.

The split box

d.

The scroll bar

Developed by: