Online GK Series

This site is dedicated to the aspirants of competitive exams SSC, UPSC, Railways, Postal Assistants, Bank, GATE and NET

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]
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]

Computer Science Books

Chapters

Please Like Us
Brand