Current Affairs Quiz 2024Courses UGC NETADRE 2.0English

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

Download PDF

Download in pdf microsoft excel(MS Excel) multiple choice questions(mcqs) & answers. These general awareness quiz objective questions answers include mcqs on comment, cell, function etc.
Go To Download Page
(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

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

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

LEAVE A COMMENT