USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
James wants his spreadsheet to return true when the logical value is false. What function should he use?
|
|
IF
|
|
|
AND
|
|
|
OR
|
|
|
NOT
|
Explanation:
Detailed explanation-1: -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, "")
Detailed explanation-2: -The logical value TRUE is treated the same as the text string “TRUE". Nesting can be used with an IF function to decide between more than two different results. According to the Course Notes, how many levels of nesting can be used with the IF function in Excel 2019?
Detailed explanation-3: -The quickest and easiest way to sum a range of cells is to use the Excel AutoSum button. It automatically enters an Excel SUM function in the selected cell.
There is 1 question to complete.