FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -For simple formulas, simply type the equal sign followed by the numeric values that you want to calculate and the math operators that you want to use-the plus sign (+) to add, the minus sign (-) to subtract, the asterisk (*) to multiply, and the forward slash (/) to divide.

Detailed explanation-2: -To enter an Excel formula into a cell, you start with an equal (=) sign. Excel then knows that the expression that follows should be interpreted as a calculation, not text. After the equal sign, you enter the formula. For example, you can find the sum of the numbers in cells C2 and C3 by using the formula =C2+C3.

Detailed explanation-3: -Switch between displaying formulas and their results from the keyboard. Press CTRL + ‘ (grave accent).

Detailed explanation-4: -A function is a predefined formula that performs calculations using specific values in a particular order. All spreadsheet programs include common functions that can be used for quickly finding the sum, average, count, maximum value, and minimum value for a range of cells.