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

» Computer » MS-Excel

Edit

Appeared in Year: 2014

MCQ▾

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

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

Edit

Appeared in Year: 2014

Match List-Ⅰ List-Ⅱ▾

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)

a.

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

b.

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

c.

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

d.

All of the above

Developed by: