MIS and Back Office Executive

MIS and Back Office Executive Interview Questions and Answers

Updated 9 Oct 2024

Q1. How to get data from one sheet to another work book having reference data in excel?

Ans.

To get data from one sheet to another workbook with reference data in Excel, you can use the VLOOKUP function.

Open both workbooks in Excel
In the destination workbook, select the cell where you want the data to appear
Type the formula =VLOOKUP(lookup_value, '[WorkbookName]SheetName'!table_array, col_index_num, range_lookup)
Replace [WorkbookName] with the name of the source workbook, SheetName with the name of the source sheet, lookup_value with the cell reference in the destina...read more

View 1 answer

Q2. Which type of formulas you use in your company for preparing reports.

Ans.

We use various formulas like SUM, AVERAGE, COUNT, MAX, MIN, etc. for preparing reports.

We use SUM formula to add up values in a column or row.
AVERAGE formula is used to calculate the average of a range of cells.
COUNT formula is used to count the number of cells that contain data.
MAX formula is used to find the highest value in a range of cells.
MIN formula is used to find the lowest value in a range of cells.

Q3. What do you know about advance excel?

Ans.

Advanced Excel is a powerful spreadsheet software that allows users to perform complex calculations, data analysis, and create interactive reports.

Advanced Excel includes features like pivot tables, macros, data validation, conditional formatting, and advanced formulas.
It allows users to manipulate and analyze large amounts of data efficiently.
With Advanced Excel, users can create dynamic charts and graphs to visualize data trends.
It supports automation through VBA (Visual Ba...read more

View 1 answer

Q4. How many formulas and functions do you know

Ans.

I know a variety of formulas and functions in Excel, including VLOOKUP, SUMIF, and COUNTIF.

I am proficient in using basic formulas such as SUM, AVERAGE, MAX, and MIN.
I am familiar with more advanced formulas such as VLOOKUP, HLOOKUP, INDEX, and MATCH.
I am also skilled in using functions such as IF, COUNTIF, SUMIF, and CONCATENATE.
I am constantly learning and expanding my knowledge of Excel formulas and functions.
Examples of formulas I have used in the past include calculating...read more

Are these interview questions helpful?

Q5. How to use V look up and H look up

Ans.

VLOOKUP and HLOOKUP are Excel functions used to search for specific data in a table and return a corresponding value.

VLOOKUP searches for a value in the first column of a table and returns a value in the same row from a specified column.
HLOOKUP searches for a value in the first row of a table and returns a value in the same column from a specified row.
Both functions require a lookup value, table array, column index number, and range lookup (exact match or approximate match).
E...read more

Q6. What is your typing speed?

Ans.

My typing speed is 80 words per minute.

I have been practicing touch typing for several years.
I consistently achieve a high accuracy rate while typing.
I am proficient in using keyboard shortcuts to enhance my typing speed.
I have experience in typing various types of documents, such as reports, emails, and data entry forms.
I am comfortable using different keyboard layouts, including QWERTY and DVORAK.

View 1 answer

Share interview questions and help millions of jobseekers 🌟

Q7. difference b/w marketing and selling

Ans.

Marketing is the process of identifying and satisfying customer needs, while selling is the process of persuading customers to buy a product or service.

Marketing is a broader concept that involves market research, product development, pricing, promotion, and distribution.
Selling is a narrower concept that involves convincing customers to purchase a product or service.
Marketing focuses on creating value for customers, while selling focuses on generating revenue for the company...read more

Q8. Tell me about Excel knowledge

Ans.

Proficient in Excel with knowledge of formulas, functions, data analysis, and reporting.

Strong understanding of Excel functions such as VLOOKUP, SUMIF, and PivotTables
Experience in creating and maintaining complex spreadsheets for data analysis
Ability to generate reports and charts to present data effectively
Familiarity with data validation and conditional formatting
Knowledge of advanced Excel features like macros and Power Query

MIS and Back Office Executive Jobs

View all MIS and Back Office Executive jobs

Q9. Tell me about Sap knowledge

Ans.

SAP knowledge refers to understanding and proficiency in using SAP software for managing business operations.

SAP is an enterprise resource planning software used for various business functions such as finance, HR, and supply chain management.
Knowledge of SAP modules like SAP FI (Financial Accounting) and SAP MM (Materials Management) is beneficial.
Experience in using SAP for data entry, reporting, and analysis is valuable.
Certifications in SAP can demonstrate expertise in the...read more