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 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.


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)



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


  • Remarks


  • Grade


  • Hlookup


Be the first to reply

Leave a Reply

Your email address will not be published.