Current Affairs Quiz 2024GKCourses AptitudeADRE 2.0English

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

Download PDF

Download in pdf microsoft excel(MS Excel) multiple choice questions(mcqs) & answers. These general awareness quiz objective questions answers include mcqs on cell address, remainder function, consolidate etc.
Go To Download Page
(21) An Excel Workbook is a collection of ......
[A] Workbooks
[B] Worksheets
[C] Charts
[D] Both (B) and (C)

Comment

Answer: Option [D]
(22) To return the remainder after a number is divided by a divisor in EXCEL we use the function ?
[A] ROUND ( )
[B] MOD ( )
[C] FACT ( )
[D] None of the above

Comment

Answer: Option [B]

DOWNLOAD CURRENT AFFAIRS PDF FROM APP

Article and Schedule Quiz Start Test!
(23) Which function is not available in the Consolidate dialog box ?
[A] Average
[B] Max
[C] Count
[D] Pmt

Comment

Answer: Option [D]
(24) How do you rearrange the data in ascending or descending order ?
[A] Data, Sort
[B] Data, Form
[C] Data, Table
[D] None of the above

Comment

Answer: Option [A]
(25) Excel displays the current cell address in the ....
[A] Status Bar
[B] Name Box
[C] Formula bar
[D] None of the above

Comment

Answer: Option [B]

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