Exam (elaborations)
Gmetrix Practice Exam 2 Questions And Correct Answers
- Course
- Institution
Gmetrix Practice Exam 2 Questions And Correct Answers...
[Show more]
Content preview
Gmetrix Practice Exam 2 Questions And Correct AnswersProject 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.
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 Easton. 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.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
76799 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now