Gmetrix Practice Exam 2 Questions And Correct Answers
Project 1 task 1 - Answer 1. Above the worksheet to the left of the formula bar, click the
Name Box down arrow.
2. Click Appheading2.
3. The cell range E1:F3 should be selected.
4. Right-click the selected cells and click Clear Contents
5. Click OK.
In the Downloads worksheet change the row height for row 27 to 78. - Answer 1. In the
Downloads worksheet click row 27 to select it.
2. In the Home tab, in the Cells group, click Format, then 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.-Solution 1. Click cell A27.
2. In the Home tab, in the Styles group, click the More drop down.
3. In the Themed Cell Styles section click Light Blue, 40% - Accent 2.
A3:B24 as table format using the Blue, Table Style Light 10. Solution 1. On the
Downloads worksheet select any cell in the range A3:B24.
2. On the Home tab click Format as Table in the Styles group.
3. In the Format as Table section, click Blue, Table Style Light 10.
4. In the Format As Table dialog box do the following:
a. Check the data field is set to =$A$3:$B$24.
Insert a Footer with today's date positioned on the right. Return to Normal view. -
, Solution 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 far right 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 that is located in the GMetrixTemplates folder as a table on to a new
worksheet. - Solution
1. On the Data tab, in the Get & Transform Data group click From Text/CSV.
(Hint: Comma-Delimited files and Tab-Delimited files are file types of Text files.)
2. In the Import Data dialog box, click the GMetrixTemplates folder.
3. Double-click the PetFoods.txt file.
4. In the import dialog box for the file PetFoods.txt set 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 click Load To.
6. In the Import Data dialog box under Select how you want to view this data in your
workbook: select Table and under Where do you want to put the data? select New
Worksheet
7. Click OK .
On the Feed Inventory worksheet, remove the hyperlink but keep the text in cell C27. -
Solution 1. On the Feed Inventory worksheet, select cell C27.
2. On the Insert tab, in the Links group click Hyperlink.
3. In the Insert Hyperlink pop-up window, click Remove Link.
Remove the conditional formatting from the Inventory column on on the Feed Inventory
worksheet. - Answer 1. On the Feed Inventory worksheet, click anywhere on the table.
2. On the Home tab, in the Styles group, click Conditional Formatting.
Project 1 task 1 - Answer 1. Above the worksheet to the left of the formula bar, click the
Name Box down arrow.
2. Click Appheading2.
3. The cell range E1:F3 should be selected.
4. Right-click the selected cells and click Clear Contents
5. Click OK.
In the Downloads worksheet change the row height for row 27 to 78. - Answer 1. In the
Downloads worksheet click row 27 to select it.
2. In the Home tab, in the Cells group, click Format, then 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.-Solution 1. Click cell A27.
2. In the Home tab, in the Styles group, click the More drop down.
3. In the Themed Cell Styles section click Light Blue, 40% - Accent 2.
A3:B24 as table format using the Blue, Table Style Light 10. Solution 1. On the
Downloads worksheet select any cell in the range A3:B24.
2. On the Home tab click Format as Table in the Styles group.
3. In the Format as Table section, click Blue, Table Style Light 10.
4. In the Format As Table dialog box do the following:
a. Check the data field is set to =$A$3:$B$24.
Insert a Footer with today's date positioned on the right. Return to Normal view. -
, Solution 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 far right 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 that is located in the GMetrixTemplates folder as a table on to a new
worksheet. - Solution
1. On the Data tab, in the Get & Transform Data group click From Text/CSV.
(Hint: Comma-Delimited files and Tab-Delimited files are file types of Text files.)
2. In the Import Data dialog box, click the GMetrixTemplates folder.
3. Double-click the PetFoods.txt file.
4. In the import dialog box for the file PetFoods.txt set 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 click Load To.
6. In the Import Data dialog box under Select how you want to view this data in your
workbook: select Table and under Where do you want to put the data? select New
Worksheet
7. Click OK .
On the Feed Inventory worksheet, remove the hyperlink but keep the text in cell C27. -
Solution 1. On the Feed Inventory worksheet, select cell C27.
2. On the Insert tab, in the Links group click Hyperlink.
3. In the Insert Hyperlink pop-up window, click Remove Link.
Remove the conditional formatting from the Inventory column on on the Feed Inventory
worksheet. - Answer 1. On the Feed Inventory worksheet, click anywhere on the table.
2. On the Home tab, in the Styles group, click Conditional Formatting.
