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

Sports GK Questions and Answers 2024 (Latest Updated)

Awards & Honours GK Questions 2024 (Latest Updated)

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]
Advertisement
Article and Schedule Quiz Start Test!
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

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

Assam Direct Recruitment Test Series

Computer Science Topics