DATABASE FUNDAMENTALS
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
*
|
|
|
$
|
|
|
=
|
|
|
#
|
|
|
^t
|
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: -Correct a # error value. If a formula cannot correctly evaluate a result, Excel displays an error value, such as #####, #DIV/0!, #N/A, #NAME?, #NULL!, #NUM!, #REF!, and #VALUE!. Each error type has different causes, and different solutions.
Detailed explanation-3: -When a formula contains a typographical error, unnecessary or missing punctuation, incorrect order of arguments, or an incorrect cell reference, it returns: a. an error message that begins with an exclamation point (!)
Detailed explanation-4: -Relative cell references are basic cell references that adjust and change when copied or when using AutoFill.