- Apache POI Tutorial
- 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 HSLF component of Apache POI?
A - It is used to read and write docx extension files of MS-Word.
B - It is used for read, create, and edit PowerPoint presentations.
C - It contains classes and methods for MS-Visio binary files.
Answer : B
Explanation
HSLF (Horrible Slide Layout Format) - It is used for read, create, and edit PowerPoint presentations.
Q 2 - Which of the following is correct about HDGF component of Apache POI?
A - It is used to read and write docx extension files of MS-Word.
B - It is used for read, create, and edit PowerPoint presentations.
C - It contains classes and methods for MS-Visio binary files.
Answer : D
Explanation
HPBF (Horrible PuBlisher Format) - It is used to read and write MS-Publisher files.
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.
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.
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)")
Answer : A
Explanation
cell.setCellValue("SUM(C2:C3)") method is used to compute sum in a formula cell.
Q 6 - Which of the following is a valid way to compute min in a formula cell?
A - cell.setCellValue("MIN(C2:C3)")
B - cell.setCellValue("MIN_VALUE(C2:C3)")
Answer : A
Explanation
cell.setCellValue("MIN(C2:C3)") method is used to compute min in a formula cell.