KTL Automobile Accountant and Office Administration Interview Questions and Answers

Show them in excel like format painter, filter, find and replace

Vlookup is a function in Excel used to search for a value in a table and return a corresponding value from another column.

• Vlookup stands for vertical lookup.

• It is commonly used to find and retrieve data from a large dataset.

• The function requires four arguments: lookup value, table array, column index number, and range lookup.

• Example: =VLOOKUP(A2, B2:D10, 3, FALSE) will search for the value in cell A2 in the range B2:D1...read more

A pivot chart is a graphical representation of data from a pivot table in Excel.

• A pivot chart is created based on a pivot table, which summarizes and analyzes data.

• It allows users to visualize and analyze data in a more interactive and dynamic way.

• Pivot charts can be customized with different chart types, styles, and layouts.

• They can be used to identify trends, patterns, and relationships in data.

• Pivot charts can also ...read more

The golden rules of accounting are basic principles that guide the recording of financial transactions.

• The first golden rule is the Personal Account rule, which states that debit the receiver and credit the giver.

• The second golden rule is the Real Account rule, which states that debit what comes in and credit what goes out.

• The third golden rule is the Nominal Account rule, which states that debit all expenses and losse