GMETRIX REVIEW EXCEL UPDATED
Exam Questions and CORRECT Answers
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. -
CORRECT ANSWER- 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. - CORRECT ANSWER- 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. - CORRECT ANSWER- 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. - CORRECT
ANSWER- 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. - CORRECT ANSWER- 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. - CORRECT ANSWER- 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. - CORRECT ANSWER- 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. - CORRECT ANSWER- 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. - CORRECT ANSWER- 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. - CORRECT ANSWER- 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. - CORRECT ANSWER- 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. - CORRECT ANSWER- 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. - CORRECT ANSWER- 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. - CORRECT ANSWER- 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. -
CORRECT ANSWER- 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. - CORRECT ANSWER- 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. - CORRECT ANSWER- 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. - CORRECT ANSWER- 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. - CORRECT ANSWER- 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. -
CORRECT ANSWER- 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) - CORRECT ANSWER- 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.
- CORRECT ANSWER- 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 - CORRECT ANSWER- 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. - CORRECT ANSWER- 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. - CORRECT ANSWER- 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. - CORRECT ANSWER- 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.
Exam Questions and CORRECT Answers
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. -
CORRECT ANSWER- 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. - CORRECT ANSWER- 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. - CORRECT ANSWER- 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. - CORRECT
ANSWER- 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. - CORRECT ANSWER- 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. - CORRECT ANSWER- 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. - CORRECT ANSWER- 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. - CORRECT ANSWER- 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. - CORRECT ANSWER- 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. - CORRECT ANSWER- 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. - CORRECT ANSWER- 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. - CORRECT ANSWER- 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. - CORRECT ANSWER- 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. - CORRECT ANSWER- 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. -
CORRECT ANSWER- 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. - CORRECT ANSWER- 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. - CORRECT ANSWER- 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. - CORRECT ANSWER- 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. - CORRECT ANSWER- 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. -
CORRECT ANSWER- 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) - CORRECT ANSWER- 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.
- CORRECT ANSWER- 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 - CORRECT ANSWER- 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. - CORRECT ANSWER- 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. - CORRECT ANSWER- 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. - CORRECT ANSWER- 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.
