+1(978)310-4246 credencewriters@gmail.com
  

Description

I have attached the instructions you need to follow and the excel you need to do all of the steps on.

Thanks so much!

If I get a 90%+ I always give tips!

New Perspectives Excel 2013
Tutorial 12: SAM Project 1a
Highland Community Preschool
COLLABORATING ON A SHARED WORKBOOK
Project Goal
PROJECT DESCRIPTION
M Project Name
Highland Community Preschool, a local non-profit nursery school, held its annual “Casino
Night” fundraising event last weekend. Becca Gerner, the Chairperson of the Fundraising
Committee for the school, generated a workbook to track the expenses and income from the
Project Goal
event and shared that workbook with the committee to get their feedback. She asked for
your help consolidating the information provided by the board members into her original
workbook. Becca has already received feedback from Abraham Miller, but will need you to
merge the edited workbooks from Stephanie Lorenz and Kevin Staszowski and then review
the changes made by the board members. After addressing all the suggested changes, you
will prepare the workbook for a final review by Becca Gerner.
GETTING STARTED
•
Download the following files from the SAM website:
o
•
•
NP_Excel2013_T12_P1a_FirstLastName_1.xlsx
Open the file you just downloaded and save it with the name:
o
NP_Excel2013_T12_P1a_FirstLastName_2.xlsx
o
Hint: If you do not see the .xlsx file extension in the Save file dialog box, do
not type it. Excel 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_E13_T12_P1a_ksnotes.xlsx
o
support_NP_E13_T12_P1a_slnotes.xlsx
•
Open files NP_Excel2013_T12_P1a_FirstLastName_2.xlsx. Ensure that your
first and last name is displayed in cell B6 of the Documentation sheet. 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 will need to add the Compare and Merge
Workbooks button to the Quick Access Toolbar. To add this button to the Quick
Access toolbar, complete the following set of instructions:
o
In the Quick Access Toolbar, click the Customize Quick Access Toolbar
button and select the More Commands option from the drop-down menu.
o
In the Excel Options dialog box, select the Commands Not in the Ribbon
option from the drop-down menu associated with the Choose commands
from: option.
New Perspectives Excel 2013| Tutorial 12: SAM Project 1a
o
Find the Compare and Merge Workbooks option from the list of
commands. Click on this command and click the Add button. The Compare
and Merge Workbooks option should be the last item in the Quick Access
Toolbar.
o
Click the OK button to close the Excel Options dialog box.
PROJECT STEPS
1. Using the Compare and Merge Workbooks option, perform the following
steps:
a. Merge the support_NP_E13_T12_P1a_slnotes.xlsx workbook
into the NP_Excel2013_T12_P1a_FirstLastName_2.xlsx
workbook.
b. Merge the support_NP_E13_T12_P1a_ksnotes.xlsx workbook
into the NP_Excel2013_T12_P1a_FirstLastName_2.xlsx
workbook.
For Steps 2-12, you will be accepting or rejecting the changes in the workbook as described
below.
2. Go to the Overview worksheet. Using the Accept/Reject Changes option, review
the changes made in the range A1:F16 of the Overview worksheet (Hint:
Confirm your Select Changes to Accept or Reject dialog box matches Figure 1
before proceeding).
Figure 1: Overview Worksheet – Select Changes to Accept or Reject Dialog Box
Microsoft product screenshot reprinted with permission from Microsoft
Incorporated. Copyright © 2014 Cengage Learning. All Rights Reserved.
On the Overview worksheet, accept the change made by Stephanie Lorenz to
cell B2.
3. On the Overview worksheet, reject the change made in cell C12.
4. On the Overview worksheet, accept the change made in cell D12.
5. Go to the Income worksheet. Using the Accept/Reject Changes option, review the
changes made in the range A1:P34 of the Income worksheet (Hint: Confirm your
Select Changes to Accept or Reject dialog box matches Figure 2 before
proceeding).
New Perspectives Excel 2013| Tutorial 12: SAM Project 1a
Figure 2: Income Worksheet – Select Changes to Accept or Reject Dialog Box
Copyright © 2014 Cengage Learning. All Rights Reserved.
On the Income worksheet, accept the change made by Stephanie Lorenz to
the cell B2.
6. On the Income worksheet, accept the change made in cell C7.
7. On the Income worksheet, accept the change made in cell H11.
8. On the Income worksheet, accept the change made in cell O11.
9. Go to the Expenses worksheet. Using the Accept/Reject Changes option, review
the changes made in the range A1:H14 of the Expenses worksheet (Hint:
Confirm your Select Changes to Accept or Reject dialog box matches Figure 3
before proceeding).
Figure 3: Expenses Worksheet – Select Changes to Accept or Reject Dialog Box
Copyright © 2014 Cengage Learning. All Rights Reserved.
On the Expenses worksheet, accept the change made by Stephanie Lorenz to
cell B2.
10. On the Expenses worksheet, accept the change made in cell B6 by Abraham
Miller.
11. On the Expenses worksheet, reject the change made in cell D10.
New Perspectives Excel 2013| Tutorial 12: SAM Project 1a
12. On the Expenses worksheet, reject the change made in cell C5 and then turn
off workbook sharing, clicking yes when prompted with a warning message.
13. Go to the Overview worksheet. Delete the four (4) comments made by
Abraham Miller from this worksheet. Do not delete the comments made by
Stephanie Lorenz or Kevin Staszowski (Hint: Use the Show/Hide Comment option
to quickly identify all the comments).
14. Go to the Income worksheet. Delete all comments in this worksheet.
15. Go to the Expenses worksheet. Delete only the comments associated with cell
B2, B6, and D10.
16. 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).
17. Add the following document properties to the workbook:
a. Title: Casino Night Fundraiser
b. Tags: Casino Night; Fundraiser
Hint: This field may also be called Keywords, depending on how
you access the document properties of the workbook.
c. Comments: Final Review draft of the Casino Night Fundraiser
report for 2016
d. Status: Final Review Draft
18.
19.
Add a custom Document property to the worksheet with the name Checked
By, the Text data type (which is the default for this property), and the value
AM, SL, KS.
Mark the workbook as Final. Save and close the workbook.
Your workbook should look like the Final Figure on the following page. Note that the
‘Show all comments’ option is selected for the worksheets shown in the Final Figure.
Save your changes, close the workbook, and exit Excel. Follow the directions on the SAM
website to submit your completed project.
New Perspectives Excel 2013| Tutorial 12: SAM Project 1a
Final Figure 1: Overview Worksheet
Microsoft product screenshot reprinted with permission from Microsoft
Incorporated. Copyright © 2014 Cengage Learning. All Rights Reserved.
New Perspectives Excel 2013| Tutorial 12: SAM Project 1a
Final Figure 2: Income Worksheet
Copyright © 2014 Cengage Learning. All Rights Reserved.
New Perspectives Excel 2013| Tutorial 12: SAM Project 1a
Final Figure 3: Expenses Worksheet
Copyright © 2014 Cengage Learning. All Rights Reserved.
New Perspectives Excel 2013
Tutorial 12: SAM Project 1a
Highland Community Preschool
COLLABORATING ON A SHARED WORKBOOK
Author: Kimberly Mejia
Note: Do not edit this sheet. If your name does not appear in cell B6,
please download a new copy of the file from the SAM website.
CASINO NIGHT
EVENT GOAL
$4,000.00
EVENT INCOME
EXPENSES
TOTAL RAISED
OVER/UNDER
Goal
$4,500
$500
$4,000
$0
Actual
$7,255
$696
$6,559
$2,559
WE EXCEEDED OUR EXPECTATIONS!
$6,559
$4,000
Goal
Actual
CASINO NIGHT – INCOME
TICKET SALES
$2,600
SILENT AUCTION $3,885
RAFFLE
$220
POKER CHIPS
$550
TOTAL RAISED
$7,255
TICKET SALES
PADDLE #
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
QTY
4
6
2
4
2
1
2
2
2
4
2
1
2
1
4
1
2
2
2
2
2
2
SILENT AUCTION
$TOTAL
200
300
100
200
100
50
100
100
100
200
100
50
100
50
200
50
100
100
100
100
100
100
$2,600
ITEM
Dinner for 4
Harbor cruise
Hand-knit sweater
Manicure
Framed Art
Beaded necklace
Pearl earrings
Kayak trip
Car detail
Vacation house
Classroom 1 Art piece
Classroom 2 Art piece
Overnight babysitting
PADDLE #
4
14
2
9
22
13
22
5
8
11
6
17
21
$TOTAL
200
150
75
25
250
50
100
100
50
1000
750
660
475
$3,885
RAFFLE TICKETS
PADDLE # QTY
15
6
4
15
7
15
19
35
22
6
3
35
14
6
9
35
13
15
6
35
9
6
2
15
20
35
19
35
6
15
5
6
3
15
18
6
17
15
$TOTAL
5
10
10
20
5
20
5
20
10
20
5
10
20
20
10
5
10
5
10
$220
POKER CHIPS
PADDLE #
16
21
3
6
9
8
21
3
13
17
18
4
7
3
QTY
100
100
100
100
100
50
50
100
50
50
50
100
50
100
$TOTAL
50
50
50
50
50
25
25
50
25
25
25
50
25
50
$550
CASINO NIGHT – EXPENSES
EXPENSES
NAME
Harringson
Watson
Gonzales
Mehta
Harrington
EXPENSE
Copies
Decorations
Food
Hall rental fee
Auctioneer
TOTAL
$35
$61
$150
$250
$200
$696
Casino Night Expenses
Copies
Decorations
Food
Hall rental fee
Auctioneer
New Perspectives Excel 2013
Tutorial 12: SAM Project 1a
Highland Community Preschool
COLLABORATING ON A SHARED WORKBOOK
Author: %FirstName% %LastName%
Note: Do not edit this sheet. If your name does not appear in cell B6,
please download a new copy of the file from the SAM website.
CASINO NIGHTFUNDRAISER
EVENT GOAL
$4,000.00
EVENT INCOME
EXPENSES
TOTAL RAISED
OVER/UNDER
Goal
$4,500
$500
$4,000

Actual
$6,655
$596
$6,059
$1,559
WE EXCEEDED OUR EXPECTATIONS!
$6,059
$4,000
Goal
Actual
CASINO NIGHTFUNDRAIER – INCOME
TICKET SALES
$2,600
SILENT AUCTION $3,835
RAFFLE
$220
POKER CHIPS
$525
TOTAL RAISED
$6,655
TICKET SALES
PADDLE #
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
QTY
4
6
2
4
2
1
2
2
2
4
2
1
2
1
4
1
2
2
2
2
2
2
SILENT AUCTION
$TOTAL
200
300
100
200
100
50
100
100
100
200
100
50
100
50
200
50
100
100
100
100
100
100
$2,600
ITEM
Dinner for 4
Harbor cruise
Hand-knit sweater
Manicure
Framed Art
Beaded necklace
Pearl earrings
Kayak trip
Car detail
Vacation house
Classroom 1 Art piece
Classroom 2 Art piece
Overnight babysitting
PADDLE #
4
14
2
9
22
13
22
5
8
11
6
17
21
$TOTAL
150
150
75
25
250
50
100
100
50
1000
750
660
475
$3,835
INCOME
RAFFLE TICKETS
PADDLE # QTY
15
6
4
15
7
15
19
35
22
6
3
35
14
6
9
35
13
15
6
35
9
6
2
15
20
35
19
35
6
15
5
6
3
15
18
6
17
15
$TOTAL
5
10
10
20
5
20
5
20
10
20
5
10
20
20
10
5
10
5
10
$220
POKER CHIPS
PADDLE #
16
21
3
6
9
8
21
3
13
17
18
4
7
3
QTY
50
100
100
100
100
50
50
100
50
50
50
100
50
100
$TOTAL
25
50
50
50
50
25
25
50
25
25
25
50
25
50
$525
CASINO NIGHT FUNDRASER – EXPENSE
EXPENSES
NAME
Harrington
Watson
Gonzales
Mehta
Harrington
EXPENSES
Copies
Decorations
Food
Hall rental fee
Auctioneer
TOTAL
$35
$61
$150
$250
$100
$596
Casino Night Expenses
Copies
Decorations
Food
Hall rental fee
Auctioneer
Notes:
Copies
Expected
Actual
in Sarah’s office
$40
$35
Purchase answer to see full
attachment

  
error: Content is protected !!