FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -A formula always begins with an equal sign (=). Excel for the web interprets the characters that follow the equal sign as a formula. Following the equal sign are the elements to be calculated (the operands), such as constants or cell references. These are separated by calculation operators.

Detailed explanation-2: -A formula should always start with an equal sign. Else, it will show an error. If we enter any text value instead of giving a cell address, we should provide the text value within an inverted comma (“”). Before entering the function in a cell, ensure that the cell format is general.

Detailed explanation-3: -The purpose of the HASH (#) symbol is to refer to a Spill Range. If you are not familiar with Spill Ranges, check out my video in the #SPILL! error message. We use the # to instruct a formula’s cell reference to obtain all the entries produced by the Spill Range starting at a defined cell address.

Detailed explanation-4: -The SUM function is the first must-know formula in Excel. It usually aggregates values from a selection of columns or rows from your selected range. Example: =SUM(B2:G2) – A simple selection that sums the values of a row.

Detailed explanation-5: -Excel absolute cell reference (with $ sign) The dollar sign fixes the reference to a given cell, so that it remains unchanged no matter where the formula moves. In other words, using $ in cell references allows you to copy the formula in Excel without changing references.