MGRADES EXAMS
Gmetrix Practice Exam 2 UPDATED
ACTUAL Exam Questions and CORRECT
Answers
Project 1 task 1 - CORRECT ANSWER - 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. - CORRECT ANSWER -
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. - CORRECT ANSWER - 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. -
CORRECT ANSWER - 1. On the Downloads worksheet, click anywhere within the cell
range A3:B24.
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.
, MGRADES EXAMS
Insert a Footer that displays today's date on the right, and then return to Normal view. -
CORRECT ANSWER - 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. -
CORRECT ANSWER - 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...
6. In the Import Data pop-up window, configure the folowing:
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.
On the Feed Inventory worksheet, remove the hyperlink functionality but leave the text in cell
C27. - CORRECT ANSWER - 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.
Gmetrix Practice Exam 2 UPDATED
ACTUAL Exam Questions and CORRECT
Answers
Project 1 task 1 - CORRECT ANSWER - 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. - CORRECT ANSWER -
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. - CORRECT ANSWER - 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. -
CORRECT ANSWER - 1. On the Downloads worksheet, click anywhere within the cell
range A3:B24.
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.
, MGRADES EXAMS
Insert a Footer that displays today's date on the right, and then return to Normal view. -
CORRECT ANSWER - 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. -
CORRECT ANSWER - 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...
6. In the Import Data pop-up window, configure the folowing:
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.
On the Feed Inventory worksheet, remove the hyperlink functionality but leave the text in cell
C27. - CORRECT ANSWER - 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.
