USING MICROSOFT EXCEL
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: -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-3: -Relative cell references are basic cell references that adjust and change when copied or when using AutoFill.
Detailed explanation-4: -Unlike relative references, absolute references do not change when copied or filled. You can use an absolute reference to keep a row and/or column constant. An absolute reference is designated in a formula by the addition of a dollar sign ($) before the column and row.