JOIN ADRE 2.0 Telegram Group

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]
Advertisement
ADRE 2.0 Mock Test - 5 Start Test
ADRE 2.0 Mock Test - 5 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]

ADRE 2.0 MOCK TEST

Take Mock Tests

Government Schemes Mock Test Start Test!
Political Science Mock Test – 42 Start Test
History Test – 190 Start Test
Quantitative Aptitude Test Start Test!
Trigonometry - Mock Test Start Test!
Data Interpretation - Mock Test Start Test!
General Awareness - Mock Test Start Test!
Reasoning Ability - Mock Test Start Test!
Englist(Antonyms) Mock Test 1 Start Test!
Quantitative Aptitude (Percentage) Mock Test Start Test!
Economy Mock Test 1 Unlock Test!
Books & Authors - Test 2 Unlock Test!

Chapters

Advertisement