ComputerScienceExpert

(11)

$18/per page/

About ComputerScienceExpert

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Applied Sciences,Calculus See all
Applied Sciences,Calculus,Chemistry,Computer Science,Environmental science,Information Systems,Science Hide all
Teaching Since: Apr 2017
Last Sign in: 103 Weeks Ago, 3 Days Ago
Questions Answered: 4870
Tutorials Posted: 4863

Education

  • MBA IT, Mater in Science and Technology
    Devry
    Jul-1996 - Jul-2000

Experience

  • Professor
    Devry University
    Mar-2010 - Oct-2016

Category > Programming Posted 08 May 2017 My Price 8.00

Collaboration and Workbook Distribution

Please fill this out and follow these directions below:

 

Collaboration and Workbook Distribution

 

Project Description:

You are an assistant sales manager for a contractor who builds custom houses. Your job is to prepare initial estimates for people who want to purchase a lot and build a house in the development community. As you prepare plans, you get feedback from the office manager, incorporate changes, and finalize the workbook to distribute to potential buyers.

 

Instructions:

For the purpose of grading the project you are required to perform the following tasks:

Step

Instructions

Points Possible

1

Enter your name as the user name in the Excel Options dialog box if necessary. Add the E-mail command to the Quick Access Toolbar. Add the Compare and Merge Workbooks command to the Quick Access Toolbar, if necessary. Open exploring_e11_grader_a1.xlsx, and then save it as e11c2House_ LastFirst replacing LastFirst with your name.

0

2

Display the Backstage view and add the Author name Student. Enter Grader 02 as the Title property.

5

3

Compare and merge e11c2Anthony.xlsx into your workbook. Delete the Trees row, change the Fence value to $2,735.80, and then save the workbook.

17

4

Activate the Change Tracking feature, highlight all changes, and then create a History worksheet. Open the Select Changes to Accept or Reject dialog box, and then deselect all check boxes. Accept the first change in the workbook. Reject the second change in cell B7, and then continue to accept the remaining changes in the document.

30

5

Insert a comment in cell B15 that Additional upgrades will increase the cost. (include the period).

8

6

Insert a comment in cell B27 that The estimate is subject to change based on market changes prior to signing a contract. (include the period).

8

7

Turn off workbook sharing, and then save the workbook. Run the Accessibility Checker, identify potential problems, and then fix the warning issues detected. Close the Accessibility Checker task pane. Run the Compatibility Checker, correct any significant loss of fidelity issues if any, and ignore any minor loss of fidelity issues.

10

8

Insert a footer with the sheet name code in the center, and the file name code on the right side.

5

9

Add a Microsoft Office Signature Line with the name Exploring Series Student.

7

10

Mark the workbook as final.

10

11

Save the file and close Excel. Submit the e11c2House_ LastFirst.xlsx file as directed.

0

 

Total Points

100

 

Page1of1View_Ch11_Grader_Assessment_solution_Exploring Excel.docxEXPLORINGEXCEL–CHAPTERELEVEN–GRADERASSESSMENTEstimates WorksheetDirection # 11“Save the workbook. Close the workbook and then exit Excel…..”Theworkbook gets saved when you “Mark as final” – so you can’t save it again.

Attachments:

Answers

ComputerScienceExpert
(11)
Status NEW Posted 08 May 2017 02:05 AM My Price 8.00

-----------

Attachments

file 1494210741-Solutions file 2.docx preview (51 words )
H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------
Not Rated(0)