Accounting Information System?

I have problem two question related to each other, And the part question 6 you may create the tables using excel.