GMETRIX PRACTICE EXAM 2 WITH VERIFIED ANSWERS GRADED A+
8 views 0 purchase
Course
GMETRIX
Institution
GMETRIX
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...
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.
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller MERCYTRISHIA. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $9.99. You're not tied to anything after your purchase.
