BA3020QA Using and Managing Data and Information
- Subject Code :
BA3020QA
- Country :
United Kingdom
Section A ANSWER ALL QUESTIONS
Task 1 (10 marks)
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. (2 decimal place)
- 1.9 + 9.5 × 3.7
- 2.2 - 0.3 × 83.7 /?48
- 378 / ?34 ÷ (93/81)
- 40?500.8 ? 54
- (2/3)4 – (2/5) + 5.52
Task 2 (10 marks)
Set up a table in Excel with the following headings:
|
Company Profit in |
2021 |
Profit in 2022 |
Percentage change (formula) |
Percentage change % |
|
Epsilon company |
£540,880 £486,790 |
|
|
|
|
Zeta company |
£898,886 £952,800 |
|
|
|
Complete the table to find the percentage change, showing the formula by using cell referencing.
Task 3 (10 marks)
Set up a table in Excel with the following headings:
|
|
Share |
House value |
|
Toni |
45% |
|
|
Victoria |
55% |
|
|
Total value |
100% |
£450,000 |
Complete the table to find each share of the house using appropriate Excel formula.
Section B (20 marks) – CHOOSE ONE QUESTION ONLY
- Set up a table in Excel with clear headings, to calculate the monthly repayments for a 10 year loan of £20,000 with 7.5% interest per year. Repayments are made at the beginning of each month. Show and explain with Excel financial formula you have used. (2 decimal place)
- You are given the following employees’ information at work. Enter the data as shown on an Excelspreadsheet and complete the following table:
|
Employee |
Holidays taken (days) |
Logical Function (Insert Formula) |
|
A |
12 |
|
|
B |
4 |
|
|
C |
9 |
|
|
D |
5 |
|
|
E |
8 |
Write down a logical function with an “IF” statement to test whether an employee has taken more than 5 days as holiday. You should show YES in the Logical function column if the employee has met these conditions and NO if they did not meet the condition. The functions you show in the table should be written using cell references to your spreadsheet rows and columns.
Are you struggling to keep up with the demands of your academic journey? Don't worry, we've got your back! Exam Question Bank is your trusted partner in achieving academic excellence for all kind of technical and non-technical subjects.
Our comprehensive range of academic services is designed to cater to students at every level. Whether you're a high school student, a college undergraduate, or pursuing advanced studies, we have the expertise and resources to support you.
To connect with expert and ask your query click here Exam Question Bank
