If cell A1 contains a number 100, then what will be the answer of =IF(A1< 200, A1+10, A1-10)?

Related MCQs

• If cell B1 contains text MUMBAI then what will be the answer of =LOWER(B1)?
• Cell A2 contains a text COMPUTER. What will be the answer of =LEFT(A2)?
• Cell A2 contains a text COMPUTER. What will be the answer of =LEFT(“A2”)?
• Cell A2 contains a text COMPUTER. What will be the answer of =LEFT(A2, 3)?
• To count number of cells that contains numbers, we use _____.
• 15-August-2020 was Saturday. Answer of =WEEKDAY(“15-August-2020”) will be_____
• 15-August-2020 was Saturday. Answer of =MONTH(“15-August-2020”) will be ________
• 15-August-2020 was Saturday. Answer of =YEAR(“15-August-2020”) will be ________
• Answer of =DAYS360(“1-Jan-2020”, “31-Dec-2020”) will be ________
• Answer of =YEAR(“15-Aug-20”) will be