Top EXCEL Interview Questions and Answers (2023)
What is a cell in Excel?
A cell is the basic unit in Excel where you can enter and manipulate data.
What is a workbook?
A workbook is a file in Excel that contains multiple worksheets.
How do you create a new workbook in Excel?
To create a new workbook, you can click on the “File” tab, then select “New” and choose “Blank Workbook.”
What is a worksheet?
A worksheet is a single sheet within a workbook where you can organize and analyze data.
How many rows and columns are there in a worksheet?
Excel has 1,048,576 rows and 16,384 columns in each worksheet.
What is a formula in Excel?
A formula is an equation that performs calculations and returns a value. It begins with an equal sign (=).
What is the difference between a relative reference and an absolute reference in a formula?
A relative reference adjusts based on the location where it is copied, while an absolute reference remains fixed.
How do you create a chart in Excel?
To create a chart, select the data you want to include, go to the “Insert” tab, and choose the desired chart type.
What is conditional formatting?
Conditional formatting is a feature in Excel that allows you to apply formatting based on specific conditions or rules.
How do you freeze panes in Excel?
To freeze panes, go to the “View” tab, select “Freeze Panes,” and choose the desired option.
What is the VLOOKUP function used for?
The VLOOKUP function is used to search for a value in the leftmost column of a table and return a corresponding value from a specified column.
What is the CONCATENATE function used for?
The CONCATENATE function is used to join multiple text strings together.
What is a pivot table?
A pivot table is a powerful data summarization tool in Excel that allows you to analyze and manipulate large amounts of data.
How do you sort data in Excel?
To sort data, select the range you want to sort, go to the “Data” tab, and click on the “Sort” button.
What is the MAX function used for?
The MAX function is used to find the highest value in a range of cells.
How do you protect cells in Excel?
To protect cells, select the cells you want to protect, right-click, choose “Format Cells,” go to the “Protection” tab, and check the “Locked” box. Then, protect the worksheet under the “Review” tab.
What is the COUNTIF function used for?
The COUNTIF function is used to count the number of cells that meet a specific criterion.
How do you insert a new row or column in Excel?
To insert a new row, right-click on the row number and select “Insert.” To insert a column, right-click on the column letter and select “Insert.”
What is the difference between CONCATENATE and TEXTJOIN functions?
CONCATENATE is used to join text strings, while TEXTJOIN is more powerful and can handle ranges of cells with a specified delimiter.
How do you find and replace data in Excel?
To find and replace data, press Ctrl + F to open the “Find and Replace” dialog box, enter the text to find and replace, and click on the “Replace All” button.
What is the SUMIF function used for?
The SUMIF function is used to add up the values in a range of cells that meet a specific criterion.
How do you create a drop-down list in Excel?
To create a drop-down list, go to the “Data” tab, click on the “Data Validation” button, select “List” as the validation criteria, and enter the values you want to include.
What is the difference between COUNT and COUNTA functions?
COUNT counts only the cells that contain numbers, while COUNTA counts all non-empty cells, including text and logical values.
What is the IF function used for?
The IF function is used to perform a logical test and return different values based on the result.
How do you remove duplicates in Excel?
To remove duplicates, select the range of cells, go to the “Data” tab, click on the “Remove Duplicates” button, and choose the criteria for duplicate removal.
What is the AVERAGE function used for?
The AVERAGE function is used to calculate the average of a range of numbers.
How do you insert a comment in Excel?
To insert a comment, right-click on the cell where you want to add the comment, select “Insert Comment,” and enter your comment in the text box.
What is the TODAY function used for?
The TODAY function is used to display the current date.
How do you change the number format in Excel?
To change the number format, select the cell or range of cells, right-click, choose “Format Cells,” and select the desired format under the “Number” tab.
What is the NETWORKDAYS function used for?
The NETWORKDAYS function is used to calculate the number of working days between two dates, excluding weekends and specified holidays.
How do you remove gridlines in Excel?
To remove gridlines, go to the “View” tab, uncheck the “Gridlines” option in the “Show” group.
What is the COUNT function used for?
The COUNT function is used to count the number of cells that contain numbers in a range.
How do you merge cells in Excel?
To merge cells, select the cells you want to merge, right-click, choose “Format Cells,” go to the “Alignment” tab, and check the “Merge cells” box.
What is the PMT function used for?
The PMT function is used to calculate the periodic payment for a loan or investment with constant payments and interest rate.
How do you hide columns or rows in Excel?
To hide columns, select the columns you want to hide, right-click, and choose “Hide.” To hide rows, follow the same steps for rows.
What is the NOW function used for?
The NOW function is used to display the current date and time.
How do you create a hyperlink in Excel?
To create a hyperlink, select the cell or text you want to hyperlink, right-click, choose “Hyperlink,” and enter the destination URL or file path.
What is the ROUND function used for?
The ROUND function is used to round a number to a specified number of decimal places.
How do you split text into columns in Excel?
To split text into columns, select the cells containing the text, go to the “Data” tab, click on the “Text to Columns” button, and choose the delimiter for splitting.
What is the SUMIFS function used for?
The SUMIFS function is used to add up the values in a range of cells that meet multiple criteria.
How do you change the font size in Excel?
To change the font size, select the cell or range of cells, go to the “Home” tab, and choose the desired font size from the font size dropdown.
What is the INDEX function used for?
The INDEX function is used to return the value of a cell within a specified range based on its row and column numbers.
How do you protect a worksheet in Excel?
To protect a worksheet, go to the “Review” tab, click on the “Protect Sheet” button, and enter a password if desired.
What is the LEFT function used for?
The LEFT function is used to extract a specified number of characters from the beginning of a text string.
How do you calculate the percentage in Excel?
To calculate a percentage, multiply the value by the percentage and format the cell as a percentage.
What is the TRANSPOSE function used for?
The TRANSPOSE function is used to change the orientation of a range of cells from rows to columns, or vice versa.
How do you add a header or footer in Excel?
To add a header or footer, go to the “Insert” tab, click on the “Header & Footer” button, and enter the desired content.
What is the MEDIAN function used for?
The MEDIAN function is used to calculate the middle value in a range of numbers.
How do you rename a worksheet in Excel?
To rename a worksheet, right-click on the sheet tab, select “Rename,” and enter the new name.
What is the IFERROR function used for?
The IFERROR function is used to handle errors and return a specified value if an error occurs.