- 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 IV
Q 1 - Which of the following class is used to rotate a cell content in Apache POI?
Answer : B
Explanation
XSSFCellStyle.setRotation() method is used to rotate a cell content in Apache POI.
Q 2 - Which of the following class is used to rotate a cell content in Apache POI?
Answer : B
Explanation
XSSFCellStyle.setRotation() method is used to rotate a cell content in Apache POI.
Q 3 - 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 4 - 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.
Q 5 - Which of the following is a valid way to compute max in a formula cell?
A - cell.setCellValue("MAX(C2:C3)")
B - cell.setCellValue("MAX_VALUE(C2:C3)")
Answer : A
Explanation
cell.setCellValue("MAX(C2:C3)") method is used to compute max 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.
Q 7 - Which of the following is a valid way to compute factorial in a formula cell?
A - cell.setCellValue("FACTOR(C2)")
B - cell.setCellValue("FACT(C2)")
Answer : B
Explanation
cell.setCellValue("FACT(C2)") method is used to compute factorial in a formula cell.
Q 8 - Which of the following is a valid way to compute square root in a formula cell?
A - cell.setCellValue("SQUARE_ROOT(C2)")
B - cell.setCellValue("SQUARE(C2)")
Answer : C
Explanation
cell.setCellValue("SQRT(C2)") method is used to compute square root in a formula cell.
Q 9 - Which of the following class is used to add a hyperlink to a cell in Apache POI?
Answer : A
Explanation
XSSFHyperlink class is used to add a hyperlink to a cell in Apache POI.
Answer Sheet
| Question Number | Answer Key |
|---|---|
| 1 | B |
| 2 | B |
| 3 | A |
| 4 | B |
| 5 | A |
| 6 | A |
| 7 | B |
| 8 | C |
| 9 | A |