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 we will add tracking exam-pattern and syllabus changes. Unlimited Access for Unlimited Time!
View Sample Explanation or View Features.
Rs. 350.00 or
How to register?
Question number: 584
Appeared in Year: 2014
Question
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 Rs. 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?
Image Shows Data in Worksheet in MS-Excel
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 number: 585
» Computer » Introduction of C++ Till Data Structure
Appeared in Year: 2014
Question
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 | |