Bissoy.com
Doctors Medicines MCQs Q&A

In MS Excel, what is function inside another function called? A. Round Function B. Sandwich function C. Switch function D. Nested function 

In MS Excel, what is function inside another function called? A. Round Function B. Sandwich function C. Switch function D. Nested function  Correct Answer D

Option 3 is the correct answer: A function inside a function is called a Nested function.

Function

Definition

Round Function

This function rounds a number to a specified number of digits.

Switch Function

It returns a value (if matched), after matching it with other values in the list.

Nested Function

A function tucked inside a function

Related Questions

Which of the following statements are true? (a) The sandwich pattern of training for IPS probationers was introduced in 1986. (b) The sandwich pattern of training for IPS probationers was introduced on the recommendations of the Administrative Reforms Commission (ARC). (c) The sandwich pattern of training for IPS probationers was introduced in 1969. (d) The sandwich pattern of training for IPS probationers was introduced on the recommendations of the National Police Commission.
You need to allow one host to be permitted to attach dynamically to each switch interface. Which two commands must you configure on your catalyst switch to meet this policy?
1. Switch (config-if) # ip access-group 10
2. Switch (config-if) # switchport port-security maximum 1
3. Switch (config) # access-list 10 permit ip host 1
4. Switch (config-if) # switchport port-security violation shutdown
5. Switch (config) # mac-address-table secure
Consider four processes P, Q, R, and S scheduled on a CPU as per round-robin algorithm with a time quantum of 4 units. The processes arrive in the order P, Q, R, S, all at time t = 0. There is exactly one context switch from S to Q, exactly one context switch from R to Q, and exactly two context switches from Q to R. There is no context switch from S to P. Switching to a ready process after the termination of another process is also considered a context switch. Which one of the following is NOT possible as CPU burst time (in time units) of these processes?  
In a certain code language, bed is called stool, stool is called peacock, peacock is called sandwich, sandwich is called spoon and spoon is called rope. In this language, which of the following is a bird?
In a beauty competition, 2/5 of the participants were eliminated in the first round. 2/3 of the remaining participants qualified from the second to the third round and half of the participants of the third round got into the final round. In the final round, 2/3 of the remaining participants lost the competition, while two of them won the competition. How many participants were there in the competition?
Read the given information and answer the question asked by choosing the most appropriate option. There are 45 members in a team. Among them, 13 are having both sandwich and momos. A total of 21 members are having sandwich. If every member is having at least one food item, how many members are having momos in total?
For the circuit as shown, consider that switch S1 has been in position B for a very long time and switch S2 has been open all the time. At time t = 0, the switch S1 moves to position A and switch S2 closes instantaneously. What is the value of Vout of t = 0+, assuming initial charge on C = 0?
Which of the following types of connections can use full duplex?
1. Hub to hub
2. Switch to switch
3. Host to host
4. Switch to hub
5. Switch to host
Let processes are scheduled on a system using round robin scheduling; assume that there is only one process of r time units. Round robin time quantum is q time units and process switch time is s time units. If s < q < r, then process switch over head units are
Study the following information to answer the questions given below: A company wants to hire young professionals where students of any graduate stream can participate in the drive. But company put some eligibility criteria. There are two rounds, round one consist of aptitude test and 2nd round is personal interview. 1) Student having no backlogs is eligible to participate in the drive. 2) Student must have at least 68 percentages in 10th and 12th. 3) Student having greater than 85 percentages in graduation without any backlogs are eligible for direct interview round. If the 1st or 2nd criteria not fulfilled then, 1) If a candidate has a work experience of 1 year in any field he is eligible to appear in aptitude round. But if the candidate has not clear his backlogs he is not eligible to participate in the drive. Amit a commerce student has a score of 69 percentages in 10th and 12th. He is currently working in an IT company for 15 months. In graduation he scored only 65 percentages and also clears his backlogs.