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

Completion Status 100%