# 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. *Unlimited Access for Unlimited Time*!

View Sample Explanation or View Features.

Rs. 300.00 or

How to register?

## Question number: 1

» Computers » MS-Excel

Appeared in Year: 2011

### 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

### 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

### 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

### 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

Appeared in Year: 2011

### 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 |