Alamance Community College Historic Maryland Experience Project the project must follow all the steps and it will be revised one time if the grade is 90 or

Alamance Community College Historic Maryland Experience Project the project must follow all the steps and it will be revised one time if the grade is 90 or higher it will be fine but if not I am allowed to turn it in one more time and it will have to be check again with the results report. New Perspectives Excel 2016 | Module 12: SAM Project 1a
Historic Maryland Experience
COLLABORATING ON A SHARED WORKBOOK
GETTING STARTED
•
Open the file NP_EX16_12a_FirstLastName_1.xlsx, available for download
from the SAM website.
•
Save the file as NP_EX16_12a_FirstLastName_2.xlsx by changing the “1”
to a “2”.
o
•
If you do not see the .xlsx file extension in the Save As dialog box, do
not type it. The program will add the file extension for you automatically.
To complete this SAM Project, you will also need to download and save the
following data files from the SAM website onto your computer:
o
Support_NP_EX16_12a_Wilson.xlsx
o
Support_NP_EX16_12a_Yang.xlsx
NOTE: Do not open the support files as you may not be able to merge them.
•
With the file NP_EX16_12a_FirstLastName_2.xlsx still open, ensure that
your first and last name is displayed in cell B6 of the Documentation sheet.
o
•
If cell B6 does not display your name, delete the file and download a new
copy from the SAM website.
To complete this project, you need to add the Compare and Merge Workbooks
button to the Quick Access Toolbar as follows:
o
On the Quick Access Toolbar, click the Customize Quick Access Toolbar
button, and then click More Commands.
o
In the Excel Options dialog box, click the Choose commands from arrow,
and then click Commands Not in the Ribbon.
o
In the list of commands, click Compare and Merge Workbooks, and then
click the Add button.
o
Click the OK button to close the Excel Options dialog box.
PROJECT STEPS
1.
You are an assistant at the Historic Maryland Experience, a nonprofit
organization in Baltimore, Maryland, that sponsors tours and other activities to
engage visitors in the colonial history of the area. George Shaw, the executive
director, created a workbook to automate customer invoices, and then shared
the workbook with the staff for their review. He asked for your help
consolidating the staff’s changes and comments into his original workbook. He
already received feedback from Emily Legrey, and now needs to include
New Perspectives Excel 2016 | Module 12: SAM Project 1a
changes and comments from Jared Wilson and Kendra Yang. He also wants you
to prepare the workbook for his final review.
Use the Compare and Merge Workbooks feature to include comments and
changes from reviewers as follows:
2.
a.
Merge the Support_NP_EX16_12a_Wilson.xlsx workbook, available
from the SAM website, into the NP_EX16_12a_FirstLastName_2.xlsx
workbook.
b.
Merge the Support_NP_EX16_12a_Yang.xlsx workbook, available
from the SAM website, into the NP_EX16_12a_FirstLastName_2.xlsx
workbook.
Switch to the Invoice worksheet. Begin to review the comments in the
workbook. Respond to the comment from Kendra Yang in cell F3 as follows:
a.
Change the text in the range F3:F5 to the Automatic color.
b.
Delete the comment in cell F3.
3.
Review the next comment in the workbook, which is from Kendra Yang in cell
F8. Edit the comment by including Yes as the response.
4.
Review the next comment, which is from Emily Legrey in cell A12, and then
delete it.
5.
Review and respond to the next comment, which is from Kendra Yang in cell
A13, as follows:
a.
Delete the comment in cell A13.
b.
Change the text in the range A13:C13 to the Automatic color.
6.
Review the next comment, which is from Jared Wilson in cell B19, and then
delete it.
7.
Using the Accept/Reject Changes command, specify that you want to review
the changes made in the range A2:J23. Do not specify when or who made the
changes.
a.
Accept the change made by Jared Wilson in cell B19.
b.
Accept only the change made by Kendra Yang in cell F20.
Turn off workbook sharing. (Hint: Click Yes when prompted by the warning
message.)
8.
9.
Switch to the Customer Data worksheet. Review and respond to the next
comment, which is from Emily Legrey in cell B1, as follows:
a.
Delete the comment in cell B1.
b.
Insert a row above the first row.
c.
In cell A1, enter Weekly Sales Data as the worksheet title.
d.
Apply the Title cell style to the new title.
Delete the remaining comments on the Customer Data worksheet.
New Perspectives Excel 2016 | Module 12: SAM Project 1a
10.
Switch to the Invoice worksheet. In cell J6, use 7/4/2018 as the date instead
of 6/4/2018.
11.
Delete the hidden worksheet named Notes from the workbook. (Hint: If you use
the Document Inspector, do not delete the document properties or personal
information from the workbook.)
12.
Add the following document properties to the workbook:
a.
Title: HME Tour Invoices
b.
Tags: Invoices, Tickets, Customers
(Hint: This field might also be called “Keywords”, depending on how you
access the document properties of the workbook.)
c.
Comments: Final review draft of the workbook for generating
invoices
d.
Status: Final Review Draft
13.
Add a custom Document property with the name Checked by to the workbook.
Accept the default Text data type and use GS, EL, JW, KY as the value.
14.
Mark the workbook as Final.
Your workbook should look like the Final Figures on the following page. Save your
changes, close the workbook, and then exit Excel. Follow the directions on the SAM
website to submit your completed project.
New Perspectives Excel 2016 | Module 12: SAM Project 1a
Final Figure 1: Invoice Worksheet
Final Figure 2: Customer Data Worksheet
Author:
Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file f
New Perspectives Excel 2016 | Module 12: SAM Project 1a
Historic Maryland Experience
COLLABORATING ON A SHARED WORKBOOK
Luis Martinez
dit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website.
AM website.
Contact
Address
City State Zip
Phone
Vouchers
Program
Length
Shuttle tickets
Invoice Data
Ashley Clavette
2131 Willow St.
Laurel, MD 20707
(240) 555-2838
2
B
Full-day
2
Program Price Table
Program
Full-day
A
320
B
310
C
300
D
290
E
280
F
175
Invoice Constants
Handling
10
Shuttle Fee
15
Half-day
160
155
150
145
140
135
Historic Maryland Experience
24 Harbor Place
Baltimore, MD 21202
Date:
Contact
Address
City State Zip
Phone
Customer Invoice
Ashley Clavette
2131 Willow St.
Laurel, MD 20707
(240) 555-2838
Vouchers
Program
Length
2
B
Full-day
Program Cost
Handling
Shuttle
Total
2 Tickets
xperience
ce
21202
6/4/2018
ice
$
620.00
10.00
30.00
$
660.00
Customer Name
Melissa Falard
Beverly Harp
John Kanhei
Rafael Lazaro
Date
Nbr Tickets Ticket Amount Total Amount
6/2/2018
1
240
240
6/2/2018
3
600
663
6/2/2018
1
200
225
6/3/2018
3
600
600
Author:
Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file f
New Perspectives Excel 2016 | Module 12: SAM Project 1a
Historic Maryland Experience
COLLABORATING ON A SHARED WORKBOOK
%FirstName% %LastName%
dit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website.
AM website.
Contact
Address
City State Zip
Phone
Vouchers
Program
Length
Shuttle tickets
Invoice Data
Ashley Clavette
2131 Willow St.
Laurel, MD 20707
(240) 555-2838
2
B
Full-day
2
Program Price Table
Program
Full-day
A
320
B
310
C
300
D
290
E
280
F
175
Invoice Constants
Handling
10
Shuttle Fee
15
Half-day
160
155
150
145
140
135
Historic Maryland Experience
24 Harbor Place
Baltimore, MD 21202
Date:
Contact
Address
City State Zip
Phone
Customer Invoice
Ashley Clavette
2131 Willow St.
Laurel, MD 20707
(240) 555-2838
Vouchers
Program
Length
2
B
Full-day
Program Cost
Handling
Shuttle Fee
Total
2 Tickets
xperience
ce
21202
6/4/2018
ice
$
620,00
10,00
30,00
$
660,00
Customer Name
Melissa Falard
Beverly Harp
John Kanhei
Rafael Lazaro
Date
Nbr Tickets Ticket Amount Total Amount
6/2/2018
1
240
240
6/2/2018
3
600
663
6/2/2018
1
200
225
6/3/2018
3
600
600
Author:
Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file f
New Perspectives Excel 2016 | Module 12: SAM Project 1a
Historic Maryland Experience
COLLABORATING ON A SHARED WORKBOOK
%FirstName% %LastName%
dit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website.
AM website.
Contact
Address
City State Zip
Phone
Vouchers
Program
Length
Shuttle tickets
Invoice Data
Ashley Clavette
2131 Willow St.
Laurel, MD 20707
(240) 555-2838
2
B
Full-day
2
Program Price Table
Program
Full-day
A
320
B
310
C
300
D
290
E
280
F
270
Invoice Constants
Handling
10
Shuttle Fee
15
Half-day
160
155
150
145
140
135
Historic Maryland Experience
24 Harbor Place
Baltimore, MD 21202
Date:
Contact
Address
City State Zip
Phone
Customer Invoice
Ashley Clavette
2131 Willow St.
Laurel, MD 20707
(240) 555-2838
Vouchers
Program
Length
2
B
Full-day
Program Cost
Handling
Shuttle
Total
2 Tickets
xperience
ce
21202
6/4/2018
ice
$
620,00
10,00
30,00
$
660,00
Customer Name
Melissa Falard
Beverly Harp
John Kanhei
Rafael Lazaro
Date
Vouchers
6/2/2018
6/2/2018
6/2/2018
6/3/2018
1
3
1
3
Voucher Amount Total Amount
240
240
600
663
200
225
600
600

Purchase answer to see full
attachment