DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Formula returns the value “DONE”
|
|
|
Formula will show an error
|
|
|
Formula returns the value “RESTART”
|
|
|
Formula returns the value “YES”
|
Detailed explanation-1: -Answer: A. The formula returns the text “RESTART”. Explanation: The general syntax of the IF() function in Excel is as follows: IF(Conditional Expression, Value if the expression returns True, Value if the expression returns False) Compare …
Detailed explanation-2: -Return a value if a given value exists in a certain range by using a formula. Please apply the following formula to return a value if a given value exists in a certain range in Excel. 1. Select a blank cell, enter formula =VLOOKUP(E2, A2:C8, 3, TRUE) into the Formula Bar and then press the Enter key.
Detailed explanation-3: -AND – =IF(AND(Something is True, Something else is True), Value if True, Value if False) OR – =IF(OR(Something is True, Something else is True), Value if True, Value if False) NOT – =IF(NOT(Something is True), Value if True, Value if False)
Detailed explanation-4: -The MAX function returns the largest numeric value in the data provided. The MAX function can be used to return the largest value from any type of numeric data.