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

Tables for automating data manipulation Test your skills
ByAdmin September 3, 2021

Week 4 Tables for automating data manipulation Test your skills >>> Excel Fundamentals for Data Analysis 1. Question 1 To do this assessment you should download this Excel workbook,…

Read More Tables for automating data manipulation Test your skills
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.
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 September 3, 2021September 3, 2021

Read More 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?
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 | 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 September 3, 2021September 3, 2021

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…

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

Defined Names for working more effectively with data Test your skills
ByAdmin September 3, 2021

Week 3 Defined Names for working more effectively with data Test your skills >>> Excel Fundamentals for Data Analysis 1. Question 1 To do this assessment you should download…

Read More Defined Names for working more effectively with data Test your skills

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

Similar Posts