Multiple Choice Questions and Answers on MS Excel | Page-10

Questions

46 A smart tag will be removed from a cell when

A the cell is moved

B the cell is hidden

C the data in the cell is changed or deleted

D None of the above

Answer: Option [C]

47 Which of the following is correct syntax in Excel ?

A =IF(LogicalTest, TrueResult), IF(LogicalTest, FalseResult)

B =IF(LogicalTest, TrueResult) (LogicalTest, FalseResult)

C =IF(LogicalTest, (TrueResult, FalseResult))

D =IF(LogicalTest, TrueResult, FalseResult)

Answer: Option [D]

⭐ Make GKSeries Your Preferred Source on Google

48 Which of the following is correct ?

A =POWER(2*3)

B =POWER(2^3)

C =POWER(2,3)

D None of the above

Answer: Option [C]

49 If 4/6 entered in a cell without applying any formats, Excel will treat this as

A Date

B Text

C Fraction

D None of the above

Answer: Option [A]

50 What is the shortcut key to insert a new comment in a cell ?

A Alt + F2

B Ctrl + F2

C Shift + F2

D None of the above

Answer: Option [C]