When are they used: COUNT :- To count the number of cells that contain numbers, use the COUNT function. COUNTIF :- To count cells based on one criteria (for example, less than 150), use the following COUNTIF function. COUNTIFS :- To count cells based on multiple criteria (for example, R Madrid and greater than 30), use the following […]
AVERAGE , AVERAGEIF & AVERAGEIFS Functions
When are they used: AVERAGE :- You use the AVERAGE function in Excel to return the average (arithmetic mean) of the specified cells. Example 1. Calculating an average of numbers To find out an average of certain numbers, you can supply them directly in your Excel average formula.For example, =AVERAGE(1,3,4) returns 2.67 as the result. AVERAGEIF :- The classical […]
SUM, SUMIF & SUMIFS Functions
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 […]