Using and Managing Data and information
November 2021 cohort
BA3020QA – Assignment 2
Note to students:
The aim of this Assignment is to produce a short video of no more than 10
minutes illustrating your understanding, of the various facilities available in
Excel, showing all formulas used.
There are four tasks in this brief and you only need to choose ONE task to
cover. This assignment is about the quality of your understanding and not
quantity. A chosen task must be completely covered.
The video should record your screen (and voice) explaining (to an audience)
how you solve the problems. The video should be professionally produced
using all aspects studied during the weekly Excel sessions. Use can produce
the video from PPT screen recording or any other recording app.
The deadline for this assignment is (Thursday 31st March 2022 before 3pm).
The submission is via Weblearn (see Assignment submission on slides for
week 12 on how to submit).
Use Excel to perform the following calculations.
For each case you should present the calculations and explain
how you would use Excel as a basic calculator to perform
the calculations and show the formulae you have used.
(1 decimal place)
a. 61.2 – 37.8 x 0.33
b. 5.48 + 8.8 x 1.9 /√87
c. (339 – 173 / 4) ÷ 48 / √63
d. (864 – (143 ÷ 36)/33) ÷ √3768 – 121/3 x √630 – 9(61)
e. (478 – (13)2)
105 x ( √1081)
Use Excel financial formulae to perform the following
scenarios. For each scenario, you need to present the problem
and explain how you would use Excel to solve it. You should
also show the appropriate formula you have used.
(1 decimal place)
a. Calculate the total amount accrued after 4 years for
saving a single amount of £8,000 in a bank account that
pays interest of 2% per year. Assume that interest is
calculated at the beginning of every year.
b.Calculate the monthly repayments for a 10 year loan of
£25,000 with 3% interest per year. Repayments are
made at the beginning of each month.
c. Calculate the total amount accrued after 5 years for
regular monthly cash investments of £100 paid into a
savings account at the beginning of each month and
pays 3.75% interest per year.
d. Calculate the monthly repayments (payable at the end
of each month) for a period of 30 years, for a mortgage
of £270,000 at a fixed interest rate of 2.8% per year.
e. What is the single amount you need to save today so
that you will have £10,000 in 5 years, if the saving rate
is 3.5%? Assume that interest is applied to the account
at the end of every year.
Use an Excel worksheet to setup one table to compare the
UK Government spending for the two years. Calculate the
amounts for each department (in £bn) for the following
Total UK Government spending for the financial year 2021
was £905 bn. The sum is split between each of the
departments as follows:
Total UK Government spending for the financial year 2022
was estimated to be £1,062 bn. The sum is split between
each of the departments as follows:
By comparing the UK Government spending (£bn) in
education, work out the percentage change for 2022
You are given the following employees’ information after
their first six months at work. Enter the data as shown on
an Excel spreadsheet and complete the following table:
a. Write down a function that will return the number of
employees who have taken more than 8 days as
holiday. (use COUNTIF function)
b.Write down a function that will return the number of
employees who have completed less than 2 training
days. (use COUNTIF function)
c. Write down a logical function with an “IF” statement to
test whether an employee has taken more than 8 days as
holiday and completed less than 2 training days. You
should show “YES” if the employee has taken more
than 8 days as holiday and completed less than 2
Note: The functions you show in the table for questions a.
to c. should be written using relative references to your
spreadsheet rows and columns.
- Assignment status: Already Solved By Our Experts
- (USA, AUS, UK & CA PhD. Writers)
- CLICK HERE TO GET A PROFESSIONAL WRITER TO WORK ON THIS PAPER AND OTHER SIMILAR PAPERS, GET A NON PLAGIARIZED PAPER FROM OUR EXPERTS