Problem tuition Case Solution (Excel)

 

Don't use plagiarized sources. Get Your Custom Essay on
Problem tuition Case Solution (Excel)
For as low as $13/Page
Order Essay

3. In the October 31 sheet, format cells A1:A4 with bold, italic, with font size of 14, and merge and center to column H.

4. Any student worker who works 20 hours or less will have the pay applied to his or her tuition. If a student works more than 20 hours (referenced in cell F7), then the student will receive a paycheck for any hours over 20. In cell D11, construct an IF function to determine the number of hours worked that will be applied to the student’s tuition, using cell F7 as an absolute reference. Copy the formula down through D16.

5. In cell E11, construct an IF function to determine the number of hours worked that will be applied to the student’s paycheck, using cell F7 as an absolute reference. Copy the formula down through E16.

6. In cell F11, construct a formula to determine the total pay by multiplying the total hours worked (in cell C11) by the hourly pay (in cell F6). Be sure to use an absolute reference. Copy the formula down through F16.

7. In cell G11, construct a formula to determine the tuition pay by multiplying the Hours Applied to Tuition (in cell D11) by the hourly pay (in cell F6). Be sure to use an absolute reference. Copy the formula down through G16.

8. In cell H11, construct a formula to determine the Gross Paycheck by multiplying the Hours Applied to Paycheck (in cell E11) by the hourly pay (in cell F6). Be sure to use an absolute reference. Copy the formula down through H16.

9. In cell C17, use the AutoSum function to find the total of C11:C16. Copy the formula across through H17.

10. In cells C17:H17, apply a top and double bottom border.

11. In cells F11:H11 and F17:H17, apply the Accounting style format with two decimals. In cells F12:H16, apply the Comma style format with two decimal places.

12. In the October Summary sheet, format cells A1:A3 with bold, italic, with font size of 14, and merge and center to column N.

13. In cell K8, use a formula that refers to the original cell on the October 31 sheet in cell F11. Copy the formula across through column M and then down through row 14.

14. In cell N8, enter a formula that sums the Gross Paycheck amounts for each week. Copy the formula down through N14. Apply a top and double bottom border to cells K14:N14.

15. In cell D17, create an IF function that will determine those student workers who will receive a paycheck and those who will not receive a paycheck. If the amount in the Total

 

 

Gross Paycheck is greater than 0, then enter the text Paycheck. If it is not greater than 0, then enter the text None. Copy the formula down through D22.

NOTE: See If Example below.

16. Apply Highlight Cells Rules conditional formatting to the range D17:D22. If the cell has the text Paycheck, highlight the cell with Green Fill with Dark Green Text. If the cell has the text None, highlight the cell with Light Red Fill with Dark Red Text.

17. Apply Highlight Cells Rules conditional formatting to the range N8:N13. If the cell is greater than 0, highlight the cell with Green Fill with Dark Green Text. If the cell is equal to 0, highlight the cell with Light Red Fill with Dark Red Text.

18. On the October 31 worksheet, Apply the Oriel theme to cells A1:H4. Apply the fill color Light Yellow, Background 2. Apply the font color Red, Accent 3.

19. On the October Summary worksheet, in cells A1:N3, apply the fill color Light Yellow, Background 2. Apply the font color Red, Accent 3.

20. With the worksheets grouped, add the file name to the left footer and the worksheet name to the right footer.

21. Change the page layout to landscape, fit to 1 page wide by 1 tall, and center the data horizontally and vertically on the page.

22. Save your workbook.

23. Complete the assignments by compressing folder by:

a. right-clicking on folder

b. move mouse pointer to Send To

c. Click Compressed (zipped) Folder

24. Send to Blackboard by mid-night February 6

 

(Scroll down for more IF example)

IF Example:

IF(logical_test,value_if_true,value_if_false)

 Cell containing value to be tested

 Cell containing value to use if TRUE

 Cell containing value to use if FALSE

Student Name

Department

Hours Worked

Hours Applied to Tuition

Hours Applied to Paycheck

Jim Brown

Library

18

18

0

Jane Long

Student Union

39

20

19

 

 

Place your order
(550 words)

Approximate price: $22

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
error: Content is protected !!
Live Chat 1 763 309 4299EmailWhatsApp

Order your essay today and save 20% with the discount code WELCOME