Gmetrix Practice Exam 2 Latest Update Graded A+

Gmetrix Practice Exam 2 Latest Update Graded A+ 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 Contents. 5. Click OK. On the Downloads worksheet, adjust the height of row 27 to 78. 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. 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. 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. Insert a Footer that displays today's date on the right, and then return to Normal view. 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 PetF located in the GMetrixTemplates folder as a table on a new worksheet. 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 PetF file and click the Import button. 4. In the PetF 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. 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. 1. On the Feed Inventory worksheet, click anywhere on the table. 2. On the Home tab, in the Styles group, click Conditional Formatting. 3. Select Clear Rules and click Clear Rules from This Table. On the Organic Feed worksheet, format the data range A3:F10 as a table that has headers. Apply the Dark Red, Table Style Medium 7 format. 1. On the Organic Feed worksheet, select cell range A3:F10. 2. On the Home tab, in the Styles group, click Format as Table to open the gallery. 3. Under the Medium section, click Dark Red, Table Style Medium 7. 4. In the Format As Table pop-up window, do the following: a. Confirm the data field contains =$A$3:$F$10. b. Confirm the My table has headers box is enabled.