GMETRIX PRACTICE EXAM 2 WITH VERIFIED ANSWERS GRADED A+
1. Project 1 task 1 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 Con-
tents.
5. Click OK.
2. On the Down- 1. On the Downloads worksheet, click row 27 to select it.
loads worksheet, 2. On the Home tab, in the Cells group, click Format and
adjust the height select Row Height.
of row 27 to 78. 3. In the Row Height pop-up box, type 78.
4. Click OK.
3. Apply the cell 1. Select cell A27.
style Light Blue, 2. On the Home tab, in the Styles group, click the More
40% - Accent 2 to dropdown.
cell A27. 3. In the Themed Cell Styles section, click Light Blue, 40%
- Accent 2.
4. Create a table 1. On the Downloads worksheet, click anywhere within the
with headers cell range A3:B24.
from cell range 2. On the Home tab, in the Styles group, click Format as
A3:B24 by ap- Table.
plying the Blue, 3. In the section, select Blue, Table Style Light 10.
Table Style Light 4. In the Format As Table pop-up window, do the following:
10. a. Confirm the data field contains =$A$3:$B$24.
5. Insert a Footer 1. On the Insert tab, in the Text group, click Header &
that displays to- Footer.
day's date on the 2. In the Header & Footer Design tab, in the Navigation
right, and then group, click Go to Footer.
return to Normal 3. Click the rightmost cell in the Footer.
view. 4. On the Header & Footer Tools Design tab, in the Header
& Footer Elements group, click Current Date.
5. Click outside of the Footer cells.
6. Import Pet- 1. On the Data tab, in the Get & Transform Data group,
Foods.txt located click From Text/CSV.
, GMETRIX PRACTICE EXAM 2 WITH VERIFIED ANSWERS GRADED A+
in the GMetrix- (Hint: Comma-Delimited files and Tab-Delimited files are
Templates folder types of Text files.)
as a table on a 2. In the Import Data pop-up window, browse to the
new worksheet. GMetrixTemplates folder.
3. Select the PetFoods.txt file and click the Import button.
4. In the PetFoods.txt pop-up window, configure the follow-
ing:
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...
6. In the Import Data pop-up window, configure the folow-
ing:
Select how you want to view this data in your workbook:
Table
Where do you want to put the data? New Worksheet
7. Click OK.
7. On the Feed 1. On the Feed Inventory worksheet, select cell C27.
Inventory work- 2. On the Insert tab, in the Links group, click Hyperlink.
sheet, remove 3. In the Insert Hyperlink pop-up window, click Remove
the hyperlink Link.
functionality but
leave the text in
cell C27.
8. Remove the con- 1. On the Feed Inventory worksheet, click anywhere on the
ditional format- table.
ting from the In- 2. On the Home tab, in the Styles group, click Conditional
ventory column Formatting.
on on the Feed 3. Select Clear Rules and click Clear Rules from This
Inventory work- Table.
sheet.
9. On the Organic 1. On the Organic Feed worksheet, select cell range
Feed worksheet, A3:F10.
1. Project 1 task 1 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 Con-
tents.
5. Click OK.
2. On the Down- 1. On the Downloads worksheet, click row 27 to select it.
loads worksheet, 2. On the Home tab, in the Cells group, click Format and
adjust the height select Row Height.
of row 27 to 78. 3. In the Row Height pop-up box, type 78.
4. Click OK.
3. Apply the cell 1. Select cell A27.
style Light Blue, 2. On the Home tab, in the Styles group, click the More
40% - Accent 2 to dropdown.
cell A27. 3. In the Themed Cell Styles section, click Light Blue, 40%
- Accent 2.
4. Create a table 1. On the Downloads worksheet, click anywhere within the
with headers cell range A3:B24.
from cell range 2. On the Home tab, in the Styles group, click Format as
A3:B24 by ap- Table.
plying the Blue, 3. In the section, select Blue, Table Style Light 10.
Table Style Light 4. In the Format As Table pop-up window, do the following:
10. a. Confirm the data field contains =$A$3:$B$24.
5. Insert a Footer 1. On the Insert tab, in the Text group, click Header &
that displays to- Footer.
day's date on the 2. In the Header & Footer Design tab, in the Navigation
right, and then group, click Go to Footer.
return to Normal 3. Click the rightmost cell in the Footer.
view. 4. On the Header & Footer Tools Design tab, in the Header
& Footer Elements group, click Current Date.
5. Click outside of the Footer cells.
6. Import Pet- 1. On the Data tab, in the Get & Transform Data group,
Foods.txt located click From Text/CSV.
, GMETRIX PRACTICE EXAM 2 WITH VERIFIED ANSWERS GRADED A+
in the GMetrix- (Hint: Comma-Delimited files and Tab-Delimited files are
Templates folder types of Text files.)
as a table on a 2. In the Import Data pop-up window, browse to the
new worksheet. GMetrixTemplates folder.
3. Select the PetFoods.txt file and click the Import button.
4. In the PetFoods.txt pop-up window, configure the follow-
ing:
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...
6. In the Import Data pop-up window, configure the folow-
ing:
Select how you want to view this data in your workbook:
Table
Where do you want to put the data? New Worksheet
7. Click OK.
7. On the Feed 1. On the Feed Inventory worksheet, select cell C27.
Inventory work- 2. On the Insert tab, in the Links group, click Hyperlink.
sheet, remove 3. In the Insert Hyperlink pop-up window, click Remove
the hyperlink Link.
functionality but
leave the text in
cell C27.
8. Remove the con- 1. On the Feed Inventory worksheet, click anywhere on the
ditional format- table.
ting from the In- 2. On the Home tab, in the Styles group, click Conditional
ventory column Formatting.
on on the Feed 3. Select Clear Rules and click Clear Rules from This
Inventory work- Table.
sheet.
9. On the Organic 1. On the Organic Feed worksheet, select cell range
Feed worksheet, A3:F10.
