The entire spreadsheet is composed of rows and columns of cells.Ĭell Reference: A cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate. The data is usually text, a numeric value, or a formula. You can freeze the column letter and/or row number when needed.ĬONCATENATE Function : The CONCATENATE function in Excel is designed to join different pieces of text together or combine values from several cells into one cell.Ĭell: In spreadsheet applications, a cell is a box in which you can enter a single piece of data. A $ before a column letter freezes the column, while a $ before the row number freezes the row number. Absolute references are represented by $ symbols. AVERAGE : Returns the average (arithmetic mean) of the arguments.Ībsolute Reference : Absolute references in Excel are a direct link to a specific cell or range of cells that remain fixed if you copy or drag the formula.
0 kommentar(er)
