Apache POI - Online Quiz

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.

Q 1 - Which of the following is correct about HSSF component of Apache POI?

A - It is used to read and write xls format of MS-Excel files.

B - It is used for xlsx file format of MS-Excel.

C - It is used to extract property sets of the MS-Office files.

D - It is used to read and write doc extension files of MS-Word.

Answer : A

Explanation

HSSF (Horrible Spreadsheet Format) - It is used to read and write xls format of MS-Excel files.

Q 2 - Which of the following is correct about HSSFSheet class in Apache POI?

A - This is a class under the org.apache.poi.hssf.usermodel package.

B - It can create excel spreadsheets.

C - It allows to format the sheet style and sheet data.

D - All of the above.

Answer : D

Explanation

HSSFSheet class is a class under the org.apache.poi.hssf.usermodel package. It can create excel spreadsheets and it allows to format the sheet style and sheet data.

Q 3 - Which of the following is correct about HSSFColor class in Apache POI?

A - This is a class under the org.apache.poi.hssf.util package.

B - It provides different colors as nested classes.

C - It implements the Color interface.

D - All of the above.

Answer : D

Explanation

HSSFColor is a class under the org.apache.poi.hssf.util package. It provides different colors as nested classes. Usually these nested classes are represented by using their own indexes. It implements the Color interface.

Q 4 - Which of the following is correct about XSSFPrintSetup class in Apache POI?

A - This is a class under the org.apache.poi.xssf.usermodel package.

B - It is used to set print page size, area, options, and settings.

C - It implements the PrintSetup interface.

D - All of the above.

Answer : D

Explanation

XSSFPrintSetup is a class under the org.apache.poi.xssf.usermodel package. It implements the PrintSetup interface. It is used to set print page size, area, options, and settings.

Q 5 - Which of the following is a valid way to compute sum in a formula cell?

A - cell.setCellValue("SUM(C2:C3)")

B - cell.setCellValue("ADD(C2:C3)")

C - cell.setCellValue("SUMMATION(C2:C3)")

D - None of the above.