-
-
The due date for invoices is 21 working days after invoices are issued. This has already been calculated in column J. In column K we would like to identify those people who paid early. Create a calculation in column K that returns a Y if they paid before the due date and otherwise leaves the cell blank. What is the value of Check Digit 6 in T18?
14. Question 14 The due date for invoices is 21 working days after invoices are issued. This has already been calculated in column J. In column K we would like…
-
You realise you could make your life a little easier and your solution more robust by working in a table. Convert the data in A1:Q69 to a table. Turn on the Total row and add a SUM total in the Balance column. Filter the table to only show payments made in October. What is the Total Balance?
11. Question 11 You realise you could make your life a little easier and your solution more robust by working in a table. Convert the data in A1:Q69 to a…
-
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?
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…
-
In the BPAY file dates come through in the format YYYYMMDD, which makes them difficult to perform calculations with. In column D create a calculation to extract the two digit month from the corresponding paiddate in the BPAY sheet. (Do not convert to a number). What is the value of Check Digit 3 in T15?
6. Question 6 In the BPAY file dates come through in the format YYYYMMDD, which makes them difficult to perform calculations with. In column D create a calculation to extract…
-
Logical and lookup functions Test your skills
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…
-
Tables for automating data manipulation Test your skills
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,…
-
Defined Names for working more effectively with data Test your skills
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…
-
Working with numbers and dates Test your skills
Week 2 >>> Working with numbers and dates Test your skills >>> Excel Fundamentals for Data Analysis 1. Question 1 To do this assessment you should download this Excel…
-
Cleaning and manipulating text Test your skills
Week 1 Cleaning and manipulating text Test your skills >>> Excel Fundamentals for Data Analysis 1. Question 1 To do this assessment you should download this Excel workbook, follow…