GMETRIX: Excel Associate 2025
Practice Exam 2 with 100%
correct answers already graded
A+
Navigate to the named cell range AppHeading2 and delete only the
contents, leaving the empty cells. - answer Above the worksheet to
the left of the formula bar, click the Name Box down arrow.
Select AppHeading2.(Hint: Alternatively, on the Home tab, in the
Editing group, click Find & Select, and select Go To... Select
AppHeading2, then click OK.)
Cell range E1:F3 should be selected.
Right-click on the selected cells and select Clear Contents.
Click OK.
On the Downloads worksheet, adjust the height of row 27 to 78. -
answer On the Downloads worksheet, click row 27 to select it.
On the Home tab, in the Cells group, click Format and select Row
Height.
In the Row Height pop-up box, type 78.
Click OK.
Apply the cell style Light Blue, 40% - Accent 2 to cell A27. - answer
Select cell A27.
On the Home tab, in the Styles group, click the More dropdown (this
could also be the Cell Styles dropdown depending on your Excel
window width).
In the Themed Cell Styles section, click Light Blue, 40% - Accent 2.
, Create a table with headers from cell range A3:B24 by applying the
Blue, Table Style Light 10. - answer On the Downloads worksheet,
click anywhere within the cell range A3:B24.
On the Home tab, in the Styles group, click Format as Table.
In the section, select Blue, Table Style Light 10.
In the Format As Table pop-up window, do the following:Confirm the
data field contains =$A$3:$B$24.Confirm the My table has headers
box is enabled.
Click OK.
Insert a Footer that displays today's date on the right, and then
return to Normal view. - answer On the Insert tab, in the Text group,
click Header & Footer.
In the Header & Footer Design tab, in the Navigation group, click Go
to Footer.
Click the rightmost cell in the Footer.
On the Header & Footer Tools Design tab, in the Header & Footer
Elements group, click Current Date.
Click outside of the Footer cells.
On the View tab, in the Workbook Views group, click Normal to close
the Page Layout View (header and footer view).
2/7 - answer 2/7
Import PetFoods.txt located in the GMetrixTemplates folder as a
table on a new worksheet. - answer On the Data tab, in the Get &
Transform Data group, click From Text/CSV.(Hint: Comma-Delimited
files and Tab-Delimited files are types of Text files.)
In the Import Data pop-up window, browse to the GMetrixTemplates
folder.
Select the PetFoods.txt file and click the Import button.
In the PetFoods.txt pop-up window, configure the following:File
Origin: accept the default - 1252: Western European
Practice Exam 2 with 100%
correct answers already graded
A+
Navigate to the named cell range AppHeading2 and delete only the
contents, leaving the empty cells. - answer Above the worksheet to
the left of the formula bar, click the Name Box down arrow.
Select AppHeading2.(Hint: Alternatively, on the Home tab, in the
Editing group, click Find & Select, and select Go To... Select
AppHeading2, then click OK.)
Cell range E1:F3 should be selected.
Right-click on the selected cells and select Clear Contents.
Click OK.
On the Downloads worksheet, adjust the height of row 27 to 78. -
answer On the Downloads worksheet, click row 27 to select it.
On the Home tab, in the Cells group, click Format and select Row
Height.
In the Row Height pop-up box, type 78.
Click OK.
Apply the cell style Light Blue, 40% - Accent 2 to cell A27. - answer
Select cell A27.
On the Home tab, in the Styles group, click the More dropdown (this
could also be the Cell Styles dropdown depending on your Excel
window width).
In the Themed Cell Styles section, click Light Blue, 40% - Accent 2.
, Create a table with headers from cell range A3:B24 by applying the
Blue, Table Style Light 10. - answer On the Downloads worksheet,
click anywhere within the cell range A3:B24.
On the Home tab, in the Styles group, click Format as Table.
In the section, select Blue, Table Style Light 10.
In the Format As Table pop-up window, do the following:Confirm the
data field contains =$A$3:$B$24.Confirm the My table has headers
box is enabled.
Click OK.
Insert a Footer that displays today's date on the right, and then
return to Normal view. - answer On the Insert tab, in the Text group,
click Header & Footer.
In the Header & Footer Design tab, in the Navigation group, click Go
to Footer.
Click the rightmost cell in the Footer.
On the Header & Footer Tools Design tab, in the Header & Footer
Elements group, click Current Date.
Click outside of the Footer cells.
On the View tab, in the Workbook Views group, click Normal to close
the Page Layout View (header and footer view).
2/7 - answer 2/7
Import PetFoods.txt located in the GMetrixTemplates folder as a
table on a new worksheet. - answer On the Data tab, in the Get &
Transform Data group, click From Text/CSV.(Hint: Comma-Delimited
files and Tab-Delimited files are types of Text files.)
In the Import Data pop-up window, browse to the GMetrixTemplates
folder.
Select the PetFoods.txt file and click the Import button.
In the PetFoods.txt pop-up window, configure the following:File
Origin: accept the default - 1252: Western European
