Microsoft Excel

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])