FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
In the following formula:=IF(A1="YES", “DONE", “RESTART"), what happens if A1="NO”?
A
Formula returns the value “DONE”
B
Formula will show an error
C
Formula returns the value “RESTART”
D
Formula returns the value “YES”
Explanation: 

Detailed explanation-1: -Answer: A. The formula returns the text “RESTART”.

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: -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.

Detailed explanation-4: -The ISFORMULA Function[1] is categorized under Excel Information functions. It will test a specified cell to see if it contains a formula. If it does contain a formula, then it will return TRUE. If not, then it will return FALSE.

There is 1 question to complete.