· How to analyze payer responses with missing data. · Use basic Excel functions to confirm math equations and data. · Understand types of charges and relevancy of processing. · Confirm accuracy of provided information. · Understanding how to read an 835 Success Criteria: Your submission must be in Excel format. Appropriate formulas should be used when warranted. Understanding types of charges, what they mean, and how patient responsibility works will allow you to complete this successfully. Use concepts learned in Week 1 and Week 2 to complete this assignment. Excel: · Create a formula that will allow you to confirm totals. (For your understanding and to complete questions regarding patients) · Complete Patient 1 missing data (20 points) · Complete Patient 2 missing data (20 points) · Complete Patient 3 missing data (20 points) · Complete Patient 4 missing data (20 points) · Complete Patient 5 missing data (20 points) * .This criterion is linked to a Learning OutcomeComplete Patient 1 missing data Blanks on Excel are completed with accurate financial responsibility and data . Complete Patient 2 missing data Blanks on Excel are completed with accurate financial responsibility and data . This criterion is linked to a Learning OutcomeComplete Patient 3 missing data Blanks on Excel are completed with accurate financial responsibility and data . Complete Patient 4 missing data Blanks on Excel are completed with accurate financial responsibility and data . Complete Patient 5 missing data Blanks on Excel are completed with accurate financial responsibility and data
