### What is Microsoft Excel ?

Ans :- Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation or computation capabilities, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. Excel forms part of the Microsoft Office suite of software.

### What is Column

Ans :- Columns are denoted and identified by a unique alphabetical header letter, which is located at the top of the worksheet. Column headers range from A-XFD, as Excel spreadsheets can have 10,48,576 columns in total. Columns run vertically in the worksheet, and the data goes from up to down.

### What is Row

Ans :- A row is a series of data placed out horizontally in a table or spreadsheet. It is a horizontal arrangement of the objects, words, numbers, and data. In Row, data objects are arranged face-to-face with lying next to each other on the straight line.

### What is Cell

Ans :- Cells are the boxes you see in the grid of an Excel worksheet, like this one. Each cell is identified on a worksheet by its reference, the column letter and row number that intersect at the cell’s location. This cell is in column D and row 5, so it is cell D5. The column always comes first in a cell reference.

**Column + Row = Cell**

### Formula

Formula is an expression that operates on values in a range of cells. These formulas return a result, even when it is an error. Excel formulas enable you to perform calculations such as addition, subtraction, multiplication, and division. **Simple Calcution + Limited data.**

### Function

Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order, or structure. Functions can be used to perform simple or complex calculations. You can find all of Excel’s functions on the Formulas tab on the Ribbon: Excel function syntax. **Complex calculation + Large data.**

### Basic function with Syntex

- Sum

=Sum(numbar 1,numbar 2,numbar 3)

=Sumif(rang,criteria,[sum_rang])

=Sumifs(sum_rang,rang,criteria_rang,sum_rang,criteria)

- Average

=Average(numbar 1,numbar 2,numbar 3)

- Maximum

=Max(numbar 1,numbar 2,numbar 3)

- Minimum

=Min(numbar 1,numbar 2,numbar 3)

- Counts

=Count(numbar 1,numbar 2,numbar 3)

=countif(rang,criteria)

- Remarks

=If(logical_text,[value_if_true],[value_if_fals])

- Grade

=VLOOKUP(lookup_value,table_array,col_index_num,[range_lookup])

- Hlookup

=Hlookup(lookup_value,table_array,row_index_num,[range_lookup])

## Be the first to reply