Top 200 Excel Interview Questions and Answers

Updated 14 Dec 2024

Q1. What is disadvantages of vlookup

Ans.

VLOOKUP has limitations such as only searching for values in the leftmost column and being case-sensitive.

  • VLOOKUP only searches for values in the leftmost column of a table

  • It is case-sensitive, so if the lookup value has a different case than the table, it won't find a match

  • It can only return one value, so if there are multiple matches, it will only return the first one

  • It can be slow and resource-intensive for large datasets

View 1 answer
Frequently asked in

Q2. WHAT IS TEXT FORMULAS .HOW DOES IT WORKS ON EXCEL.

Ans.

Text formulas in Excel are used to manipulate and combine text strings. They work by using specific functions and operators.

  • Text formulas are used to perform operations on text strings in Excel.

  • They can be used to concatenate, extract, replace, and manipulate text.

  • Text formulas are created using functions and operators.

  • Examples of text formulas include CONCATENATE, LEFT, RIGHT, MID, SUBSTITUTE, and LEN.

  • Text formulas can be combined with other formulas and functions in Excel.

  • T...read more

View 1 answer

Q3. Do you know basic-level Excel

Ans.

Yes, I have basic-level Excel knowledge.

  • I am proficient in basic Excel functions such as data entry, formatting, and basic formulas.

  • I can create and edit spreadsheets, charts, and graphs.

  • I have experience with functions such as SUM, AVERAGE, and IF statements.

  • I am familiar with Excel shortcuts and can work efficiently with the software.

Add your answer
Frequently asked in

Q4. EXPLAIN ABOUT DIFFERNCE BETWEEN MATCH AND INDEX FUNCTIONS.

Ans.

MATCH and INDEX are Excel functions used for different purposes.

  • MATCH function is used to find the position of a value in a range or array.

  • INDEX function is used to retrieve the value at a specific row and column intersection in a range or array.

  • MATCH function returns the relative position of a value, while INDEX function returns the actual value.

  • MATCH function can be used for approximate or exact matches, while INDEX function is used for exact matches only.

  • MATCH function can...read more

View 2 more answers
Are these interview questions helpful?

Q5. How to use if formula?

Ans.

IF formula is used to test a condition and return a value based on the result.

  • Syntax: =IF(condition, value_if_true, value_if_false)

  • Example: =IF(A1>10, "Yes", "No")

  • Nested IF statements can be used for multiple conditions.

View 1 answer

Q6. How well can you manage Excel application

Ans.

I am proficient in managing Excel application.

  • I am skilled in using Excel functions such as VLOOKUP, Pivot Tables, and Macros.

  • I can create and modify spreadsheets to meet specific needs.

  • I am able to analyze data and generate reports using Excel.

  • I have experience in data entry and data validation in Excel.

  • I am familiar with Excel shortcuts and can work efficiently with large datasets.

Add your answer
Share interview questions and help millions of jobseekers 🌟

Q7. How do you use vlookup?

Ans.

VLOOKUP is a function in Excel used to search for a specific value in a table and return a corresponding value.

  • VLOOKUP stands for Vertical Lookup

  • It is used to search for a specific value in the first column of a table and return a corresponding value from another column in the same row

  • It requires four arguments: lookup value, table array, column index number, and range lookup

  • It is commonly used in financial analysis, data management, and reporting

  • Example: =VLOOKUP(A2, B2:C10,...read more

Add your answer

Q8. Give me some instructions about Excel and PowerPoint

Ans.

Excel is a spreadsheet software used for data analysis and PowerPoint is a presentation software used for creating slideshows.

  • Excel: Use formulas and functions to analyze data, create charts and graphs, and sort and filter data.

  • PowerPoint: Use templates and themes to create professional-looking slideshows, add multimedia elements like images and videos, and rehearse timings for presentations.

  • Both: Use keyboard shortcuts to save time and increase productivity.

  • Example: In Excel...read more

Add your answer

Excel Jobs

Power Bi+ SQL - Noida - Immediate joiner - 5+ yrs. Exp To apply 4-9 years
Ienergizer
4.6
₹ 5 L/yr - ₹ 9 L/yr
Noida
Senior Associate - Master Data Maintainance 3-6 years
Robert Bosch Engineering and Business Solutions Private Limited
4.2
Hosur
AMS_Senior_Analyst_Ban 3-7 years
Robert Bosch Engineering and Business Solutions Private Limited
4.2
Hosur

Q9. Do you know how to operate excel, power point?

Ans.

Yes, I am proficient in operating Excel and PowerPoint.

  • I have experience in creating spreadsheets, charts, and graphs in Excel.

  • I am skilled in using PowerPoint to create presentations with animations and transitions.

  • I can also use Excel to perform data analysis and create pivot tables.

  • I am familiar with keyboard shortcuts and can work efficiently in both programs.

Add your answer

Q10. Do you know the shortcuts keys of excel

Ans.

Yes, I am familiar with the shortcut keys of Excel.

  • Ctrl + C: Copy

  • Ctrl + V: Paste

  • Ctrl + X: Cut

  • Ctrl + Z: Undo

  • Ctrl + Y: Redo

  • Ctrl + B: Bold

  • Ctrl + U: Underline

  • Ctrl + I: Italic

  • Ctrl + F: Find

  • Ctrl + H: Replace

Add your answer

Q11. Create a folder,What is the formula for total in Excel sheet,Create a goggle form

Ans.

The question asks about creating a folder, using the formula for total in Excel, and creating a Google Form.

  • To create a folder, right-click on the desired location and select 'New Folder'.

  • The formula for calculating the total in Excel is '=SUM(range)', where 'range' represents the cells to be summed.

  • To create a Google Form, go to Google Forms website, click on 'Blank' or choose a template, and start customizing the form.

Add your answer

Q12. Difference between CSV file and Excel file

Ans.

CSV files are plain text files that store tabular data, while Excel files are binary files that can contain multiple sheets and complex formatting.

  • CSV files are simpler and more lightweight compared to Excel files.

  • CSV files can be easily opened and edited using a text editor, while Excel files require specific software like Microsoft Excel.

  • CSV files do not support formulas, macros, or formatting options like colors and fonts, while Excel files do.

  • CSV files have a smaller file...read more

View 1 answer
Frequently asked in

Q13. Difference between CSV and Excel file

Ans.

CSV is a plain text file format while Excel is a binary file format.

  • CSV files contain data separated by commas while Excel files can contain multiple sheets and complex formatting.

  • CSV files can be easily opened in any text editor while Excel files require Microsoft Excel or a compatible program.

  • CSV files are smaller in size compared to Excel files.

  • CSV files are commonly used for data exchange between different systems while Excel files are used for data analysis and reporting...read more

Add your answer
Frequently asked in

Q14. How Vlookup works in excel?

Ans.

VLOOKUP is a function in Excel that allows you 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 specific data in large datasets.

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

  • The lookup value is the value you want to search for.

  • The table array is the range of cells that contains the data.

  • The column index number is the colu...read more

Add your answer
Frequently asked in

Q15. What is excel & Word

Ans.

Excel is a spreadsheet software used for data analysis and management. Word is a word processing software used for creating and editing documents.

  • Excel is used for organizing and analyzing data, creating charts and graphs, and performing calculations.

  • Word is used for creating and editing documents, such as letters, reports, and resumes.

  • Both programs are part of the Microsoft Office suite and are widely used in business and academic settings.

Add your answer

Q16. How to read text from Excel file

Ans.

To read text from Excel file, use a library like Apache POI or OpenCSV.

  • Use a library like Apache POI or OpenCSV to read Excel files

  • Identify the sheet and cell containing the text to be read

  • Extract the text using the appropriate method

  • Store the text in an array of strings

Add your answer

Q17. How to apply V-look up

Ans.

V-look up is a function in Excel used to search for a specific value in a table and return a corresponding value.

  • Select the cell where you want the result to appear

  • Go to the 'Formulas' tab and click on 'Lookup & Reference'

  • Select 'VLOOKUP' from the dropdown menu

  • Enter the value you want to search for in the 'Lookup_value' field

  • Select the table range in the 'Table_array' field

  • Enter the column number of the value you want to return in the 'Col_index_num' field

  • Choose whether you w...read more

Add your answer

Q18. How comfortably you can work on MS Office (mainly excel and PowerPoint)

Ans.

I am very comfortable working on MS Office, especially Excel and PowerPoint.

  • I have extensive experience using Excel for data analysis and reporting.

  • I am proficient in creating visually appealing and informative PowerPoint presentations.

  • I am familiar with advanced Excel functions such as VLOOKUP, PivotTables, and Macros.

  • I have used PowerPoint to create presentations for clients and internal stakeholders.

  • I am comfortable working with large data sets and organizing data in Excel...read more

Add your answer

Q19. Difference between MS word and Excel?

Ans.

MS Word is a word processing software while Excel is a spreadsheet software.

  • MS Word is used for creating and editing text documents while Excel is used for organizing and analyzing data.

  • Word has features like spell check, grammar check, and formatting options while Excel has features like formulas, charts, and graphs.

  • Word is used for creating documents like letters, resumes, and reports while Excel is used for creating budgets, financial statements, and data analysis.

  • Word has...read more

Add your answer

Q20. What functions do you know on excel?

Ans.

I know various functions on Excel such as SUM, AVERAGE, COUNT, IF, VLOOKUP, and more.

  • Basic arithmetic functions like SUM, AVERAGE, COUNT

  • Logical functions like IF, AND, OR

  • Lookup functions like VLOOKUP, HLOOKUP

  • Text functions like CONCATENATE, LEFT, RIGHT

  • Date and time functions like TODAY, NOW, MONTH

  • Statistical functions like MAX, MIN, MEDIAN

  • Financial functions like PV, FV, NPV

Add your answer

Q21. do you have knowledge of Tally or Excel?

Ans.

Yes, I have knowledge of Tally and Excel.

  • I am proficient in using Tally for maintaining financial records and generating reports.

  • I have experience in using Excel for data entry, analysis, and creating spreadsheets.

  • I am familiar with functions and formulas in Excel, such as VLOOKUP and SUMIF.

  • I can create charts and graphs in Excel to visualize data.

  • I have used Tally and Excel in my previous roles to manage accounts and generate financial statements.

View 1 answer

Q22. Maintain the complaint data on excell

Ans.

To maintain complaint data on Excel, use Excel's data entry and management tools.

  • Create a new Excel workbook for complaint data

  • Use Excel's data entry tools to input complaint data

  • Use Excel's sorting and filtering tools to manage and analyze complaint data

  • Regularly update the Excel workbook with new complaint data

  • Back up the Excel workbook to prevent data loss

Add your answer

Q23. Which one is better to store data, Excel or Relation Database System?

Ans.

Relational Database System is better for storing data than Excel.

  • Excel is good for small datasets, but RDBMS is better for larger and more complex datasets.

  • RDBMS allows for better data organization, querying, and analysis.

  • Excel is prone to errors and data corruption, while RDBMS has built-in data integrity checks.

  • RDBMS also allows for multiple users to access and modify data simultaneously.

  • Examples of RDBMS include MySQL, Oracle, and SQL Server.

Add your answer

Q24. If you know Excel and SAP

Ans.

Yes, I am proficient in both Excel and SAP.

  • I have advanced Excel skills including VLOOKUP, pivot tables, and macros.

  • I am familiar with SAP modules such as MM, SD, and FI.

  • I have experience using Excel to analyze sales data and create reports.

  • I have used SAP for order processing, inventory management, and customer relationship management.

Add your answer

Q25. Write a program to read a data from excel

Ans.

Program to read data from Excel

  • Use a library like Apache POI or Openpyxl to read Excel files

  • Identify the sheet and cell from which data needs to be read

  • Handle exceptions like file not found or incorrect cell format

View 1 answer

Q26. How to skip first 10 and last 10 rows in excel source and send to destination

Ans.

Skip first and last 10 rows in Excel source and send to destination

  • Use a library like Apache POI or OpenXML to read and write Excel files

  • Identify the range of rows to be skipped using row numbers or cell values

  • Copy the remaining rows to a new Excel file or sheet and save it as destination

Add your answer
Frequently asked in

Q27. Define exel and cell

Ans.

Excel is a spreadsheet program used for data analysis and manipulation. A cell is a single unit within a spreadsheet where data can be entered and stored.

  • Excel is a software application developed by Microsoft.

  • It is commonly used for creating and managing spreadsheets.

  • A cell is the basic building block of a spreadsheet.

  • Each cell can contain data such as numbers, text, or formulas.

  • Cells are organized in rows and columns to form a grid-like structure.

  • Data in cells can be formatt...read more

View 1 answer

Q28. How to apply Vlookup function?

Ans.

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

  • Select the cell where you want the result to appear

  • Type =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

  • Replace lookup_value with the value you want to search for

  • Replace table_array with the range of cells that contains the data

  • Replace col_index_num with the column number that contains the value you want to return

  • Set range_looku...read more

Add your answer

Q29. Write a program to read from excel

Ans.

A program to read data from an Excel file using a programming language.

  • Use a library or module that supports reading Excel files, such as pandas in Python or Apache POI in Java.

  • Open the Excel file and select the specific sheet or range of cells to read data from.

  • Iterate through the rows and columns to extract the data and store it in an array of strings.

Add your answer
Frequently asked in

Q30. If the price of a product is Rs 130 and there is a GST tax of 18% on it, then which formula will be entered in MS Excel so that we can know the full price of that product including tax?

Ans.

To calculate the full price of a product including 18% GST tax in MS Excel, use the formula: =130*1.18

  • Multiply the price of the product by 1.18 (which is 100% + 18% GST tax)

  • Enter the formula in MS Excel as =130*1.18

  • The result will be the full price of the product including tax

  • In this case, the full price of the product would be Rs 153.40

Add your answer
Frequently asked in

Q31. Create a power automate flow to change/modify rows in Excel.

Ans.

Use Power Automate to modify rows in Excel.

  • Create a new flow in Power Automate.

  • Add a trigger for when a new row is added or modified in the Excel file.

  • Use the 'Get rows' action to retrieve the rows from the Excel file.

  • Apply the necessary modifications to the rows using actions like 'Apply to each' and 'Update row'.

  • Save the changes back to the Excel file using the 'Update a row' action.

Add your answer
Frequently asked in

Q32. How good for the excel/google sheets

Ans.

Excel and Google Sheets are both excellent tools for organizing and analyzing data.

  • Both Excel and Google Sheets offer a wide range of functions and formulas for data manipulation.

  • They allow for easy sorting, filtering, and formatting of data.

  • Excel and Google Sheets also have the ability to create charts and graphs to visualize data.

  • They are both user-friendly and widely used in various industries.

  • Google Sheets allows for easy collaboration and sharing of data with others.

  • Exce...read more

Add your answer

Q33. What are the types of Excel

Ans.

There are two types of Excel: Microsoft Excel and Excel Online.

  • Microsoft Excel is a desktop application that is installed on a computer.

  • Excel Online is a web-based version of Excel that can be accessed through a web browser.

  • Microsoft Excel has more advanced features and capabilities than Excel Online.

  • Excel Online is free to use, while Microsoft Excel requires a license.

  • Both types of Excel can open and save files in the same format.

Add your answer

Q34. create a data to excel, power bi

Ans.

Creating a data visualization in Excel and Power BI

  • Collect and organize the data you want to visualize

  • Open Excel and input the data into a spreadsheet

  • Create charts or graphs to represent the data visually

  • Save the Excel file

  • Open Power BI and import the Excel file

  • Create interactive visualizations using the imported data

Add your answer

Q35. How good are you in excel and preparing Microsoft presentation?

Ans.

Proficient in Excel and Microsoft presentation

  • Advanced skills in Excel including formulas, pivot tables, and data analysis

  • Experience creating professional Microsoft presentations with visual aids and data visualization

  • Ability to effectively communicate complex financial data in a clear and concise manner

  • Familiarity with creating charts, graphs, and tables to support analysis

  • Attention to detail and accuracy in all Excel and presentation work

  • Examples: Created financial models i...read more

Add your answer

Q36. What do you know about Tableau and excel?

Ans.

Tableau and Excel are data analysis tools used for visualizing and manipulating data.

  • Tableau is a data visualization tool that allows users to create interactive dashboards and reports.

  • Excel is a spreadsheet program used for data analysis and manipulation.

  • Both tools can be used to analyze and visualize data, but Tableau is more focused on creating interactive visualizations while Excel is more focused on data manipulation.

  • Tableau can connect to a variety of data sources, whil...read more

Add your answer

Q37. 1)Can you know about reports or you make any type of reports in Excel?

Ans.

Yes, I am proficient in creating reports in Excel including sales reports, inventory reports, and financial reports.

  • Proficient in creating various types of reports in Excel

  • Experience in generating sales reports, inventory reports, and financial reports

  • Skilled in using Excel functions and formulas for data analysis

View 1 answer

Q38. How to make a table in an excel.

Ans.

To make a table in Excel, select the cells you want to include and click on the 'Insert Table' button.

  • Open Excel and select the cells you want to include in the table

  • Click on the 'Insert Table' button in the 'Tables' group on the 'Insert' tab

  • Choose the table style you want to use and click 'OK'

  • Enter your data into the table

Add your answer

Q39. Explain basics of Excel & Powerbi

Ans.

Excel is a spreadsheet program used for data analysis and organization, while Power BI is a business analytics tool for visualizing data.

  • Excel is used for creating spreadsheets, organizing data, and performing calculations.

  • Power BI is a business analytics tool that allows users to visualize and share insights from their data.

  • Excel can be used to create charts, graphs, and pivot tables to analyze data.

  • Power BI connects to various data sources to create interactive reports and ...read more

Add your answer

Q40. WHAT IS CONDITINAL FORMATING?

Ans.

Conditional formatting is a feature in software applications that allows users to apply formatting to cells based on specified conditions.

  • Allows users to highlight important data based on specific criteria

  • Can be used to color code cells, add icons, or apply data bars

  • Helps users quickly identify trends or outliers in data

Add your answer

Q41. Explanation of vlookup formula in excel?

Ans.

VLOOKUP is an Excel function used to search for a value in a table and return a corresponding value.

  • VLOOKUP stands for 'vertical lookup'.

  • It searches for a value in the first column of a table and returns a value in the same row from a specified column.

  • Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]).

  • Example: =VLOOKUP(A2, B2:D10, 3, FALSE) - searches for the value in cell A2 in the range B2:D10 and returns the value in the 3rd column.

  • The last argument...read more

Add your answer

Q42. A nos of data is in excel sheet. If i want to find the duplicate or similar data what procedure should i follow?

Ans.

To find duplicate or similar data in an Excel sheet, you can use the 'Conditional Formatting' feature.

  • Select the range of data you want to check for duplicates or similarities.

  • Go to the 'Home' tab in Excel and click on 'Conditional Formatting'.

  • Choose 'Highlight Cells Rules' and then 'Duplicate Values'.

  • Select the formatting options for highlighting duplicates or similar values.

  • Excel will then highlight the duplicate or similar data in the selected range.

  • You can also use the 'R...read more

View 1 answer

Q43. How can u find duplicates in excel

Ans.

To find duplicates in Excel, use the conditional formatting feature or the Remove Duplicates tool.

  • Select the range of cells where you want to find duplicates

  • Go to the 'Home' tab and click on 'Conditional Formatting'

  • Select 'Highlight Cells Rules' and then 'Duplicate Values'

  • Choose the formatting style and click 'OK'

  • Alternatively, go to the 'Data' tab and click on 'Remove Duplicates'

  • Select the columns where you want to find duplicates and click 'OK'

Add your answer

Q44. What is Excel worksheet?

Ans.

An Excel worksheet is a grid of cells used to organize and analyze data.

  • An Excel worksheet is a single tab within an Excel workbook.

  • It consists of rows and columns that intersect to form cells.

  • Each cell can contain data, formulas, or functions.

  • Worksheets can be used for data entry, calculations, and data analysis.

  • They can also be formatted, sorted, and filtered to present data in a meaningful way.

  • Multiple worksheets can be created within a workbook to organize different sets ...read more

View 1 answer

Q45. How to create spreadsheet in excel

Ans.

To create a spreadsheet in Excel, open Excel and click on 'Blank Workbook'.

  • Open Excel and click on 'Blank Workbook'

  • Enter data into the cells

  • Format the cells as needed

  • Add formulas or functions to perform calculations

  • Save the spreadsheet for future use

View 1 answer

Q46. Can we provide dynamic range is pivot table

Ans.

Yes, dynamic range can be provided in a pivot table by using named ranges or by using a table structure.

  • Named ranges can be used to define a dynamic range in Excel and then that named range can be used in a pivot table.

  • Using a table structure in Excel allows for automatic expansion of the range when new data is added, making the pivot table dynamic.

  • Dynamic range can also be achieved by using formulas like OFFSET or INDEX/MATCH to define the range based on certain criteria.

Add your answer

Q47. How will you do Project Analysis with the help of excel data?

Ans.

I will use Excel data for project analysis by organizing and analyzing project data, creating charts and graphs for visualization, and identifying trends and patterns.

  • Organize project data in Excel sheets for easy access and analysis

  • Use Excel functions and formulas to calculate project metrics and KPIs

  • Create charts and graphs to visualize project progress and performance

  • Identify trends and patterns in project data to make informed decisions

  • Use pivot tables to summarize and an...read more

Add your answer
Frequently asked in

Q48. How will you consolidate data from trail balance of multiple branches in Excel into one excel.

Ans.

Consolidate data from multiple branches' trial balances in Excel into one sheet.

  • Create a new worksheet in Excel to consolidate data

  • Copy and paste trial balance data from each branch into the new worksheet

  • Use formulas like SUM or VLOOKUP to combine data from multiple branches

  • Ensure data is accurately consolidated and reconciled

  • Consider using pivot tables for easier analysis

Add your answer

Q49. Do you know excel,ERP?

Ans.

Yes, I am proficient in Excel and have experience working with ERP systems.

  • Proficient in Excel for data analysis and reporting

  • Experience working with ERP systems such as SAP and Oracle

  • Able to create and maintain spreadsheets for inventory management and financial analysis

Add your answer

Q50. can you sell me the excel?

Ans.

Excel is a powerful tool for organizing and analyzing data.

  • Excel allows you to easily manipulate and analyze large amounts of data.

  • It has a variety of functions and formulas for performing complex calculations.

  • You can create charts and graphs to visualize your data.

  • Excel is widely used in business and finance for budgeting, forecasting, and analysis.

  • It can also be used for personal finance, tracking expenses, and creating budgets.

Add your answer

Q51. How do you automate a report using Excel?

Ans.

Automating a report in Excel involves using macros or VBA code to perform repetitive tasks and generate the report automatically.

  • Use Excel's built-in macro recorder to record your actions and generate VBA code.

  • Write VBA code to manipulate data, format cells, and generate charts or tables.

  • Schedule the report to run at specific times using Excel's built-in scheduling tools or external tools like Windows Task Scheduler.

  • Consider using Excel add-ins or third-party tools for more a...read more

Add your answer

Q52. How much manage it assets in excel

Ans.

Managing IT assets in Excel involves creating a detailed inventory of hardware and software, tracking changes, and ensuring accuracy.

  • Create separate sheets for hardware and software inventory

  • Include details such as asset name, serial number, purchase date, and location

  • Regularly update the inventory to reflect changes and additions

  • Use formulas and filters to analyze data and track usage patterns

Add your answer

Q53. What is Vlookup?and if it's giving error then which symbol we use to remove the error?

Ans.

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 in Excel to search for a value in the leftmost column of a table and return a value in the same row from a specified column.

  • If Vlookup is giving an error, the symbol '#' is used to remove the error.

  • For example, if the formula '=VLOOKUP(A2, B2:C10, 2, FALSE)' is giving an error, you can use '#N/A' to ...read more

Add your answer
Frequently asked in

Q54. Which data are excel sheet in filter

Ans.

Excel sheets can filter data based on specific criteria to display only relevant information.

  • Excel sheets can filter data based on text, numbers, dates, colors, and more.

  • Filters can be applied to individual columns or the entire sheet.

  • Examples of filters include sorting data alphabetically, by numerical value, or by date.

  • Filters can also be used to display only certain categories of data, such as sales from a specific region.

Add your answer

Q55. Have experience in google drive excel?

Ans.

Yes, I have experience using Google Drive Excel for creating and managing spreadsheets.

  • Proficient in creating and editing spreadsheets in Google Drive Excel

  • Experience in collaborating with team members on spreadsheets in real-time

  • Knowledge of advanced functions and formulas in Google Drive Excel

  • Ability to import and export data to and from Google Drive Excel

  • Familiarity with sharing and permissions settings in Google Drive Excel

Add your answer

Q56. what is difference between excel and data analysis

Ans.

Excel is a tool while data analysis is a process of examining data to extract insights.

  • Excel is a spreadsheet software used for organizing and manipulating data

  • Data analysis involves using statistical and analytical methods to extract insights from data

  • Excel can be used as a tool for data analysis, but it is not the same as data analysis itself

  • Data analysis can involve multiple tools and techniques beyond Excel, such as Python, R, and SQL

Add your answer

Q57. Do you know reconciliation in excel

Ans.

Yes, reconciliation in Excel involves comparing two sets of data to ensure they are accurate and in agreement.

  • Reconciliation in Excel involves comparing financial records, such as bank statements and accounting records.

  • It helps identify discrepancies and errors in the data.

  • Common reconciliation tasks include matching transactions, verifying balances, and investigating differences.

  • Excel functions like VLOOKUP, INDEX-MATCH, and conditional formatting can be used for reconciliat...read more

Add your answer

Q58. What is the xl and Microsoft

Ans.

XL is a file extension used by Microsoft Excel, a popular spreadsheet software.

  • Microsoft is a technology company that develops software and hardware products.

  • Excel is a spreadsheet software used for data analysis and management.

  • XL is a file extension used by Excel to save spreadsheets in a specific format.

  • Excel is part of the Microsoft Office suite of applications.

Add your answer
Frequently asked in

Q59. Convert excel data into normalised form.

Ans.

To convert excel data into normalised form, first identify unique entities, create separate tables for them, and establish relationships between tables.

  • Identify unique entities in the excel data such as customers, products, orders, etc.

  • Create separate tables for each entity with unique identifiers for each record.

  • Establish relationships between tables using foreign keys to link related data.

  • Normalize the data by removing redundant information and ensuring data integrity.

  • Examp...read more

Add your answer

Q60. What is Excel and how it works

Ans.

Excel is a spreadsheet software used for organizing, analyzing and manipulating data.

  • Excel allows users to create tables, charts, and graphs to represent data visually

  • It can perform complex calculations and analysis using formulas and functions

  • Excel can be used for budgeting, financial analysis, and project management

  • It also has features for data validation, sorting, filtering, and conditional formatting

  • Excel can import and export data from other sources such as databases and...read more

Add your answer

Q61. How well you know about photoshop and excel

Ans.

I am proficient in both Photoshop and Excel.

  • I have extensive experience using Photoshop for image editing and manipulation.

  • I am skilled in using Excel for data analysis and organization.

  • I am familiar with advanced features such as pivot tables, macros, and VLOOKUP.

  • I have used both programs in various professional settings, including creating marketing materials and analyzing sales data.

Add your answer

Q62. How to use ai tool in excel

Ans.

AI tools in Excel can be used for data analysis, forecasting, and automation.

  • Use AI-powered features like Insights to analyze data and generate predictions.

  • Leverage AI-based tools like Power Query to clean and transform data efficiently.

  • Automate repetitive tasks using AI functionalities like Excel's Ideas feature.

  • Utilize machine learning models through add-ins like Azure Machine Learning for advanced analysis.

  • AI tools can help in identifying trends, outliers, and patterns in ...read more

Add your answer

Q63. Do you know macros on excel?

Ans.

Yes, I am familiar with macros in Excel.

  • Macros in Excel are automated tasks that can be created using Visual Basic for Applications (VBA).

  • They can be used to automate repetitive tasks, perform complex calculations, and create custom functions.

  • For example, a macro can be created to automatically format data in a specific way or to generate reports with a single click.

Add your answer

Q64. What is excel and how its work? What is msds?

Ans.

Excel is a spreadsheet software used for data analysis and management. MSDS stands for Material Safety Data Sheet.

  • Excel is used for organizing and analyzing data in a tabular format

  • It allows users to perform calculations, create charts and graphs, and automate tasks

  • MSDS is a document that provides information about the properties and hazards of a chemical substance

  • It includes information on handling, storage, and emergency procedures

  • MSDS is important for ensuring the safe use...read more

Add your answer
Frequently asked in

Q65. What is the file formal of an Excel file?

Ans.

The file format of an Excel file is .xlsx

  • The file format of an Excel file is .xlsx

  • Excel files can also be saved in other formats such as .xls, .xlsm, .csv, etc.

  • The .xlsx format is the default file format for Excel 2007 and later versions

Add your answer

Q66. What is index+match

Ans.

Index+match is a combination of Excel functions used to lookup a value in a table based on row and column criteria.

  • Index function returns the value of a cell in a table based on the row and column number provided

  • Match function returns the position of a value in a range

  • Index+match is commonly used instead of Vlookup for more flexibility and accuracy

  • Example: =INDEX(A1:D10, MATCH(123, B1:B10, 0), 3) will return the value in the 3rd column of the row where 123 is found in column ...read more

Add your answer

Q67. Do you know Excel and PPT

Ans.

Yes, I am proficient in Excel and PowerPoint.

  • Proficient in creating spreadsheets, formulas, and data analysis in Excel

  • Skilled in creating presentations, slides, and animations in PowerPoint

  • Experience in using Excel and PowerPoint for project management and reporting

  • Familiar with advanced features like pivot tables, charts, and macros

Add your answer

Q68. what do you know about xlookup ?

Ans.

xlookup is a function in Excel that allows users to search a range or array and return a value corresponding to the first match found.

  • xlookup is a dynamic array function introduced in Excel 365 and Excel 2019.

  • It can search vertically or horizontally, and can return values from a single cell or an array of cells.

  • xlookup can perform exact matches, approximate matches, wildcard matches, and more complex lookups.

  • It is a versatile replacement for older lookup functions like VLOOKU...read more

Add your answer

Q69. How to extract data from Excel

Ans.

Methods to extract data from Excel include using SAP Bods, OLE DB, ODBC, and Excel VBA macros.

  • Using SAP Bods to extract data directly from Excel files

  • Using OLE DB (Object Linking and Embedding Database) to connect to Excel as a data source

  • Using ODBC (Open Database Connectivity) to extract data from Excel spreadsheets

  • Using Excel VBA macros to automate the extraction process

Add your answer
Frequently asked in

Q70. How to bring data from an excel sheet into databricks?

Ans.

Data from an Excel sheet can be brought into Databricks using the read method in Databricks.

  • Use the read method in Databricks to read the Excel file.

  • Specify the file path and format (e.g. 'xlsx') when using the read method.

  • Transform the data as needed using Databricks functions and libraries.

  • Example: df = spark.read.format('com.crealytics.spark.excel').option('useHeader', 'true').load('file.xlsx')

Add your answer
Frequently asked in

Q71. WHAT IS h7 AND F7?

Ans.

h7 and F7 are not clear without context. They could refer to anything from chess moves to electrical components.

  • Without context, it is impossible to determine what h7 and F7 refer to.

  • They could be chess moves, as h7 and F7 are positions on a chessboard.

  • They could also refer to electrical components, such as resistors or capacitors.

  • It is important to provide context when discussing h7 and F7 to avoid confusion.

Add your answer

Q72. Do you know Link in excel?

Ans.

Yes, Link in Excel is a feature that allows you to create a hyperlink to a specific cell or range of cells within the same workbook or to a different workbook or file.

  • Link in Excel can be created by selecting the cell or range of cells you want to link to and then right-clicking and selecting 'Hyperlink'.

  • You can also create a link by using the 'Insert Hyperlink' option under the 'Insert' tab.

  • Links can be created to other sheets within the same workbook, to other workbooks, or...read more

Add your answer
Frequently asked in

Q73. Calculate GST amount from the given data with excel.

Ans.

Calculate GST amount from given data using Excel.

  • Open Excel and enter the data in a table format

  • Use the formula =Amount*(GST%)/100 to calculate GST amount

  • Ensure that the cell format is set to currency

  • Repeat the formula for all rows in the table

  • Sum up the GST amount column to get the total GST amount

Add your answer
Frequently asked in

Q74. Do you know excel? How many types of look up?

Ans.

Yes, I know Excel. There are two types of lookup functions in Excel.

  • The two types of lookup functions in Excel are VLOOKUP and HLOOKUP.

  • VLOOKUP is used to search for a value in the first column of a table and return a corresponding value in the same row from a specified column.

  • HLOOKUP is used to search for a value in the first row of a table and return a corresponding value in the same column from a specified row.

Add your answer

Q75. How can see double entry in excel

Ans.

Double entry in Excel can be seen by using formulas and functions to ensure that all data is accurately recorded in two or more places.

  • Use formulas to calculate and record data in multiple cells

  • Use functions like SUM, AVERAGE, and COUNT to ensure accuracy

  • Check for consistency between different sheets or workbooks

  • Use conditional formatting to highlight discrepancies

  • Double check all entries to ensure accuracy

Add your answer
Frequently asked in

Q76. How to create a mortgage schedule using the excel?

Ans.

To create a mortgage schedule using Excel, you can use the PMT function and create a table with columns for payment number, payment amount, principal, interest, and remaining balance.

  • Use the PMT function to calculate the monthly mortgage payment based on the loan amount, interest rate, and loan term.

  • Create a table with columns for payment number, payment amount, principal, interest, and remaining balance.

  • Use formulas to calculate the principal and interest portions of each pa...read more

Add your answer

Q77. Can you apply Index match formula on large data.

Ans.

Yes, Index match formula can be applied on large data sets for efficient lookup and retrieval.

  • Index match formula is commonly used in Excel to lookup values based on a specific criteria.

  • It is more efficient than VLOOKUP for large data sets as it does not require the data to be sorted.

  • Index match can handle large data sets with thousands of rows and columns without any performance issues.

  • Example: =INDEX($B$2:$B$1000, MATCH($E2, $A$2:$A$1000, 0)) will return the value in column...read more

Add your answer

Q78. How to generate password in Excel file

Ans.

Excel has a built-in function to generate passwords. It can be accessed through the 'RAND' function.

  • Open the Excel file and select the cell where you want to generate the password

  • Type '=RAND()' in the cell and press enter

  • The cell will generate a random number between 0 and 1

  • To convert the number into a password, select the cell and go to 'Home' tab > 'Number' group > 'More Number Formats'

  • In the 'Format Cells' dialog box, select 'Custom' and enter a password format, such as '?...read more

Add your answer

Q79. How can we merge two cells in an excel.

Ans.

To merge two cells in Excel, select the cells and click on the 'Merge & Center' button in the Home tab.

  • Select the cells you want to merge

  • Click on the 'Merge & Center' button in the Home tab

  • Alternatively, you can right-click on the selected cells and choose 'Merge Cells'

  • Merging cells combines their contents into a single cell

Add your answer

Q80. How to uses for company accounts in EXCL

Ans.

Company accounts in EXCL can be used for financial management and analysis.

  • Company accounts in EXCL can be used to track expenses and revenue.

  • They can be used to create financial reports and analyze financial data.

  • Company accounts can also be used to manage budgets and forecast future financial performance.

  • Examples of company accounts in EXCL include balance sheets, income statements, and cash flow statements.

Add your answer
Frequently asked in

Q81. Can you help me understand where we use the H-lookup ?

Ans.

H-lookup is used in Excel to search for a value in a table horizontally and return a corresponding value from the same row.

  • H-lookup is used in Excel to search for a value in the first row of a table and return a value in the same column from a specified row.

  • It is commonly used in financial modeling, data analysis, and reporting.

  • Example: =HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

Add your answer
Frequently asked in

Q82. Make a dashboard on excel

Ans.

Create a dashboard on Excel

  • Start by organizing your data in a structured manner

  • Use pivot tables and charts to visualize the data

  • Include key metrics and KPIs for easy analysis

  • Add filters and slicers for interactivity

  • Format the dashboard for a professional look

Add your answer

Q83. What is xlookup formula

Ans.

XLOOKUP is a formula in Excel that allows you to search for a value in a range and return a corresponding value from another range.

  • XLOOKUP is a powerful alternative to VLOOKUP and HLOOKUP formulas.

  • It can perform both vertical and horizontal lookups.

  • XLOOKUP can search for values in multiple columns or rows.

  • It can handle both exact and approximate matches.

  • XLOOKUP supports wildcard characters and can handle errors more efficiently.

  • Example: =XLOOKUP(42, A1:A10, B1:B10) will searc...read more

Add your answer

Q84. Do you know how to graph on excel

Ans.

Yes, I am proficient in creating graphs on Excel.

  • I can create various types of graphs such as bar graphs, line graphs, pie charts, etc.

  • I am familiar with adding data, labels, and formatting the graphs to make them visually appealing.

  • I can use Excel's chart tools to customize the appearance of the graphs.

  • I understand how to interpret the data and trends shown in the graphs.

  • I have experience in creating dynamic graphs using formulas and functions in Excel.

Add your answer

Q85. Excel skills and tools used before

Ans.

I have advanced Excel skills including VLOOKUP, pivot tables, and macros.

  • Proficient in VLOOKUP function for data lookup

  • Experience creating and analyzing pivot tables for data summarization

  • Knowledge of recording and running macros for automation

  • Familiar with advanced functions like INDEX-MATCH and conditional formatting

Add your answer
Frequently asked in

Q86. Test Data read from Excel

Ans.

Test data can be read from Excel using libraries like Apache POI or OpenPyXL.

  • Use libraries like Apache POI or OpenPyXL to read data from Excel files

  • Identify the sheet and cell from which data needs to be read

  • Handle different data types like strings, numbers, dates, etc.

  • Perform validations on the data read from Excel

Add your answer
Frequently asked in

Q87. Data validation use process demonstration in excel and explain how can we use data validation.

Ans.

Data validation in Excel ensures accuracy and consistency of data. It can be used to restrict input and prevent errors.

  • Data validation is used to set rules for data entry in Excel.

  • It can be used to restrict input to a certain range of values or a specific list.

  • Data validation can also be used to prevent duplicate entries or invalid data.

  • For example, you can use data validation to ensure that a date entered in a cell is within a certain range.

  • To use data validation, select the...read more

Add your answer
Frequently asked in

Q88. Excel Look ups formula

Ans.

Excel Look ups formula

  • Excel Lookups are used to search for specific values in a table or range

  • Common lookup functions in Excel include VLOOKUP and HLOOKUP

  • VLOOKUP searches for a value in the leftmost column of a table and returns a corresponding value from a specified column

  • HLOOKUP searches for a value in the top row of a table and returns a corresponding value from a specified row

  • Lookup functions can be used to retrieve data from different sheets or workbooks

  • They are useful f...read more

Add your answer

Q89. Data visualisation using Excel

Ans.

Excel is a powerful tool for data visualization. It offers various chart types and customization options.

  • Select the data range and choose the chart type from the Insert tab

  • Customize the chart by adding titles, labels, and formatting options

  • Use conditional formatting to highlight specific data points

  • Create pivot tables to summarize and analyze large datasets

  • Utilize Excel's built-in functions for calculations and data manipulation

Add your answer

Q90. Excel and jira tools usage level of expertise

Ans.

I have a high level of expertise in both Excel and Jira tools.

  • Proficient in creating and managing complex spreadsheets in Excel

  • Experienced in using Jira for project management and issue tracking

  • Able to integrate Excel data into Jira for better project tracking

  • Familiar with advanced Excel functions such as VLOOKUP and PivotTables

  • Adept at creating custom reports and dashboards in Jira

Add your answer

Q91. Stock Management how can manage on Excel and software

Ans.

Stock management can be efficiently managed using Excel and software.

  • Create a spreadsheet to track inventory levels, sales, and purchases.

  • Use formulas to calculate reorder points and safety stock levels.

  • Utilize data analysis tools to identify trends and optimize inventory levels.

  • Consider using specialized inventory management software for more complex operations.

  • Regularly update and reconcile inventory records to ensure accuracy.

Add your answer

Q92. Skip rows in an excel in SSIS

Ans.

Use Conditional Split transformation in SSIS to skip rows in Excel

  • Use Conditional Split transformation in SSIS to evaluate a condition for each row

  • Set up the condition to skip rows based on a specific criteria, such as row number or value in a column

  • Redirect the rows that meet the condition to a different output path to effectively skip them

Add your answer
Frequently asked in

Q93. Online assessment in Excel

Ans.

Online assessment in Excel involves creating and administering tests using Excel spreadsheets.

  • Create a test template in Excel with questions and answer choices

  • Use data validation to create dropdown menus for answer selection

  • Utilize formulas to automatically grade the assessments

  • Protect the sheet to prevent students from editing the test

  • Consider using macros for more advanced functionalities

  • Example: Create a multiple-choice quiz in Excel with a grading system

Add your answer
Frequently asked in

Q94. Weekly weekly payment method of Excel using

Ans.

Excel has a built-in weekly payment method that can be used to calculate payments on a weekly basis.

  • To use the weekly payment method in Excel, you need to enter the payment amount, the interest rate, and the number of weeks in the formula.

  • The formula for calculating weekly payments in Excel is =PMT(rate/52, number of weeks, -loan amount).

  • For example, if you want to calculate the weekly payment for a $10,000 loan with a 5% interest rate over 52 weeks, the formula would be =PMT...read more

Add your answer

Q95. 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

Q96. Proficiency with excel and excel macros ??

Ans.

Yes, I am proficient in Excel and Excel macros.

  • I have extensive experience in using Excel for data analysis and manipulation.

  • I am skilled in creating and modifying Excel macros to automate repetitive tasks.

  • I am familiar with advanced Excel functions such as VLOOKUP, PivotTables, and conditional formatting.

  • I have used Excel to create charts and graphs to visualize data.

  • I am comfortable working with large datasets in Excel and have experience cleaning and organizing data.

Add your answer
Frequently asked in

Q97. Data analytics using excel

Ans.

Data analytics using excel involves analyzing and interpreting data using various tools and functions in Excel.

  • Use functions like VLOOKUP, SUMIF, and PivotTables to analyze data

  • Create charts and graphs to visualize data trends

  • Use conditional formatting to highlight important data points

  • Perform statistical analysis using Excel's data analysis toolpack

  • Clean and organize data using filters and sorting functions

Add your answer

Q98. For reapet last action what is the shortcut key in excel?

Ans.

The shortcut key for repeat last action in Excel is Ctrl + Y.

  • The shortcut key for repeat last action in Excel is Ctrl + Y.

  • This shortcut allows you to quickly repeat the last action you performed in Excel.

  • For example, if you just formatted a cell and want to apply the same formatting to another cell, you can use Ctrl + Y to repeat the formatting action.

  • This shortcut can save time and improve efficiency when working with repetitive tasks in Excel.

View 3 more answers

Q99. Experience with Excel and QuickBooks

Ans.

Proficient in Excel for financial analysis and reporting. Experienced in using QuickBooks for bookkeeping and financial management.

  • Utilize Excel for creating financial models, analyzing data, and generating reports

  • Skilled in using functions, pivot tables, and macros in Excel

  • Manage accounts, track expenses, and generate financial statements using QuickBooks

  • Experience in reconciling accounts, invoicing, and payroll processing in QuickBooks

Add your answer

Q100. Dropdown list in excel

Ans.

Dropdown list in Excel

  • Dropdown list is a feature in Excel that allows users to select a value from a pre-defined list

  • It can be created using the Data Validation tool

  • Dropdown lists can be used to ensure data accuracy and consistency

Add your answer
1
2
3
Interview Tips & Stories
Ace your next interview with expert advice and inspiring stories

Interview experiences of popular companies

3.7
 • 10.4k Interviews
3.8
 • 8.2k Interviews
3.7
 • 4.8k Interviews
3.5
 • 3.8k Interviews
3.8
 • 3.1k Interviews
4.0
 • 1.4k Interviews
3.3
 • 507 Interviews
3.9
 • 461 Interviews
3.8
 • 407 Interviews
3.9
 • 269 Interviews
View all
Excel Interview Questions
Share an Interview
Stay ahead in your career. Get AmbitionBox app
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
70 Lakh+

Reviews

5 Lakh+

Interviews

4 Crore+

Salaries

1 Cr+

Users/Month

Contribute to help millions

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter