GkSeries.com

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

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

Please share this page

Chapters

Click Here to Read more questions

Teacher Eligibility Test