GMETRIX PRACTICE EXAM 2 QUESTIONS AND ANSWERS

GMETRIX PRACTICE EXAM 2 QUESTIONS
AND ANSWERS




Task 1 of Project 1: ANSWER 1. Click the Name Box down arrow to the left of
the formula bar above the worksheet.
2. Choose Appheading2.
3. The cell range E1:F3 ought to be chosen.

4. Choose Clear Contents by performing a right-click on the chosen cells.
5. Press OK.

Change row 27 to row 78's height on the Downloads worksheet. ANSWER 1.
To pick row 27, click on the Downloads worksheet.
2. Click Format and choose Row Height under the Cells group on the Home tab.
3. Enter 78 in the Row Height pop-up box.
4. Press OK.

Cell A27 should have the cell style Light Blue, 40% - Accent 2. ANSWER 1.
Pick cell A27.
2. Click the More dropdown in the Styles group on the Home tab.
3. Select Light Blue, 40%- Accent 2 under Themed Cell Styles.

Use the Blue, Table Style Light 10 to create a table with headers from cell range
A3:B24. ANSWER 1. Click anywhere in the cell range A3:B24 on the
Downloads worksheet.
2. Select Format as Table under the Styles group on the Home tab.
3. Choose Blue, Table Style Light 10 from the section.
4. Complete the following actions in the Format As Table pop-up window:
Verify that the data field has =$A.$3:$B$24.

After inserting a footer that shows the current date on the right, go back to
normal view. ANSWER 1. Select Header & Footer under the Text group on the
Insert tab.

, 2. Click Go to Footer in the Navigation category of the Header & Footer Design
menu.
3. In the Footer, click the cell on the right.
4. Click Current Date under the Header & Footer Elements category on the
Header & Footer Tools Design menu.
5. Click outside the cells in the Footer.

Open a new worksheet and import the PetFoods.txt file from the
GMetrixTemplates folder as a table. ANSWER 1. Select From Text/CSV under
the Get & Transform Data group on the Data tab.
(Hint: Text files include tab-delimited and comma-delimited files.)
2. Open the GMetrixTemplates folder in the Import Data pop-up box.
3. Click the Import option after selecting the PetFoods.txt file.
4. Set up the following in the PetFoods.txt pop-up window:
Accept the default file origin, which is 1252: Western European (Windows).
Delimiter: Tab
Identification of Data Type: Take the default, which is based on the first 200
rows.
5. Choose Load To by clicking the down arrow next to the Load icon.
6. Set up the following in the Import Data pop-up window:
In your workbook, choose how you wish to see this data: Table
Where would you like the data to be stored? A New Worksheet
7. Press OK.

Remove the hyperlink feature from the Feed Inventory worksheet, but retain the
text in cell C27. ANSWER 1. Choose cell C27 on the Feed Inventory
worksheet.
2. Click Hyperlink in the Links group on the Insert tab.
3. Select Remove Link from the Insert Hyperlink pop-up window.

The Inventory column on the Feed Inventory worksheet should have its
conditional formatting removed. ANSWER 1. Click anywhere on the table in
the Feed Inventory worksheet.
2. Select Conditional Formatting under the Styles group on the Home tab.
3. Click Clear Rules from This Table after selecting Clear Rules.