*Excel interview questions with answers*! 1. *What is Excel used for?* Excel is used for organizing, analyzing, and visualizing data with spreadsheets. 2. *What are formulas and functions in Excel?* Formulas are user-defined calculations, while functions (like SUM, AVERAGE, IF) are built-in operations to process data. 3. *What is a cell reference?* A cell reference (like A1, B2) points to a specific cell in a worksheet, and can be relative, absolute, or mixed. 4. *What are pivot tables?* Pivot tables help you summarize, analyze, and explore large datasets quickly. 5. *What is conditional formatting?* Conditional formatting lets you highlight cells based on specific rules or criteria (like coloring all values above 100). 6. *How do you create a chart in Excel?* Select your data, then go to the Insert tab and choose the chart type you want. 7. *What is data validation?* Data validation restricts the type of data that can be entered in a cell (like allowing only numbers or dates). 8. *What is the difference between a workbook and a worksheet?* A workbook is the entire Excel file, while a worksheet is a single tab/sheet within that file. 9. *What is VLOOKUP?* VLOOKUP is a function to search for a value in the first column of a range and return a value in the same row from another column. 10. *How do you freeze panes?* Go to the View tab and use Freeze Panes to keep rows/columns visible while scrolling. *React ❤️ for more*