COMPUTER APPLICATIONS
OFFICE AUTOMATION SOFTWARE
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Formulas in Excel start with
|
|
%
|
|
|
#
|
|
|
*
|
|
|
=
|
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.
Detailed explanation-2: -All formulas in Excel must begin with an equals sign (=). This is because the cell contains, or is equal to, the formula and the value it calculates.
Detailed explanation-3: -=IF(ISERR(LEFT(cell location, 1)*1), “Letter”, “Number") In this formula, we are calculating the value of a cell’s left most character multiplied by 1. =IF(ISNUMBER(VALUE(LEFT(cell location, 1))), “Number", “Letter") 16-Sept-2022
There is 1 question to complete.