Excel Fundamentals for Data Analysis

Working with numbers and dates Test your skills

ByAdmin September 3, 2021September 23, 2021

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

A7,4

———————————————————————————————–

=VALUE(RIGHT(A27,4))

———————————————————————————————–

18/APRIL/08

———————————————————————————————–

=TODAY()

———————————————————————————————–

=TODAY()+30

———————————————————————————————–

=NOW()

———————————————————————————————–

=DAY(F1)

———————————————————————————————–

=MONTH(F1)

———————————————————————————————–

=YEAR(F1)

———————————————————————————————–

2 January 2017

10 March 2017

28 February 2017

28 December 2016

———————————————————————————————–

=EOMONTH(F1,0)

———————————————————————————————–

=EDATE(F1,1)

Excel Fundamentals for Data Analysis | Online Course Support

In column I, use the data in columns E and H to calculate how many days there were between when the invoice was issued and when it was paid. How many days did it take Customer 82555 to pay?
ByAdmin September 3, 2021September 3, 2021

13. Question 13 In column I, use the data in columns E and H to calculate how many days there were between when the invoice was issued and when it…

Read More In column I, use the data in columns E and H to calculate how many days there were between when the invoice was issued and when it was paid. How many days did it take Customer 82555 to pay?
Excel Fundamentals for Data Analysis

Logical and lookup functions Test your skills
ByAdmin September 3, 2021

Week 5 Logical and lookup functions Test your skills >>> Excel Fundamentals for Data Analysis 1. Question 1 To do this assessment you should download this Excel workbook, follow…

Read More Logical and lookup functions Test your skills
Excel Fundamentals for Data Analysis | Online Course Support

Clear the filter you added in Question 11. In column H use the Customer Reference to look up the invoice date for that customer from the data in the SYS DATA sheet. (All transactions for one customer will have the same date.) What is the value of Check Digit 5 in T17?
ByAdmin September 3, 2021September 3, 2021

12. Question 12 Clear the filter you added in Question 11. In column H use the Customer Reference to look up the invoice date for that customer from the data…

Read More Clear the filter you added in Question 11. In column H use the Customer Reference to look up the invoice date for that customer from the data in the SYS DATA sheet. (All transactions for one customer will have the same date.) What is the value of Check Digit 5 in T17?
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 September 3, 2021September 3, 2021

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…

Read More 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?
Excel Fundamentals for Data Analysis | Online Course Support

You have been asked by a school to help automate their accounts processing. Every few days they receive a text file from the bank detailing payments received (BPAY sheet). This information must be matched to the system data that has been downloaded into Excel (SYS DATA sheet) and a report produced that will be uploaded to the school system.
ByAdmin September 3, 2021September 3, 2021

1. Question 1 You have been asked by a school to help automate their accounts processing. Every few days they receive a text file from the bank detailing payments received…

Read More You have been asked by a school to help automate their accounts processing. Every few days they receive a text file from the bank detailing payments received (BPAY sheet). This information must be matched to the system data that has been downloaded into Excel (SYS DATA sheet) and a report produced that will be uploaded to the school system.
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 September 3, 2021September 3, 2021

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…

Read More 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.

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

Similar Posts