G2 PRACTICE EXAMINATION PAPER 1 2026
FULL QUESTIONS AND SOLUTIONS 100%
CORRECT
◉ Import data from the text file StudentGPA into the selected cell in
the current worksheet. Data in the file are delimited by commas, and
the file does include a header row. Do not modify any of the column
data formats. Answer: Import External Data - Text - StudentGPA -
Okay - Okay
◉ In cell E15, enter a formula to find the lowest line item cost this
month (cells E2:E14). Answer: =MIN(Range)
◉ Switch to the view that shows all the worksheet elements as they
will print, including headers and footers. Answer: Page Layout mini
button by Zoom Slider
◉ Modify the status bar so it displays the results of the MIN function
for the selected cells. Answer: Right Click Status Bar (at bottom)
◉ Cells D1:D6 have been cut. Insert them at the current worksheet
location (cell C1). Answer: Home - Insert- Insert Cut Cells
FULL QUESTIONS AND SOLUTIONS 100%
CORRECT
◉ Import data from the text file StudentGPA into the selected cell in
the current worksheet. Data in the file are delimited by commas, and
the file does include a header row. Do not modify any of the column
data formats. Answer: Import External Data - Text - StudentGPA -
Okay - Okay
◉ In cell E15, enter a formula to find the lowest line item cost this
month (cells E2:E14). Answer: =MIN(Range)
◉ Switch to the view that shows all the worksheet elements as they
will print, including headers and footers. Answer: Page Layout mini
button by Zoom Slider
◉ Modify the status bar so it displays the results of the MIN function
for the selected cells. Answer: Right Click Status Bar (at bottom)
◉ Cells D1:D6 have been cut. Insert them at the current worksheet
location (cell C1). Answer: Home - Insert- Insert Cut Cells
