[1] What is Android? It is an open-sourced operating system that is used primarily on mobile devices, such as cell phones and tablets. It is a Linux kernel-based system that s been equipped with rich components that allows developers to create and run apps that can perform both basic and advanced functions. [2] What Is […]
Top Interview Questions for Software Engineer
Top Interview Questions that Software Engineer (.NET) Candidates Need to Know. [1] What is .NET Framework? Dot NET Framework is a complete environment that allows developers to develop, run, and deploy the following applications: Console applications Windows Forms applications Windows Presentation Foundation (WPF) applications Web applications (ASP.NET applications) Web services Windows services Service-oriented applications using […]
Difference Between Mysql and MS SQL?
SQL is an acronym for Structured Query Language. It is used to access, manipulate and retrieve information from a database.MySQL is an open source Relational Database Management System (RDBMS) based on Structured Query Language (SQL). It runs on platforms like Linux, UNIX and Windows.SQL Server is owned and developed by Microsoft Corporation. The primary function […]
COUNT, COUNTIF & COUNTIFS Function
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 […]