Page 212 - DCAP101_BASIC_COMPUTER_SKILLS

Unit 10: Microsoft Excel

Number 1, number 2, ... are 1 to 30 arguments for which you want the Notes
sum.
SUM(3, 2) return

SUM (A2:C2) return 50, if cells A2:C2 contain 5, 15 and 30.

Massachusetts Technology Corporation (MTC)

TC created a web-based system to manage the entire reporting and payment
process. With the system, new contracts are requested by account representatives,
Mmanagers approve or reject, and key parties are notified. Immediately after
each speaking engagement, physicians request payment and expense reimbursement via
a secure website. Required parties are notified of their need to approve or reject, and the
system tracks the payment request each step of the way—from submission to approval
to accounts payable to conclusion. At any point, parties can view the request status,
thereby reducing the time needed to track down late or missed payments. No more
sending invoices, manually entering data into Excel, searching for paper contracts, getting
approval signatures from each manager, or manually requesting a check from accounts
payable. As importantly, residents of states requiring reporting can visit a public website
and search by provider name for payments made to them. From initiation to conclusion,
it took MTC less than six months to design, develop and install the system. The web-
database ensures regulatory requirements are met, saves time and effort via workflow
and reporting, and eliminates redundant data entry.
Questions:

1. What is the purpose of MS excel in the document file?
2. How do use mathematical function in the excel sheet?

10.9 Summary

• In this unit we discussed about Microsoft Excel.

• Exploring the Excel Window, in which when we start working we begin using work
is called worksheet.

• Creation of worksheet in which we can say the worksheet that worksheet are used for
mummeries tasks.

• Sorting functions of data, in which we record the menus and address of variers data.
• Excel function, must commonly used excel functions are used by grasped.
• Data and time function are stored as serial number by default.

• Logical function are powerful worksheet functions that enablers you to add decision
making and logic preference to your worksheet.
• Functions that provide the foundation of the majority of worksheet calculations are
mathematical and trigonometric function.

LOVELY PROFESSIONAL UNIVERSITY 205