- Apache POI - Home
- Apache POI - Overview
- Apache POI - Java Excel APIs
- Apache POI - Environment
- Apache POI - Core Classes
- Apache POI - Workbooks
- Apache POI - Spreadsheets
- Apache POI - Cells
- Apache POI - Fonts
- Apache POI - Formula
- Apache POI - Hyperlink
- Apache POI - Print Area
- Apache POI - Database
- Apache POI Resources
- Apache POI - Questions & Answers
- Apache POI - Quick Guide
- Apache POI - Useful Resources
- Apache POI - Discussion
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 XSSFSheet class in Apache POI?
A - This is a class which represents high level representation of excel spreadsheet.
Answer : C
Explanation
XSSFSheet is a class which represents high level representation of excel spreadsheet. It is under org.apache.poi.hssf.usermodel package.
Q 3 - Which of the following is correct about XSSFCell class in Apache POI?
A - This is a class under the org.apache.poi.xssf.usermodel package.
B - It implements the Cell interface.
C - It is a high-level representation of cells in the rows of a spreadsheet.
Answer : D
Explanation
XSSFCell is a class under the org.apache.poi.xssf.usermodel package. It implements the Cell interface. It is a high-level representation of cells in the rows of a spreadsheet.
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.
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 class is used to add a font to a cell in Apache POI?
Answer : A
Explanation
XSSFFont class is used to add a font to a cell in Apache POI.
Q 6 - Which of the following is a valid way to compute power in a formula cell?
A - cell.setCellValue("POW(C2:C3)")
B - cell.setCellValue("POWER(C2:C3)")
Answer : B
Explanation
cell.setCellValue("POWER(C2:C3)") method is used to compute power in a formula cell.