- 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 II
Q 1 - Which of the following is correct about XSSFWorkbook class in Apache POI?
A - It is a class that is used to represent both high and low level Excel file formats.
B - It belongs to the org.apache.xssf.usemodel package.
Answer : D
Explanation
XSSFWorkbook class is a class that is used to represent both high and low level Excel file formats. It belongs to the org.apache.xssf.usemodel package and implements the Workbook interface.
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.
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 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 4 - Which of the following is correct about XSSFRow class in Apache POI?
A - This is a class under the org.apache.poi.xssf.usermodel package.
B - It implements the Row interface, therefore it can create rows in a spreadsheet.
Answer : C
Explanation
XSSFRow is a class under the org.apache.poi.xssf.usermodel package. It implements the Row interface, therefore it can create rows in a spreadsheet.
Q 5 - 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 6 - Which of the following is correct about XSSFCellStyle class in Apache POI?
A - This is a class under the org.apache.poi.xssf.usermodel package.
Answer : D
Explanation
XSSFCellStyle is a class under the org.apache.poi.xssf.usermodel package. It will provide possible information regarding the format of the content in a cell of a spreadsheet. It also provides options for modifying that format. It implements the CellStyle interface.
Q 7 - 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 8 - Which of the following is correct about XSSFFont class in Apache POI?
A - This is a class under the org.apache.poi.xssf.usermodel package.
B - It can handle different fonts in a workbook.
Answer : D
Explanation
XSSFFont is a class under the org.apache.poi.xssf.usermodel package. It implements the Font interface and therefore it can handle different fonts in a workbook.
Q 9 - Which of the following is correct about XSSFHyperlink class in Apache POI?
A - This is a class under the org.apache.poi.xssf.usermodel package.
B - It is used to set a hyperlink to the cell contents of a spreadsheet.
Answer : D
Explanation
XSSFHyperlink is a class under the org.apache.poi.xssf.usermodel package. It implements the Hyperlink interface. It is used to set a hyperlink to the cell contents of a spreadsheet.
Answer Sheet
| Question Number | Answer Key |
|---|---|
| 1 | D |
| 2 | D |
| 3 | C |
| 4 | C |
| 5 | D |
| 6 | D |
| 7 | D |
| 8 | D |
| 9 | D |