Gmetrix Questions and Answers Already Passed

Gmetrix Questions and Answers Already Passed Import the comma delimited file A located in the GMetrixTemplates folder into a new worksheet. Add the import to the data model and accept all other defaults. 1. Click the Data tab. 2. In the Get & Transform Data group, click From Text/CSV. 3. Browse to the GMetrixTemplates folder. 4. Select the A file and click the Import button. 5. In the A pop-up window, ensure that Delimiter is set to Comma. 6. At the bottom of the pop-window, click the dropdown arrow next to Load and click Load To... 7. In the Import Data pop-up window, under the Where do you want to put the data? section, make sure New worksheet is checked. 8. Click the checkbox for Add this data to the Data Model. 9. Click OK. Clear the formatting in cell range A4:D4 on the Rental Rates worksheet. 1. Select cell range A4:D4 on the Rental Rates worksheet. 2. On the Home tab, in the Editing group, click Clear and select Clear Formats. Rename Table1 to Rates. 1. On the Formulas tab, in the Defined Names group, click Name Manager. 2. In the Name Manager pop-up window, make sure Table1 is selected and click the Edit button. 3. In the Edit Name pop-up window, replace the name Table1 with Rates. 4. Click OK Change the orientation of the Rental Rates worksheet to landscape. 1. Select the Rental Rates worksheet. 2. In the Page Layout tab, Page Setup group, select the Orientation dropdown. 3. Select Landscape. Inspect the workbook for compatibility issues. Copy the results to a new worksheet. 1. Click the File tab. 2. On the default Info page, click the Check for Issues button. 3. Select Check Compatibility. 4. At the bottom of the Microsoft Excel -