DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
equal sign
|
|
|
plus sign
|
|
|
command
|
|
|
a slash
|
Detailed explanation-1: -All formulas in spreadsheet programs, like Microsoft Excel, OpenOffice Calc, and Google Sheets start with an equal sign (=). To display an equal sign, but not have it start a formula, you must “escape” the cell by entering a single quote (’) at the beginning.
Detailed explanation-2: -The Equal to logical operator (=) can be used to compare all data types-numbers, dates, text values, Booleans, as well as the results returned by other Excel formulas. For example: =A1=B1. Returns TRUE if the values in cells A1 and B1 are the same, FALSE otherwise. =A1="oranges"
Detailed explanation-3: -If you type in the formula, you must start with an equal sign, so Excel knows that the data in the cell is a formula.
Detailed explanation-4: -Let’s take an example of a simple formula. On the worksheet, click the cell in which you want to enter the formula. Type the = (equal sign) followed by the constants and operators (up to 8192 characters) that you want to use in the calculation. For our example, type =1+1.