Top 200 Excel Interview Questions and Answers
Updated 14 Dec 2024
Q1. What is disadvantages of vlookup
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
Q2. WHAT IS TEXT FORMULAS .HOW DOES IT WORKS ON EXCEL.
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
Q3. Do you know basic-level Excel
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.
Q4. EXPLAIN ABOUT DIFFERNCE BETWEEN MATCH AND INDEX FUNCTIONS.
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
Q5. How to use if formula?
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.
Q6. How well can you manage Excel application
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.
Q7. How do you use vlookup?
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
Q8. Give me some instructions about Excel and PowerPoint
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
Excel Jobs
Q9. Do you know how to operate excel, power point?
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.
Q10. Do you know the shortcuts keys of excel
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
Q11. Create a folder,What is the formula for total in Excel sheet,Create a goggle form
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.
Q12. Difference between CSV file and Excel file
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
Q13. Difference between CSV and Excel file
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
Q14. How Vlookup works in excel?
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
Q15. What is excel & Word
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.
Q16. How to read text from Excel file
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
Q17. How to apply V-look up
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
Q18. How comfortably you can work on MS Office (mainly excel and PowerPoint)
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
Q19. Difference between MS word and Excel?
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
Q20. What functions do you know on excel?
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
Q21. do you have knowledge of Tally or Excel?
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.
Q22. Maintain the complaint data on excell
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
Q23. Which one is better to store data, Excel or Relation Database System?
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.
Q24. If you know Excel and SAP
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.
Q25. Write a program to read a data from excel
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
Q26. How to skip first 10 and last 10 rows in excel source and send to destination
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
Q27. Define exel and cell
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
Q28. How to apply Vlookup function?
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
Q29. Write a program to read from excel
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.
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?
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
Q31. Create a power automate flow to change/modify rows in Excel.
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.
Q32. How good for the excel/google sheets
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
Q33. What are the types of Excel
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.
Q34. create a data to excel, power bi
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
Q35. How good are you in excel and preparing Microsoft presentation?
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
Q36. What do you know about Tableau and excel?
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
Q37. 1)Can you know about reports or you make any type of reports in Excel?
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
Q38. How to make a table in an excel.
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
Q39. Explain basics of Excel & Powerbi
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
Q40. WHAT IS CONDITINAL FORMATING?
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
Q41. Explanation of vlookup formula in excel?
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
Q42. A nos of data is in excel sheet. If i want to find the duplicate or similar data what procedure should i follow?
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
Q43. How can u find duplicates in excel
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'
Q44. What is Excel worksheet?
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
Q45. How to create spreadsheet in excel
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
Q46. Can we provide dynamic range is pivot table
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.
Q47. How will you do Project Analysis with the help of excel data?
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
Q48. How will you consolidate data from trail balance of multiple branches in Excel into one excel.
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
Q49. Do you know excel,ERP?
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
Q50. can you sell me the excel?
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.
Q51. How do you automate a report using Excel?
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
Q52. How much manage it assets in excel
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
Q53. What is Vlookup?and if it's giving error then which symbol we use to remove the error?
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
Q54. Which data are excel sheet in filter
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.
Q55. Have experience in google drive excel?
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
Q56. what is difference between excel and data analysis
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
Q57. Do you know reconciliation in excel
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
Q58. What is the xl and Microsoft
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.
Q59. Convert excel data into normalised form.
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
Q60. What is Excel and how it works
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
Q61. How well you know about photoshop and excel
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.
Q62. How to use ai tool in excel
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
Q63. Do you know macros on excel?
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.
Q64. What is excel and how its work? What is msds?
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
Q65. What is the file formal of an Excel file?
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
Q66. What is index+match
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
Q67. Do you know Excel and PPT
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
Q68. what do you know about xlookup ?
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
Q69. How to extract data from Excel
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
Q70. How to bring data from an excel sheet into databricks?
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')
Q71. WHAT IS h7 AND F7?
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.
Q72. Do you know Link in excel?
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
Q73. Calculate GST amount from the given data with excel.
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
Q74. Do you know excel? How many types of look up?
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.
Q75. How can see double entry in excel
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
Q76. How to create a mortgage schedule using the excel?
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
Q77. Can you apply Index match formula on large data.
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
Q78. How to generate password in Excel file
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
Q79. How can we merge two cells in an excel.
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
Q80. How to uses for company accounts in EXCL
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.
Q81. Can you help me understand where we use the H-lookup ?
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])
Q82. Make a dashboard on excel
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
Q83. What is xlookup formula
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
Q84. Do you know how to graph on excel
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.
Q85. Excel skills and tools used before
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
Q86. Test Data read from Excel
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
Q87. Data validation use process demonstration in excel and explain how can we use data validation.
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
Q88. Excel Look ups formula
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
Q89. Data visualisation using Excel
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
Q90. Excel and jira tools usage level of expertise
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
Q91. Stock Management how can manage on Excel and software
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.
Q92. Skip rows in an excel in SSIS
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
Q93. Online assessment in Excel
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
Q94. Weekly weekly payment method of Excel using
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
Q95. How to get data from one sheet to another work book having reference data in excel?
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
Q96. Proficiency with excel and excel macros ??
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.
Q97. Data analytics using excel
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
Q98. For reapet last action what is the shortcut key in excel?
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.
Q99. Experience with Excel and QuickBooks
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
Q100. Dropdown list in excel
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
Top Interview Questions for Related Skills
Interview Questions of Excel Related Designations
Interview experiences of popular companies
Reviews
Interviews
Salaries
Users/Month