AFNA

it is an information system that, identifies, records, and communicates the economic events of an organization

(a)  

Accounting is defined as...

• identification & recording

• communication of economic information

• Language of Business

• counting of numbers

Answer explanation

As we all know, accounting is the process of keeping track of all financial transactions within a business/ organization it uses different mechanisms/ systems in tracking the flow of money.
- It provides a clear picture of the financial health of a business/ org.

• - Serve as a catalyst for resource management and strategic growth.

item/s cause the capital changes?

• drawing

• revenue

• expenses

• inflation

This contains the entire group of accounts maintained by a company.

(a)  

Microsoft application that is best used for data entry and management, charts and graphs, and project management

• MS Google Spreadsheet

• Microsoft Excel

• Microsoft Word

• Microsoft Accounting

Answer explanation

• One of the most popular spreadsheet software options is Microsoft Excel.

-a wide variety of functions and features in addition to different ways to visualize data but with a simple interface.

It is a user-report-based program tool that allows users to reorganize and summarise the selected columns and rows of data in a database sheet like Excel or a spreadsheet.

• Vlookup

• Pivot Table

• Sort A-Z

• Filter

Organizes data in a column by searching for a specific value from one column and returns the corresponding value from another column defined by the Column Index number.

• Vlookup

• Pivot Table

• Sort A-Z

• Filter

The function represents searching for a value in the range of data in the same or external sheet.

• Vlookup

• Pivot Table

• Sort A-Z

• Filter

Organises bulk data in a more user-friendly manner.

• Vlookup

• Pivot Table

• Sort A-Z

• Filter

Answer explanation

Key Differences:

Pivot Table - used to summarise the data and group things.

• - rearranges as per the user's need for the report.

• - a format that consists of two or more data sets, which are listed in tabular form.

• Vlookup - used in a worksheet to look up and pull data from another Excel table or worksheet

  Take Note: VLOOKUP can help prepare the data for Pivot Tables to then perform analysis and reports from it.

Based on the example last meeting, how to get the maturity value of an amount loaned to Jasmin if it will be paid in 10 years?

• Amount Loaned + Interest rate x 10 yrs / 12 mons

• Amount Loaned + Interest rate x 10 yrs

• Amount Loaned + Amount Loaned x Interest rate x 10 yrs