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?

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

a.

  • (i)
  • (iii)
  • (ii)

b.

  • (ii)
  • (i)
  • (iii)

c.

  • (ii)
  • (iii)
  • (i)

d.

All of the above