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

21 An Excel Workbook is a collection of ......
A Workbooks
B Worksheets
C Charts
D Both (A) and (B)

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

Answer: Option [B]
23 Which function is not available in the Consolidate dialog box ?
A Average
B Max
C Count
D Pmt

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

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

Answer: Option [B]


Current Affairs

Useful Computer Science EBooks

Random GK Questions

A Lala Lajpat Rai
B Bal Gangadhar Tilak
C Agarkara
D Aurodindo Ghosh
Answer: Option [D]
A Brazil
B Argentina
C Germany
D Netherlands
Answer: Option [C]
A Sodium carbonate
B Sodium bicarbonate
C Sodium nitrite
D Sodium nitrate
Answer: Option [B]
A Max Muller
B Adam Smith
C Karl Marx
D None of these above
Answer: Option [B]
A high temperature
B low temperature
C high atmospheric pressure
D low atmospheric pressure
Answer: Option [D]
A lay down positive instructions which would guide State policy at all levels
B implement Ganhiji's idea for a decentralized state.
C check the use of arbitrary powers by the government.
D promote welfare of the backward section of the society.
Answer: Option [A]