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(numbar 1,numbar 2,numbar 3)
=Average(numbar 1,numbar 2,numbar 3)
=Max(numbar 1,numbar 2,numbar 3)
=Min(numbar 1,numbar 2,numbar 3)
=Count(numbar 1,numbar 2,numbar 3)
Be the first to reply