1
Gmetrix Practice Exam 2 (2025) ACTUAL EXAM
comprehensive questions and verified accurate
solution (Detailed & Elaborated)|get it 100%
accurate!! 2025 TEST!!
Project 1 task 1 - (answers)1. Above the worksheet to the left of the formula bar,
click the Name Box down arrow.
2. Select Appheading2.
3. Cell range E1:F3 should be selected.
4. Right-click on the selected cells and select Clear Contents.
5. Click OK.
On the Downloads worksheet, adjust the height of row 27 to 78. - (answers)1. On
the Downloads worksheet, click row 27 to select it.
2. On the Home tab, in the Cells group, click Format and select Row Height.
3. In the Row Height pop-up box, type 78.
4. Click OK.
Apply the cell style Light Blue, 40% - Accent 2 to cell A27. - (answers)1. Select cell
A27.
2. On the Home tab, in the Styles group, click the More dropdown.
3. 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. - (answers)1. On the Downloads worksheet, click anywhere within
the cell range A3:B24.
, 2
2. On the Home tab, in the Styles group, click Format as Table.
3. In the section, select Blue, Table Style Light 10.
4. In the Format As Table pop-up window, do the following:
a. Confirm the data field contains =$A$3:$B$24.
Insert a Footer that displays today's date on the right, and then return to Normal
view. - (answers)1. On the Insert tab, in the Text group, click Header & Footer.
2. In the Header & Footer Design tab, in the Navigation group, click Go to Footer.
3. Click the rightmost cell in the Footer.
4. On the Header & Footer Tools Design tab, in the Header & Footer Elements
group, click Current Date.
5. Click outside of the Footer cells.
Import PetFoods.txt located in the GMetrixTemplates folder as a table on a new
worksheet. - (answers)1. 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.)
2. In the Import Data pop-up window, browse to the GMetrixTemplates folder.
3. Select the PetFoods.txt file and click the Import button.
4. In the PetFoods.txt pop-up window, configure the following:
File Origin: accept the default - 1252: Western European (Windows)
Delimiter: Tab
Data Type Detection: Accept the default - Base on first 200 rows
5. Click the down arrow to the right of the Load button and select Load To...
Gmetrix Practice Exam 2 (2025) ACTUAL EXAM
comprehensive questions and verified accurate
solution (Detailed & Elaborated)|get it 100%
accurate!! 2025 TEST!!
Project 1 task 1 - (answers)1. Above the worksheet to the left of the formula bar,
click the Name Box down arrow.
2. Select Appheading2.
3. Cell range E1:F3 should be selected.
4. Right-click on the selected cells and select Clear Contents.
5. Click OK.
On the Downloads worksheet, adjust the height of row 27 to 78. - (answers)1. On
the Downloads worksheet, click row 27 to select it.
2. On the Home tab, in the Cells group, click Format and select Row Height.
3. In the Row Height pop-up box, type 78.
4. Click OK.
Apply the cell style Light Blue, 40% - Accent 2 to cell A27. - (answers)1. Select cell
A27.
2. On the Home tab, in the Styles group, click the More dropdown.
3. 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. - (answers)1. On the Downloads worksheet, click anywhere within
the cell range A3:B24.
, 2
2. On the Home tab, in the Styles group, click Format as Table.
3. In the section, select Blue, Table Style Light 10.
4. In the Format As Table pop-up window, do the following:
a. Confirm the data field contains =$A$3:$B$24.
Insert a Footer that displays today's date on the right, and then return to Normal
view. - (answers)1. On the Insert tab, in the Text group, click Header & Footer.
2. In the Header & Footer Design tab, in the Navigation group, click Go to Footer.
3. Click the rightmost cell in the Footer.
4. On the Header & Footer Tools Design tab, in the Header & Footer Elements
group, click Current Date.
5. Click outside of the Footer cells.
Import PetFoods.txt located in the GMetrixTemplates folder as a table on a new
worksheet. - (answers)1. 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.)
2. In the Import Data pop-up window, browse to the GMetrixTemplates folder.
3. Select the PetFoods.txt file and click the Import button.
4. In the PetFoods.txt pop-up window, configure the following:
File Origin: accept the default - 1252: Western European (Windows)
Delimiter: Tab
Data Type Detection: Accept the default - Base on first 200 rows
5. Click the down arrow to the right of the Load button and select Load To...
