G2 PRACTICE EXAM 1 2026 COMPLETE
QUESTIONS AND VERIFIED SOLUTIONS
GRADED A+
◉ Convert the table to a normal range. Answer: On the Table Tools
Design tab, in the Tools group, click the Convert to Range button.
Click Yes.
◉ Collapse the entire outline to show just the subtotals. Answer:
Click the 2 outline symbol at the left of the column headings.
◉ Use Goal Seek to find the value for cell D12 that will result in a
value of $650,000 for cell B15. Accept the solution. Answer: On the
Data tab, in the Data Tools group, click the What-If Analysis button,
and click Goal Seek... Enter 650000 in the To value box. Enter D12 in
the By changing cell box. Click OK. Click OK.
◉ Modify the number format so no decimal places are visible after
the decimal point. Answer: On the Home tab, in the Number group,
click the Decrease Decimal button twice.
◉ The 2016 data point in the Gross Profit data series has been
selected. Change the outline width to 2 1/4 pt. Answer: On the Chart
, Tools Format tab, Shape Styles group, click the Shape Outline button,
point to Weight, and select 2 1/4 pt.
◉ 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
◉ Use Format Painter to copy the formatting from cell D1 and apply
it to cell E1. Answer: Click Paintbrush Icon on Home Tab (located by
Paste/Clipboard) - Click on desired cell
QUESTIONS AND VERIFIED SOLUTIONS
GRADED A+
◉ Convert the table to a normal range. Answer: On the Table Tools
Design tab, in the Tools group, click the Convert to Range button.
Click Yes.
◉ Collapse the entire outline to show just the subtotals. Answer:
Click the 2 outline symbol at the left of the column headings.
◉ Use Goal Seek to find the value for cell D12 that will result in a
value of $650,000 for cell B15. Accept the solution. Answer: On the
Data tab, in the Data Tools group, click the What-If Analysis button,
and click Goal Seek... Enter 650000 in the To value box. Enter D12 in
the By changing cell box. Click OK. Click OK.
◉ Modify the number format so no decimal places are visible after
the decimal point. Answer: On the Home tab, in the Number group,
click the Decrease Decimal button twice.
◉ The 2016 data point in the Gross Profit data series has been
selected. Change the outline width to 2 1/4 pt. Answer: On the Chart
, Tools Format tab, Shape Styles group, click the Shape Outline button,
point to Weight, and select 2 1/4 pt.
◉ 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
◉ Use Format Painter to copy the formatting from cell D1 and apply
it to cell E1. Answer: Click Paintbrush Icon on Home Tab (located by
Paste/Clipboard) - Click on desired cell
