Data Analytics

Excel Interview Questionswith Answers Part-1✅ 1. What is Microsoft Excel? Excel is a spreadsheet software developed by Microsoft used for storing, organizing, and analyzing data in tabular form. It supports formulas, functions, charts, and pivot tables to help with data management and visualization. 2. Explain the key features of Excel. Key features include: ⦁ Grid of cells for data entry ⦁ Formulas and functions for calculations ⦁ Pivot Tables for summarizing data ⦁ Charts and graphs for visualization ⦁ Conditional formatting to highlight data ⦁ Data validation and filtering ⦁ Macro recording for automation 3. What are the different types of data you can enter in Excel? Excel accepts: ⦁ Numbers (integers, decimals) ⦁ Text (strings) ⦁ Dates and times ⦁ Boolean values (TRUE/FALSE) ⦁ Formulas ⦁ Errors (like #DIV/0!) ⦁ Blank cells 4. How do you use formulas and functions in Excel? Formulas start with an = sign and perform calculations using arithmetic operators and cell references, e.g., =A1+B1. Functions are pre-built formulas like SUM(), AVERAGE(), which simplify complex calculations, e.g., =SUM(A1:A10). 5. What is the difference between a relative, absolute, and mixed cell reference? ⦁ Relative (e.g., A1): adjusts when copied across cells ⦁ Absolute (e.g., $A$1): stays fixed when copied ⦁ Mixed (e.g., $A1 or A$1): part fixed, part relative 6. What are common Excel functions you have used? Popular functions include: ⦁ SUM(), AVERAGE(), COUNT() ⦁ VLOOKUP(), HLOOKUP() ⦁ IF(), AND(), OR() ⦁ INDEX(), MATCH() ⦁ CONCATENATE() or TEXTJOIN() 7. Explain how to create and use Pivot Tables. Pivot Tables summarize data by grouping and aggregating it dynamically. You select your data range, go to Insert > PivotTable, then drag fields into Rows, Columns, and Values areas to analyze data from different perspectives. 8. How can you filter and sort data in Excel? ⦁ Filter: Select data range, then Data > Filter to add dropdown arrows for column filtering by criteria ⦁ Sort: Select a column or range, then Data > Sort to order data ascending or descending based on one or more columns 9. What is conditional formatting and how is it used? Conditional formatting applies visual formatting (colors, icons) to cells based on defined rules, helping to highlight trends or outliers. For example, cells with values above a threshold can be shaded green. 10. How do you protect a worksheet or workbook? You can protect sheets by going to Review > Protect Sheet and setting a password to restrict editing. Workbook protection via Review > Protect Workbook secures the structure (adding/removing sheets) or windows. React ♥️ if this helped you