When are they used: SUM :- allows for the summation of a specific number of cells, both adjacent and non-adjacent. SUMIF :- allows for the summation of a range of cells that meet a specific criterion. SUMIFS :- allows for the summation of a range of cells that meet a number of different criteria.
Latest Dot Net Interview Questions and Answers
[1] What is the managed and unmanaged code in .net? The .NET Framework provides a run-time environment called the Common Language Runtime, which manages the execution of code and provides services that make the development process easier. Compilers and tools expose the runtime s functionality and enable you to write code that benefits from this […]
Linux Basics Interview Questions and Answers
[1] What is the alternative method to a GUI installation in Linux ? Linux provides text base installation as the alternative method of GUI installation. [2] What is the purpose of the swapon command ? Swapon command is used to activate a already created swap partition. It cannot be used to create a new swap […]
How to detect Android Back button press.
Detecting android device hardware back button / soft back button press is very easy. But be careful while overriding the default back button action as it is not suggested to change the android default user experience. Method:- 1 Override the onBackPressed() method and take the action inside this function.
Android How to Capitalize Every First letter of a Word in EditText
If you want to capitalise the first letter of every word in a EditText, assign android:inputType=”textCapWords” to EditText. Example: The same can be done programmatically also as shown below.
