- 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 - Mock Test
This section presents you various set of Mock Tests related to Apache POI. You can download these sample mock tests at your local machine and solve offline at your convenience. Every mock test is supplied with a mock test key to let you verify the final score and grade yourself.
Apache POI Mock Test I
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 XSSF 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 : B
Explanation
XSSF (XML Spreadsheet Format) - It is used for xlsx file format of MS-Excel.
Q 3 - Which of the following is correct about HPSF 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 : C
Explanation
HPSF (Horrible Property Set Format) - It is used to extract property sets of the MS-Office files.
Q 4 - Which of the following is correct about HWPF 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 : D
Explanation
HWPF (Horrible Word Processor Format) - It is used to read and write doc extension files of MS-Word.
Q 5 - Which of the following is correct about XWPF 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 : A
Explanation
XWPF (XML Word Processor Format) - It is used to read and write docx extension files of MS-Word.
Q 6 - 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 7 - 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 : C
Explanation
HDGF (Horrible DiaGram Format) - It contains classes and methods for MS-Visio binary files.
Q 8 - 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 9 - Which of the following is correct about HSSFWorkbook class in Apache POI?
A - It is a high-level class under the org.apache.poi.hssf.usermodel package.
B - It implements the Workbook interface.
Answer : D
Explanation
HSSFWorkbook class is a high-level class under the org.apache.poi.hssf.usermodel package. It implements the Workbook interface and is used for Excel files in .xls format.
Answer Sheet
| Question Number | Answer Key |
|---|---|
| 1 | A |
| 2 | B |
| 3 | C |
| 4 | D |
| 5 | A |
| 6 | B |
| 7 | C |
| 8 | D |
| 9 | D |