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

To be eligible for discount customers must have paid before the Discount Due Date and must have paid at least the full balance owing less the discount amount, i.e.

ByAdmin

18. Question 18 To be eligible for discount customers must have paid before the Discount Due Date and must have paid at least the full balance owing less the discount…

Excel Fundamentals for Data Analysis | Online Course Support

In column L calculate how many working days (excluding Saturdays and Sundays, but not holidays) those who paid early, paid by. If they did not pay early the calculation should just return 0. In the total row add a sum for this column. What is the total shown in the total row?

ByAdmin
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

In column E use a calculation to convert the paid date in the BPAY sheet to a valid Excel date. Formats will differ for different regions, but once converted you should be able to switch between number format and short date format. (Hint: you will need to separate and rejoin the separate parts of the date using an appropriate date function. What is the value of Check Digit 4 in T16?

ByAdmin

7. Question 7 In column E use a calculation to convert the paid date in the BPAY sheet to a valid Excel date. Formats will differ for different regions, but…

Excel Fundamentals for Data Analysis | Online Course Support

Discounts are calculated as a percentage of the balance owed, rates vary depending on how large the balance is. The lookup table in S2:T5 details what percentage is applied, so for example balances from 300 to 11999.99 get a 5% discount.

ByAdmin

17. Question 17 Discounts are calculated as a percentage of the balance owed, rates vary depending on how large the balance is. The lookup table in S2:T5 details what percentage…

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…