Online GK Series

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

3,00,000 Jobs Waiting For You

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]

Chapters

Useful Computer Science EBooks