FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Every formula needs to begin with ____
A
=
B
()
C
;
D
FORMULA
Explanation: 

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: -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-3: -A formula begins with an equal sign. Meanwhile, functions are used to perform complex calculations that cannot be done manually. Functions in excel have names that reflect their intended use. The example below shows how we have used the multiplication formula manually with the ‘*’ operator.

There is 1 question to complete.