technology and finance Flashcards
what technology is used by the finance department?
-Spreadsheets, e.g. Microsoft Excel
-Word Processing, e.g. Microsoft Word
-Presentation Software, e.g. Microsoft Powerpoint
-Databases, e.g. Microsoft Access
-E-mail, e.g. Microsoft Outlook
-Online Banking
-Accounting Software
-Electronic Payment Systems, e.g. Apple Pay
why would spreadsheets be used by the finance department?
Spreadsheets, like Microsoft Excel are used to:
-Calculate profit using formulae,
-Create accounts such as income statements - templates may be used which make this less time consuming for the user,
-Create charts/graphs which allow the business to show profit levels over time,
-Copy and paste data into other software such as Microsoft word,
-Change figures easier when compared to paper-based documents, e.g. formulae will automatically update values,
-Perform ‘what if’ scenarios by temporarily changing data to see the effects,
how would the finance department use Word Processing?
Word Processing software, e.g. Microsoft Word would be used to:
-Create financial reports for shareholders,
-Create letters to send to customers reminding them to pay their bills on time,
how would the finance department use Presentation Software?
Presentation Software, e.g. Microsoft Powerpoint would be used to:
-Create presentations to show financial performance to shareholders,
how would the finance department use Databases?
Databases, e.g. Microsoft Access would be used to:
-Store contact details of customers to remind them of their payment dates
how would the finance department use E-mail?
E-mail, e.g. Microsoft Outlook would be used to:
-Remind customers of their outstanding payments.
how would the finance department use Online Banking?
Online Banking would be used to:
-Pay bills online, e.g. electricity,
-Transfer money to a customer or receive payment from a customer,
how would the finance department use Accounting Software?
Accounting Software would be used to:
-Create final accounts such as income statements,
how would the finance department use Electronic Payment Systems?
Electronic Payment Systems, e.g. Apple Pay would be used to:
-Receive payment from customers,