Answered step by step
Verified Expert Solution
Question
1 Approved Answer
For Month ended January 2017 PHIN# Name per diem day in month total amount owing 107673104 Mickey Mouse 27.53 26 985365145 Minnie Mouse 31.69 31
For Month ended January 2017 | |||||
PHIN# | Name | per diem | day in month | total amount owing | |
107673104 | Mickey Mouse | 27.53 | 26 | ||
985365145 | Minnie Mouse | 31.69 | 31 | ||
789456123 | Daffy Duck | 30.89 | 31 | ||
321654987 | Wonderwoman | 27.45 | 17 | ||
582965473 | Superman | 46.94 | 6 | ||
963258741 | Olive Oil | 29.73 | 15 | ||
258147369 | Daisy Duck | 39.73 | 31 | ||
Total | |||||
Instructions | |||||
Insert a formula in column E to calculate the total amount owing | |||||
Total columns D and E | |||||
Format "For month ended January 2017" in bold and underline | |||||
Insert a line below "For month ended" | |||||
Bold the headings | |||||
Insert a line above "For month ended January 2017" | |||||
Type the heading "Walt Disney Hospital" (bolded) | |||||
Round Total dollar values to the nearest 100 | |||||
Ensure the print option is set to landscape | |||||
Put a border around the data | |||||
Sort the list alphabetically by Name | |||||
Bold the Total line | |||||
Save the document with your name |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started