Gmetrix Latest Update with Correct Answers

Gmetrix Latest Update with Correct Answers To rename a table go to the Formula tab, click "Name Manager" in the Defined Names group and then you click on the table name and edit it. Inspecting Click the file tab, look for the "Inspect Workbook" group. Click "Check for Issues" and then "Check Compatibility." If you need to copy to a new sheet, then you click the "copy to a new sheet" button (bottom left corner.) Linking Info from another sheet Click on the cell you want to link. Go to the Insert Tab, and click the Link button on the far right. Click hyperlink. Click the "place in this document" option. Select the page you want and the cell's location. Concatenating Insert Function (Left of Cell Address Bar). Type =CONCAT. In the first box, choose where you want the first information to come from (Page and Cell Address). In the second box, use the " " marks to indicate a space. Merging cells To Join Cells means to merge Repeated Rows If you want the top three rows to be printed on every page, go to the Page Layout tab. Go to "Print Titles" and insert the rows you want printed on each page. Total Rows Click in the data. Click the design tab, then check the box for total rows Importing txt or csv files Click on the data tab, then click "From txt/csv", choose the file, and verify the information. After that, click load. Removing Hyperlinks Click on the Insert tab. Click the Link button on the far right hand side of the ribbon. In the dialog box, click "Remove Link" Freezing Panes Select the row below the rows you wish to freeze. Go to the View tab and click the button named "Freeze Panes." Select the first option. Charts Click on the chart. Go to the Design tab. Under styles, you select the style you want. You can also change the legend and labels, switch rows to columns. Switch between rows and columns in source data Once a chart exists, selecting the chart reveals two contextual tabs: Chart Tools Design and Chart Tools Format. On the Chart Tools Design tab is the Data group. Contained in the Data group are two notable features: Switch Row/Column and Select Data. Switching the orientation of the chart from Rows/Columns and Columns/Rows changes the chart to analyze the