Search Header Logo
N5 BM Technology in Finance

N5 BM Technology in Finance

Assessment

Presentation

Business

11th - 12th Grade

Practice Problem

Medium

Created by

Jessica Suk Ching Martin

Used 3+ times

FREE Resource

12 Slides • 12 Questions

1

media

2

media

3

Dropdown

can be used in the finance department to produce graphs and charts of financial information.



The formulae function within the spreadsheet can be used to carry out instant calculations​
. Formulae will also amend calculations automatically when the spreadsheet is updated.



‘​
’ scenarios can be carried out to set up with IF statements and appropriate formulae.

Information held can be easily secured using a ​
.



Time can be saved in the finance department by using spreadsheet ​
for financial statements and spreadsheets can be easily amended or edited.

4

media

5

media

6

Categorize

Options (6)

less chance of error

Mistakes can be easily changed

Graphs and charts are easier to read and interpret

It can be costly to purchase the hardware and software

Staff need to be trained

The software and hardware can become out of date relatively quickly

Spreadsheets

Advantages
Disadvantages

7

media

8

media

9

media

10

Multiple Select

Choose the correct statements about Banking Apps:

1

Online banking allows businesses to make payments quickly

2

Business can have online access to accounts

3

Easy to use due to formulae

4

Payments can only be made within a specific regional area

5

Forgetting the password could lock you out of the app for a period of time

11

media

12

Multiple Choice

Emails can be used in Finance to:

1

let the marketing department know what their budget will be this year

2

let customers know that there is a promotion on

3

contact suppliers to order inventory

4

to attach a job description and person spec to an applicant

13

Multiple Choice

Word processing can be used in the Finance department to:

1

create a job advert

2

to create a list of local suppliers

3

to make a promotional flyer

4

to create a report to include an income statement

14

Multiple Choice

Databases can be used in the Finance department to:

1

keep a record of potential job applicants

2

keep a record of inventory held

3

create a report of payment outstanding to suppliers

4

keep a record of customer's email addresses

15

media

16

Reorder

Reorder the following

Powerpoint is used to integrate with a

spreadsheet to display charts and

information on the financial position

of the business when

speaking to management

1
2
3
4
5

17

Reorder

Reorder the following

Internet could be used to

gain information on

potential customers before

deciding on

appropriate credit terms

1
2
3
4
5

18

media

19

Multiple Choice

EPOS stands for...

1
Electronic Point of Service
2
Effective Point of Sale
3
Electronic Point of Sale
4
Economic Point of Sale

20

Exam Style Questions

21

Multiple Choice

Justify the use of spreadsheets in the Finance department. (1 mark)

1

The Finance department would use spreadsheets because calculations can be carried out automatically using formulae. 

2

The Finance department would use spreadsheets because it is easy to keep a record of suppliers accounts and what they owe.

3

The Finance department would use spreadsheets because staff need to be trained to use the package effectively and this involve additional costs.

4
  • Graphs and charts are easier to read and interpret than lots of figures​.

5

It can be costly to purchase the hardware and software required.

22

Multiple Choice

Describe advantages of using spreadsheet software.

1

Formulae can be used to calculate information 

which allows for automatic calculation if anything changes.

2

One advantage is that the software and hardware can become out of date relatively quickly and may have to be updated.

3

Graphs/Charts can be created to display information 

which makes it more difficult for comparison of complex financial information 

4

All transactions can be viewed giving a more complete view of the current state of the organisation’s finances, therefore this helps with budgeting

5

Spreadsheet records can be searched and sorted quickly which means critical information can be found quicker.  ​The reports can be stored and referred back to at a later date.​

23

Open Ended

Describe the ways that other software can be used in the finance department. (2 marks) 

DO NOT USE SPREADHSHEETS

24

Describe the ways that other software can be used in the finance department. (2 marks) 

  • Word Processing – to create documents informing departments of their annual budget figure Word Processing – to compile the Shareholders’ Annual Financial Report  

  • Database – to keep records of suppliers’ accounts due and/or debtors’ accounts owed Database – to create reports of overdue accounts  

  • PowerPoint – to display financial information at the shareholders meeting  

  • Internet/website/online… 

media

Show answer

Auto Play

Slide 1 / 24

SLIDE