GkSeries.com

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

(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

Comment

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)

Comment

Answer: Option [D]

DOWNLOAD CURRENT AFFAIRS PDF FROM APP

(48) Which of the following is correct ?
[A] =POWER(2*3)
[B] =POWER(2^3)
[C] =POWER(2,3)
[D] None of the above

Comment

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

Comment

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

Comment

Answer: Option [C]

Please share this page

Chapters

Click Here to Read more questions

Teacher Eligibility Test