Post #2424

✅15 Excel Interview Questions for Freshers📊🧠 1️⃣What is Microsoft Excel used for? Answer: Excel is a spreadsheet program used for data entry, analysis, calculations, and visualization. 2️⃣What is a cell in Excel? Answer: A cell is the intersection of a row and column where data is entered (e.g., A1, B2). 3️⃣What is the difference between a workbook and a worksheet? Answer: A workbook is the entire Excel file. A worksheet is a single tab/sheet within that file. 4️⃣What are formulas in Excel? Answer: Formulas are expressions used to perform calculations using cell references and operators. 5️⃣What is the difference between a formula and a function? Answer: A formula is manually written; a function is a built-in command like SUM(), AVERAGE(). 6️⃣What does the VLOOKUP function do? Answer: Searches for a value in the first column of a table and returns data from another column. 7️⃣What is the difference between absolute and relative cell references? Answer: Relative references (A1) change when copied; absolute references (A1) stay fixed. 8️⃣What is conditional formatting? Answer: It highlights cells based on rules (e.g., color cells above 100 in red). 9️⃣How do you create a chart in Excel? Answer: Select data → Insert → Choose chart type (e.g., bar, line, pie). 1️⃣0️⃣What is a Pivot Table? Answer: A tool to summarize, group, and analyze large data sets interactively. 1️⃣1️⃣What is the IF function? Answer: A logical function: IF(condition, value_if_true, value_if_false). 1️⃣2️⃣What is the use of data validation? Answer: Restricts data entry to specific types (e.g., numbers only, dropdown lists). 1️⃣3️⃣How do you protect a worksheet? Answer: Go to Review → Protect Sheet → Set password and options. 1️⃣4️⃣What is the CONCATENATE function used for? Answer: Combines text from multiple cells into one. (Now replaced by TEXTJOIN or CONCAT). 1️⃣5️⃣What are Excel shortcuts you should know? Answer: - Ctrl + C: Copy - Ctrl + V: Paste - Ctrl + Z: Undo - Ctrl + Shift + L: Toggle filter Excel Resources: https://whatsapp.com/channel/0029VaifY548qIzv0u1AHz3i 💬React with ❤️ if this helped you!