NCO- Cyber Olympiad (SOF) Class 11: Questions 584 - 585 of 599
Access detailed explanations (illustrated with images and videos) to 599 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 584
Appeared in Year: 2014
Question
MCQ▾Riya has following data in her worksheet in MS-Excel 2010. She wants to calculate by how much she should increase the rate to get an amount of ₹ 6700 which is calculated by typing a formula in cell B5. Which of the following is the CORRECT way to do so in MS-Excel 2010?
Choices
Choice (4) | Response | |
---|---|---|
a. | Select the cell B5 Formulas tab Calculation group calculation Options Goal Seek Enter the desired value in ‘To Value:’ field Enter the cell reference whose value you want to change in ‘By changing cell’ filed OK | |
b. | Select the cell B5 Data tab Data Tools group What-If Analysis Goal Seek Enter the desired value in ‘To value:’ field Enter the cell reference whose value you want to change in ‘By changing cell’ filed OK | |
c. | Select the cell B5 Formulas tab Calculation group Calculate Now Set the desired value in ‘To value:’ field Enter the cell reference whose value you want to change in ‘By changing cell’ filed OK | |
d. | Select the cell B3 type |
Question 585
Appeared in Year: 2014
Question
Match List-Ⅰ List-Ⅱ▾Match the built-in functions given in Column-I with their respective header files given in Column-II with respect to C ++ .
List-Ⅰ (Column I) | List-Ⅱ (Column II) |
---|---|
(A) fabs () | (i) iostream. h |
(B) getline () | (ii) math. h |
(C) atof () | (iii) stdlib. h |
Choices
Choice (4) | Response | |
---|---|---|
| ||
a. |
| |
b. |
| |
c. |
| |
d. | All of the above |