ComputersMSExcel (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 exampattern 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 » MSExcel
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 » MSExcel
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 » MSExcel
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 » MSExcel
Question
While working in MSExcel 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 » MSExcel
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 
