USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
=10+50
|
|
=B7+B8
|
|
=B7+14
|
|
10+50
|
Detailed explanation-1: -A formula always starts with an equal sign (=), which can be followed by numbers, math operators (such as a plus or minus sign), and functions, which can really expand the power of a formula. Here in option D 10+50 there is no equal sign (=), so it is not correct.
Detailed explanation-2: -Option-D. 10+50 is not entered correctly in Excel sheets or spreadsheets. The Microsoft Excel sheet or Go ogle spreadsheet is a computer application. It is used to save large data in a tabular form.
Detailed explanation-3: -=IF(logical test, value if true, value if false) The function uses the following arguments: Logical test (required argument) – This is the condition to be tested and evaluated as either TRUE or FALSE.
Detailed explanation-4: -Detailed Solution. The correct answer is “ALT".
Detailed explanation-5: -Cells containing formulas that result in an error: A formula does not use the expected syntax, arguments, or data types. Error values include #DIV/0!, #N/A, #NAME?, #NULL!, #NUM!, #REF!, and #VALUE!. Each of these error values have different causes and are resolved in different ways.