Question: Instructions: 1. Convert the data into a table, choose the Blue, Table Style Medium 2 option. Make sure you check My table has headers. 2.

Instructions:
1. Convert the data into a table, choose the Blue, Table Style Medium 2 option. Make sure you check "My table has headers".
2. Name the table as 'JuneFees'.
3. Label column H 'Value', insert a formula = (column D minus column E).

19. Insert a slicer and then pick Account ID, Currency and Transaction Code. You can see a slicer tab is displapyed. Select the different styles, aligning the slicers etc. Try click on Account UD 4, and see what happened.

Account ID Effective date2 Transaction Code Debit Amount Credit Amount Currency Posted Date Column1 Column2
1 2021-06-30 FEE 0 CAD 7/1/2021 12:00:00AM
2 2021-06-30 FEE 0.01 CAD 7/1/2021 12:00:00AM
3 2021-06-30 FEE 0.01 CAD 7/1/2021 12:00:00AM

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!