Excel homework | Computer Science homework help

1

Start Excel. Download and open the workbook named GO_e04_Grader_h3.xlsx.

0

2

Click the Warehouse Payment Table sheet. In cell B8, enter a PMT function using cell B4 divided by 12 as the rate, B3 as the number of payment periods, and B2 as the present value of the loan. Display the result as a positive number.

10

3

In the range B8:H16, create a two-variable data table. Set B3 as the row input cell, and B4 as the column input cell.

10

4

Apply the Currency number format to cells C9:H16.

3

5

Apply the cell style Note to the payment in cell E9.

2

6

On the Job Information sheet, select the range A4:C11. Sort the range by the Job Code column in ascending order.

5

7

Create a range named Job_Code using the data in cells A5:A11 on the Job Information worksheet.

5

8

On the Staffing Plan worksheet, in cells A9:A18, set a Data Validation rule that allows values from a list to be entered in this cell. Set the source to =Job_Code. From the newly created Data Validation list in cell A9, select M-MG.

10

9

On the Staffing Plan worksheet, in cell B9, create a VLOOKUP function that will look up the Description from the Job Information sheet using the Job Code. Use absolute cell references as necessary.

10

10

Copy the function in B9 down through cell B18.

3

11

In cell C9, enter 1 as the # of Positions; in D9, enter Management as the Type.

4

12

On the Staffing Plan worksheet, in cell E9, create a VLOOKUP function that will look up the Salary from the Job Information sheet using the Job Code. Use absolute cell references as necessary.

10

13

Copy the function in E9 down through cell E18.

3

14

From the Data Validation drop-down list in cell A10, select C-CASH. In cell C10, enter 4 as the # of Positions; in D10, enter Cashier as the Type.

4

15

Display the Revenue worksheet and trace the precedents for the formula in cell I5. Use the Error Checking dialog box to correct the error in the cell so that the formula is using the Growth Assumption for Beaded Bracelets, not for Crystal Bracelets.

6

16

Resume error checking. When detected, correct the error in cell M6 so that the formula references cell L9 instead of L10. Ensure that the reference to L9 is an absolute reference.

5

17

Resume error checking. When detected, correct the error in cell F7 by copying the formula from the cell above. Continue error checking and correct the error in cell J8 by copying the formula from the cell on the left.

5

18

Use Format Painter to copy the format in cell M5 to M6.

5

19

Ensure that the worksheets are correctly named and placed in the following order in the workbook:  Warehouse Purchase, Warehouse Payment Table, Staffing Plan, Job Information, Revenue. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.

0

 

Total Points

100

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more