GMETRIX REVIEW EXCEL 2023 QUESTIONS AND
ANSWERS 100% VERIFIED
In the Annual Sales worksheet, use the Find & Select tool to find the cell in the
open spreadsheet that contains Conditional Formating and apply a Thick Outside
Border.
1. In the Home tab, go to the Editing group and click Find & Select drop down menu
select Conditional Formatting2. With cell F16 selected in the Home tab, go to the Font
group and click on the Borders drop down menu and select Thick Outside Borders.
Add a comment saying Full Nameinside of the cell J4.
1. Select cell J4. In theReview tab, go to theComments group and clickNew
Comment.2. Inside the comment enter: Full Name then click out of the comment.
In the Annual Sales worksheet, apply a Links to the title FusionTomo Inc. that
links to the website www.fusiontomo.com.
1. In the Annual Sales worksheet, highlight the cell A1. In the Insert tab, locate the Links
group and click link.2. In the dialog box, in the Address text field enter:
www.fusiontomo.com. Click OK
Create a new worksheet based on the Expense Report sample template.
1. Click the File tab, select New. 2. Select Expense Report,from the list of templates,
and click Create.
Note: you may need to Search for online templates to find the Expense Report sample
template.
Change the theme of the current worksheet to Ion.
1. In the Page Layout tab, locate the Themes group, clickThemes, and select Ion from
the dropdown.
Apply the Built-in theme Ion to the current worksheet.
1. In the Page Layout tab, locate the Themes group, click Themes, and in the drop
down menu click Ion.
Delete all of the comments in the current worksheet.
1. Highlight cell A1. In theReview tab, go to theComments group and clickNext.2. For
each comment, click the Delete button in theComments group.
Change the Theme to Office.
1. In the Page Layout tab, go to the Themes group, click Themes and in the drop down
click Office.
In the Source Data worksheet use find & select to find the cell that contains Data
Validation, and clear the validation.
1. In the Source Data worksheet, in the Hometab, locate the Editing group, click the
Find & Select dropdown, and click Data Validation.2. With cell B2 selected, click the
Datatab, locate the Data Tools group, select Data Validation and click Data
Validation...3. In the dialog box, click Clear All, then clickOK.
Change the margins to the Narrow setting.
1. In the Page Layout tab, locate thePage Setup group, click the Marginsdropdown, and
select Narrow.
Create a hyperlink in the cell B12 that links to the file EXCEL07.xlsx.in the
GMetrixTemplatesfolder.
,1. In Cell B12, click the Insert tab, locate the Links group, and click Links.2. In the
Address box, type EXCEL07.xlsx, and click OK.3. Optionally, click on the file inside the
GMetrixTemplates folder called EXCEL07.xlsx and click OK.
In the Loan Amortization Scheduleworksheet, add the following comment to cell
D6: Good Rate.
1. Select cell D6. Click theReview tab, locate theComments group, and clickNew
Comment.2. In the new comment, type the words Good Rate. Click out of the comment
when finished.
Change the margins to the Narrowsetting.
1. In the Page Layout tab, locate the Page Setupgroup, click the Marginsdropdown, and
selectNarrow.
Move the entire Loan Amortization Scheduleworksheet in the
EXCEL07.xlsxworkbook located in the GMetrixTemplates folder and insert it after
the Time Cardworksheet in the EXCEL06.xlsxworkbook.
In the File tab, click on Open and click Browse (you might need to select Computer first
if Browse isn't immediately available). In the dialog window, go to your documents
folder. In the GMetrixTemplates folder, select EXCEL07.xlsx and click Open.
In the EXCEL07.xlsx workbook, right click the Loan Amortization Scheduleworksheet,
select Move or Copy.
In the Move or Copy window, in the To book drop down select EXCEL06.xlsx, in the
Before sheet section select move to end and click OK.
In the Time Card worksheet, add a header that uses the Current Date format in the
left header field and Page Number in the right header field. Add the Sheet Name
to the left footer field.
1. In the Time Card worksheet, in the Insert tab, go to the Text group and click Header
& Footer2. In the Header click into the left field, in the Design tab, go to the Header &
Footer contextual tab and click Current Date.3. In the Header click into the right field, in
the Design tab, go to the Header & Footer contextual tab and click Page Number.4. In
the Footer click into the left field, in the Design tab, go to the Header & Footer
contextual tab and click Sheet Name and click out of the Header & Footer and into the
sheet.(Note: If the Footer does not appear, change the Workbook View to Normal in the
View tab and try again.)
Color each of the worksheet tabs: Expenses, Income and Profit - Loss Summary
to have a different color.
1. Right click on the Expenses worksheet tab, select Tab color and pick a color.2. Right
click on the Incomeworksheet tab, select Tab color and pick a color.3. Right click on the
Profit - Loss Summary worksheet tab, select Tab color and pick a color.
In the Marketing Budget Plan Worksheet, use the Go To Specialtool looking for
Comments and Delete the comment.
1. In the Marketing Budget Plan worksheet, go the the Home tab, locate the Editing
group, select theFind and Select option, and click Go To Special.2. In the Go To
Specialdialog box, select Notes, and click OK.3. Cell A62 should be auto selected. Go
to the Reviewtab, locate the Commentsgroup, and click Delete.
In the Budget Plan Chart worksheet, add to the note in cell A40 to say PowerPoint
information instead of just being a blank note.
,1. Select cell A40. In the Review tab, locate the Notes group, and click Notes then Edit
Note.2. Enter PowerPoint information into the note and click out of the note.
In the Marketing Budget Plan worksheet, remove the hyperlink attached to the
title Fusion Tomo Marketing Budget Plan.
1. Select cell range A1:E1. In the Insert tab, locate the Links group, and click Links.2. In
the Edit Hyperlink Dialog box, click Remove Link.
In the Expenses worksheet in cell F2 with the contents Budget Document, create
a Hyperlink that creates a new document called TomoCon Budget and Edit the
new document later.
1. In the Expenses worksheet, select cell F2 that contains the contents Budget
Document.2. In the Insert tab, go to the Links group and click Links.3. In the Insert
Hyperlink dialog box, click the Create New Document, and name the document
TomoCon Budget, check the Edit the new document later button and click Ok.
Inspect the document and remove only the Comments and Annotations. (Close
the dialog box once you have completed the task)
1. In the File tab, go to the Info group, select the Check for Issues drop down box and
click Inspect Document.2. In the Document Inspector window, make sure everything is
checked and click Inspect.3. Next to the Comments and Annotations group click
Remove All, and click Close.
Create a new worksheet called Cover Page, and position it before the Mileage Log
worksheet.
1. Next to the Mileage Logworksheet, click the New Sheetbutton.2. In the Home tab, go
to the Cells group, click the Formatdrop down and select Rename Sheet and type Cover
Page. Press Enter.3. Click and drag the Cover Page worksheet to be in front of the
Mileage Log worksheet.
In the Mileage Log worksheet, use the Find and Replace tool to find all
occurrences of Personal and replace them with Client
1. In the Mileage Logworksheet, in the Hometab, go to the Editinggroup, click the Find &
Select tool and selectReplace2. In the Find and Replacewindow, in the Find whatfield
enter Personal and in the Replace with field enter Client and clickReplace All. Click OK
and click Close.
Insert a footer at the bottom that contains the author, page number, and current
date in that order.
In the View tab, locate the Workbook Views group and click Page Layout.
Place your cursor anywhere in the header or footer to make the Header & Footer
contextual tab show.
In the Header & Footer contextual tab, locate the Header & Footergroup and click the
Footerdropdown.
Select the option that includes the author's name, page number, and current date in that
order.
Insert a new worksheet named 2009 Sales (Corrected) between the 2009 Sales
and 2010 Sales worksheets.
1. Select the 2010 Salesworksheet. 2. In the Home tab, Cells group, select the drop
down for Insert. Select Insert Sheet.3. Double-click on the new worksheet's tab named
Sheet1.4. Type 2009 Sales (Corrected)and hit the ENTER key.
, In the Summary worksheet, link the text 2009 Sales to the 2009 Sales worksheet
and 2010 Sales to the 2010 Sales worksheet.
1. Open the Summaryworksheet.2. Select cell A28.3. In the Insert tab, Links group,
select Links.4. Under Link to, choose Place in This Document.5. Under the Cell
Referencecategory, in the Or select a place in this document list box, click on the text
'2009 Sales'.6. Click Ok.7. Select cell A29.8. Repeat steps 3 and 4.9. Under the Cell
Reference category, in the Or select a place in this document list box, click on the text
'2010 Sales'.10. Click OK.
In the Summary worksheet, apply a hyperlink to If you have any questions, please
email the sales department, with the e-mail address sales@verigon.com and
subject Sales Summary.
1. Open the Summaryworksheet.2. Select cell A30.3. In the Insert tab, Linksgroup,
select Links.4. In the Link section, select Email Address.5. For Email Address, type
sales@verigon.com. For Subject, type Sales Summary.6. Click Ok.
Copy the Summary worksheet from the
Quarterly_Earnings_Overview.xlsxworkbook, found in your GMetrix Templates
folder, and place it as the last worksheet in the Quarterly_Earnings.xlsxworkbook.
1. In the File tab choose Open. 2. Choose theQuarterly_Earnings_Overview.xlsx from
youGMetrix Templates folder and click the Openbutton.3. In the Home tab, Cells group,
click theFormat button. Under Organize Sheet, selectMove or Copy Sheet... 4. In the To
book drop down, chooseQuarterly_Earnings.xlsx, in the Before sheetlist, select (move
to end).5. Select the Create a copy check box and clickOK.
Set the tab color of the Summaryworksheet to Red, Accent 2, Lighter 40%.
1. Open the Summaryworksheet.2. In the Home tab, Cellsgroup, click the Formatbutton.
Under Organize Sheets, select Tab Color > Theme Colors > Red, Accent 2, Lighter
40%.
Remove the comment on cell A2and replace it with the note Redundant variants
removed.
1. Click on cell A2.2. In the Review tab, Comments group, click the Delete button.3. In
the Review tab, Notes group, click Notes then New Note button.4. Type Redundant
variants removed note.
Open the 111-instructors.txt file from the GMetrixTemplates folder. Indicate that
the data has headers. Tabs are the delimiters.
Click the File tab
Ensure the Open tab is selected
Browse to the GMetrixTemplates folder
Click the File type drop-down arrow
Click All Files
Click the 111-instructors.txt file
Click the Open button
Ensure that the My data has headers check box is selected
Click the Next button
Ensure that the Tab check box is the only delimiter check box selected
Click the Next button
Click the Finish button
