Excel Fundamentals for Data Analysis

Working with numbers and dates Test your skills

ByAdmin

Week 2 >>> Working with numbers and dates Test your skills >>> Excel Fundamentals for Data Analysis

 

1.

A7,4
———————————————————————————————–
=VALUE(RIGHT(A27,4))
———————————————————————————————–
18/APRIL/08
———————————————————————————————–
=TODAY()
———————————————————————————————–
=TODAY()+30
———————————————————————————————–
=NOW()
———————————————————————————————–
=DAY(F1)
———————————————————————————————–
=MONTH(F1)
———————————————————————————————–
=YEAR(F1)
———————————————————————————————–
———————————————————————————————–
———————————————————————————————–
———————————————————————————————–
———————————————————————————————–
=EOMONTH(F1,0)
———————————————————————————————–

=EDATE(F1,1)

Similar Posts

Excel Fundamentals for Data Analysis | Online Course Support

In column F we need to get the payment amount from the BPAY sheet, but you will notice it is being treated as text because of the “AU” at the front. Apply functions to remove the unwanted characters and convert to a number. Which of the following combinations of calculations could you use?

ByAdmin

8. Question 8 In column F we need to get the payment amount from the BPAY sheet, but you will notice it is being treated as text because of the…

Excel Fundamentals for Data Analysis | Online Course Support

Where there is more than one student enrolled, customers are given a 5% sibling discount. This is applied to the fees up front but as part of the report you are required to calculate what this amount was.

ByAdmin

19. Question 19 Where there is more than one student enrolled, customers are given a 5% sibling discount. This is applied to the fees up front but as part of…

Excel Fundamentals for Data Analysis | Online Course Support

A valid solution for Question 19 could be achieved using which of the following combinations of functions? (Multiple answers may be correct.)

ByAdmin

20. Question 20 A valid solution for Question 19 could be achieved using which of the following combinations of functions? (Multiple answers may be correct.) 1 / 1 point   XLOOKUP and MATCH…

Excel Fundamentals for Data Analysis | Online Course Support

The Customer Reference number is how we identify customers in our system. The BPAY reference appears to consist of the 9 digit School identifier, followed by the 5 digit Customer Reference.

ByAdmin

3. Question 3 The Customer Reference number is how we identify customers in our system. The BPAY reference appears to consist of the 9 digit School identifier, followed by the…

Excel Fundamentals for Data Analysis | Online Course Support

We didn’t quite get the results we wanted in the last question and on closer inspection we discover that there is a space at the end of the BPAY reference. Modify the calculation in column A to remove the extra spaces. The Customer References should now be corrected. What is the updated value for Check Digit 2 in T14?

ByAdmin

4. Question 4 We didn’t quite get the results we wanted in the last question and on closer inspection we discover that there is a space at the end of…

Excel Fundamentals for Data Analysis | Online Course Support

You would also like to see a breakdown of total outstanding fees and arrears. Start by naming the other columns in the SYS DATA sheet. Back in the Upload sheet create a calculation in T10 to calculate the total Amount (in SYS DATA) where the type is fee_amt. Copy the formula down to get the total arrears_amt. What is the Total Arrears amount as shown in T11?

ByAdmin

10. Question 10 You would also like to see a breakdown of total outstanding fees and arrears. Start by naming the other columns in the SYS DATA sheet. Back in…