question archive New Perspectives Excel 2013 Tutorial 12: SAM Project 1a 1
New Perspectives Excel 2013 Tutorial 12: SAM Project 1a 1
Subject:MS ExcelPrice:19.87 Bought3
New Perspectives Excel 2013 Tutorial 12: SAM Project 1a
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.
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). 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). 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). 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.
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.
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.
19.
Mark the workbook as Final. Save and close the workbook.
Option 1
Low Cost Option
Download this past answer in few clicks
19.87 USD
PURCHASE SOLUTION
Option 2
Custom new solution created by our subject matter experts
GET A QUOTE
rated 5 stars
Purchased 3 times
