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

ADRE 2.0 FULL LENGTH MOCK TEST

Take Mock Tests

Missiles Mock Test Start Test!
SSC MTS Mock Test Start Test
IBPS CLERK MOCK TEST Start Test
SSC MTS 2022 JULY 26 Shift 1 (ENGLISH) Start Test!
SSC GD Previous Year Paper 2021 Nov 17 Shift - I (Hindi) Start Test!
SSC CGL Tier - 1 PYP 2022 April 21 Shift- 1 (ENGLISH) Start Test!
MPSC PAPER I MOCK TEST 1 (ENGLISH) Start Test!
IB Security Assistant Mock test 1 (english) Start Test!
UP POLICE CONSTABLE MOCK TEST 1 Start Test!
DELHI POLICE CONSTABLE MOCK TEST 1 (HINDI) Start Test!

Chapters

Advertisement
Assam Direct Recruitment Test Series