- 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 III
Q 1 - Which of the following is correct about XSSFCreationHelper class in Apache POI?
A - This is a class under the org.apache.poi.xssf.usermodel package.
B - It is used as a support class for formula evaluation and setting up hyperlinks.
Answer : D
Explanation
XSSFCreationHelper is a class under the org.apache.poi.xssf.usermodel package. It implements the CreationHelper interface. It is used as a support class for formula evaluation and setting up hyperlinks.
Q 2 - 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 3 - Which of the following type of cell represents blank cell in Apache POI?
Answer : A
Explanation
XSSFCell.CELL_TYPE_BLANK represents blank cell in Apache POI.
Q 4 - Which of the following type of cell represents boolean cell in Apache POI?
Answer : A
Explanation
XSSFCell.CELL_TYPE_BOOLEAN represents boolean cell in Apache POI.
Q 5 - Which of the following type of cell represents error cell in Apache POI?
Answer : A
Explanation
XSSFCell.CELL_TYPE_ERROR represents error cell in Apache POI.
Q 6 - Which of the following type of cell represents number cell in Apache POI?
Answer : A
Explanation
XSSFCell.CELL_TYPE_NUMERIC represents number cell in Apache POI.
Q 7 - Which of the following type of cell represents text cell in Apache POI?
Answer : A
Explanation
XSSFCell.CELL_TYPE_STRING represents text cell in Apache POI.
Q 8 - Which of the following class is used to style cell in Apache POI?
Answer : B
Explanation
XSSFCellStyle class is used to style cell in Apache POI.
Q 9 - 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.
Answer Sheet
| Question Number | Answer Key |
|---|---|
| 1 | D |
| 2 | D |
| 3 | A |
| 4 | A |
| 5 | A |
| 6 | A |
| 7 | A |
| 8 | B |
| 9 | A |