Top 30 interview questions and answers for ms excel

In this blog post, we will be discussing how you can use Microsoft Excel to make preparing interview questions and answers easier. The first section of the article will focus on your resume, while the second section discusses an effective way to prepare for a job interview. We’ll also give you some handy tips that should help put your best foot forward in any situation!

1. How do you make a graph in Microsoft Excel?

First, you need to open up Excel. Then, select “New” from the top toolbar. Now, go to the left side of the screen and click on “chart”. Select a chart type that is relevant for your data, then drag your mouse over the grid below to populate your chart with the data from your spreadsheet. Voila! You now have a graph/chart to display/present your data effectively.

2. How do you change the background color of your spreadsheet?

To do this, you will need to go into Page Layout. You can then choose what colors and patterns fit with your presentation (or look good on the page). However, we recommend using an easily readable light blue, white or gray background – black and dark blues tend not to work as well.

3. What is a conditional formula?

A conditional formula is a type of Excel formula that checks for certain conditions and returns one value if those values meet the condition and another value if they do not. For example: “=If(B2>$C$2, 10%*B2, 0)” would be a conditional formula because it calculates 10% of B2 if it is greater than C2, otherwise it would give a 0 result.

4. What do you use Excel for?

Excel allows you to store and present large amounts of data in an organized fashion that aids not only yourself but numbers-savvy managers or business owners as well. With this program, you’re able to provide graphical and statistical analysis of data which can be used for: tracking sales performance identifying product trends spotting production bottlenecks effectively planning future stock inventory organizing company financial information analyzing the effectiveness of marketing campaigns 5. What are Pivot Tables? A pivot table allows users to summarize and analyze large volumes of data within Microsoft Excel (or other spreadsheet programs).

5. What is a VLOOKUP formula?

VLOOKUP is a function in Excel that allows users to search for a value in the leftmost column of a table and return the corresponding value from a row you specify in your table. For example: “=VLOOKUP(“Jones”, B: C,3)” would look for “Jones” in the first column of B: C and then return the 3rd item in that row.

7. What is Microsoft Access?

An application used to store and manage data within an organization (allows users to create large databases). An advantage of the program is its ability to work with many other applications such as Word Excel or PowerPoint, making it very versatile when working with information stored on your computer.

8. What are the steps to creating a basic spreadsheet?

First, open Microsoft Excel and go to “File” -> “New”. You will then see a pop-up window with different templates – select the Blank Workbook template. This will create a new, blank spreadsheet for you to work with. To enter data into your spreadsheet, simply type it into the cells that correspond with the row and column headings. To format your data or create formulas, use the menus and buttons along the top of the screen. When you’re done editing your spreadsheet, save it by going to “File” -> “Save As” and select a file name and location.

9. How do you password protect your Excel spreadsheet?

If you want to password protect your Excel spreadsheet, go to “Tools” -> “Options”. Click on the “General” tab. In order for this feature to work, you need to enable macros by going into the options menu and checking to mark it. Finally, type your password in both boxes under “Password to Unprotect Sheet”,

10. How do you make a graph or chart in Excel?

First, open up Microsoft Excel and go to New from the toolbar at the top of the program screen. Select a template that is relevant for your data (Ex: Pie Chart) and drag over your mouse over the grid below until you have selected all of your data points then release your mouse. Once you have your data selected, drag it over to the “Insert” toolbar on the left of the screen and select a graph or chart that is relevant for those data points (Ex: Scatter Chart). You can then edit all of your options such as colors and size of information by clicking on the legend at the bottom right-hand corner – this will allow you to click and drag each object so you can format them individually.

11. What is a macro?

A macro is a sequence of commands stored in a file with a .mcr extension which allows users to automate certain tasks within Microsoft Access. For example, if someone has 20 different queries that they need to run every morning, could just create one macro that will run all queries at once.

12. What is an SQL statement?

An SQL (Structured Query Language) statement is used to communicate with a database in order to retrieve, insert, update or delete the information within it. For example: DELETE FROM Customers WHERE CustomerName=’Jones’ would delete any record where the value “Jones” appeared in the “CustomerName” column of the table named “Customers.” There are many different types of statements one could create using this programming language – they can be simple like our example above or complex and involve multiple layers of coding that allow for more specific tasks to be executed on your data.

13. What is a VLOOKUP function?

The VLOOKUP function is a Microsoft Excel built-in function that allows you to look up a value in one column of data and return the corresponding value from another column. For example: “=VLOOKUP(“Jones”, B: C,3)” would look for “Jones” in the first column of B:C and then return the 3rd item in that row. This can be useful when you are working with large data sets as it allows you to quickly find and extract specific information without having to search through the entire table.

14. What is an IF statement?

An IF statement (short for “if-then”) is a type of conditional statement that allows you to run a set of commands or instructions based on the result of a specified condition. For example: “=IF(A1>100,10,5)” would return the value 10 if A1 was greater than 100, and 5 if it was not. This can be helpful for automating certain tasks or calculations in your spreadsheet as it allows you to create different outcomes depending on the data that is inputted into the cells.

15. What is an array?

An array is a collection of data that is stored in a single variable and can be accessed using a unique subscript. For example: “A(1)=”Hello” would return the value “Hello” when subscript 1 was used. Arrays can be helpful when working with data sets that are too large to fit into a single cell, as they allow you to store the information in multiple locations which can then be easily accessed and processed.

16. What is a PivotTable?

A PivotTable is a Microsoft Excel built-in function that allows you to quickly summarize large data sets by creating pivot tables and charts. This can be done by dragging and dropping fields from your table onto the designated areas within the PivotTable, after which you can then drag and drop the fields around to get an overview of the data that you are looking for. For example, you could create a PivotTable that shows how much money was made each month over the past year, or how many products were sold each day of the week.

17. What is an algorithm?

An algorithm is a set of instructions or steps that can be used to solve a problem or complete a task. For example, an algorithm for finding the largest number in a list of numbers could look something like this:

1) Start by checking the first number in the list.

2) If the number is larger than the largest number that has been found so far, then add it to the list of largest numbers and go to step 1.

3) If the number is not larger than the largest number that has been found so far, then check the second number in the list.

4) If the number is larger than the largest number that has been found so far, then add it to the list of largest numbers and go to step 1.

5) If the number is not larger than the largest number that has been found so far, then check the third number in the list.

18. What is an API?

An API (short for “application programming interface”) allows programmers to access web-based pieces of software in order to write, modify, and run code on them. This can be useful when creating new programs or tools that work with already existing ones, as it means that certain processes do not need to be recreated every time they are used.

19. What is a subroutine?

A subroutine is another name for a function – it simply refers to the section of code that contains the instructions itself rather than calling upon it somewhere else within the program. For example, You could create your own subroutine for checking if two numbers are equal, which would allow you to use this set of instructions inside other parts of your code. This can be helpful for both efficiency and readability, as it keeps your code organized and easy to follow.

20. What is a macro?

A macro is a type of subroutine that allows you to automate certain tasks or actions within Microsoft Excel. For example, you could create a macro that would automatically format all the cells in a worksheet as currency or one that would insert a standard disclaimer at the bottom of all your emails. Macros can be very useful time-savers, as they allow you to complete complex tasks with just a few simple clicks.

Microsoft Excel is a powerful data analysis tool that can be used for everything from simple calculations to creating complex pivot tables and charts. By learning the basics of Excel – including how to create and use formulas, arrays, pivot tables, and macros – you can become a more efficient and productive data analyst.

21. What is a formula?

A formula is a set of instructions in Microsoft Excel that allows you to perform calculations and return results. These can be built-in functions such as =SUM(), or they can also be custom calculations written with the use of different operators. For example, if your spreadsheet contained data about how many units of something you had sold each month, then creating a monthly running total by using cells containing formulas such as =SUM($B$2:$B$7) would give you an automatically updated value at the bottom of each column.

22. What are array formulas?

Array formulas work in the same way as regular formulas do in Microsoft Excel, except that instead of returning individual values, they will return

As you can see, Microsoft Excel is a versatile tool that can be used for a variety of tasks. By learning the basics of Excel, you can become a more efficient and productive data analyst. Thanks for reading!

23. What are pivot tables?

A pivot table is a type of data summarization tool that can be used for quickly analyzing large amounts of data. They work by automatically creating new “rows” and “columns” based on the aggregated data contained within an original worksheet. By organizing this information into visual, easy-to-read charts, pivot tables allow you to find trends and patterns that could otherwise take hours to pinpoint with manual analysis.

24. What is a pivot chart?

A pivot chart works in the same way as a regular pivot table, except that instead of filtering information based on what it contains, it will display this data with the use of charts and graphs. This can be helpful for visualizing large quantities of data in a more effective way, which can lead to new insights into your data set.

As you can see, Microsoft Excel is a versatile tool that can be used for a variety of tasks. By learning the basics of Excel, you can become a more efficient and productive data analyst.

25. What is a VLOOKUP function?

The VLOOKUP function is a built-in Excel function that allows you to look up and return information from a table or list. It works by searching for a specific value (the “lookup_value”) in the first column of the table, and then return the corresponding value from the same row in the table’s second column.

For example, if you had a list of names and their corresponding birth years, you could use a VLOOKUP function to look up someone’s age by typing their name into a cell. The function would search its first column for this name, return the corresponding birth year from the second column of the table, and then calculate the person’s age by subtracting the year of birth from the current year.

Top 30 interview questions and answers for ms excel
Top 30 interview questions and answers for ms excel

Leave a Reply

Your email address will not be published.