Apache POI - Online Quiz


Advertisements

Following quiz provides Multiple Choice Questions (MCQs) related to Apache POI. You will have to read all the given answers and click over the correct answer. If you are not sure about the answer then you can check the answer using Show Answer button. You can use Next Quiz button to check new set of questions in the quiz.

Questions and Answers

Answer : A

Explanation

XWPF (XML Word Processor Format) - It is used to read and write docx extension files of MS-Word.

Answer : D

Explanation

HPBF (Horrible PuBlisher Format) - It is used to read and write MS-Publisher files.

Answer : D

Explanation

XSSFCellStyle is a class under the org.apache.poi.xssf.usermodel package. It will provide possible information regarding the format of the content in a cell of a spreadsheet. It also provides options for modifying that format. It implements the CellStyle interface.

Q 4 - Which of the following type of cell represents error cell in Apache POI?

A - XSSFCell.CELL_TYPE_ERROR

B - XSSFCell.CELL_ERROR

C - XSSFCell.ERROR

D - None of the above.

Answer : A

Explanation

XSSFCell.CELL_TYPE_ERROR represents error cell in Apache POI.

Q 5 - Which of the following type of cell represents text cell in Apache POI?

A - XSSFCell.CELL_TYPE_STRING

B - XSSFCell.CELL_STRING

C - XSSFCell.STRING

D - None of the above.

Answer : A

Explanation

XSSFCell.CELL_TYPE_STRING represents text cell in Apache POI.

Answer : B

Explanation

cell.setCellValue("POWER(C2:C3)") method is used to compute power in a formula cell.

apache_poi_questions_answers.htm
Advertisements