USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -Explanation: Data entered into a cell as values is numerical. Data can be referenced to in formulas and functions and used in computations when it is represented as a value type. Values in an Excel spreadsheet can be text, dates, numbers, formulas, functions or Boolean information.
Detailed explanation-2: -Value if true (optional)-the value to return when the logical test evaluates to TRUE, i.e. the condition is met. If omitted, the value if false argument must be defined.
Detailed explanation-3: -You can nest up to 64 levels of functions in a formula. Click the cell in which you want to enter the formula.
Detailed explanation-4: -A Formula is an equation designed by a user in Excel, while a Function is a predefined calculation in the spreadsheet application.
Detailed explanation-5: -Use the IF function, one of the logical functions, to return one value if a condition is true and another value if it’s false. For example: =IF(A2>B2, "Over Budget", "OK") =IF(A2=B2, B4-A4, "")