- What is the IF function?
It performs logical tests. Example: =IF(A1>50,”Pass”,”Fail”) - What is nested IF?
Using multiple IF functions within one formula. - What is the AND function?
Returns TRUE if all conditions are true. - What is the OR function?
Returns TRUE if any condition is true. - What is the NOT function?
Reverses logical value. - What is VLOOKUP?
Searches value vertically in a table. - Syntax of VLOOKUP?
=VLOOKUP(value, table, col_index, FALSE) - What is HLOOKUP?
Searches horizontally in a table. - What is XLOOKUP?
Advanced lookup function replacing VLOOKUP. - Difference between VLOOKUP and XLOOKUP?
XLOOKUP is more flexible and supports both directions. - What is MATCH function?
Returns position of a value. - What is INDEX function?
Returns value from a table based on position. - What is INDEX + MATCH?
Advanced lookup combination. - What is CONCAT function?
Joins text values. - What is TEXT function?
Formats numbers as text. - What is LEFT function?
Extracts characters from left. - What is RIGHT function?
Extracts characters from right. - What is MID function?
Extracts characters from middle. - What is LEN function?
Counts characters in text. - What is TRIM function?
Removes extra spaces. - What is UPPER function?
Converts text to uppercase. - What is LOWER function?
Converts text to lowercase. - What is PROPER function?
Capitalizes first letter. - What is FIND function?
Finds position of text. - What is SUBSTITUTE?
Replaces specific text. - What is COUNTIF?
Counts cells based on condition. - What is SUMIF?
Adds values based on condition. - What is AVERAGEIF?
Calculates average based on condition. - What is COUNTIFS?
Counts with multiple conditions. - What is SUMIFS?
Adds with multiple conditions. - What is AVERAGEIFS?
Average with multiple conditions. - What is conditional formatting?
Applies formatting based on rules. - Example of conditional formatting?
Highlight values > 100. - What is data validation?
Restricts user input. - How to create drop-down list?
Using Data Validation. - What is pivot table?
Summarizes data. - What is pivot chart?
Chart based on pivot table. - What is slicer?
Filter tool for pivot tables. - What is timeline?
Date filter in pivot tables. - What is sorting by multiple columns?
Sorting using more than one field. - What is custom sort?
Sorting based on custom rules. - What is filter by color?
Filter based on cell color. - What is advanced filter?
Filter with complex criteria. - What is remove duplicates?
Deletes repeated values. - What is text to columns?
Splits data. - What is flash fill?
Auto pattern recognition. - What is named range?
Assign name to range. - How to create named range?
Using Name Box. - What is table in Excel?
Structured data format. - Benefits of table?
Auto formatting, filtering. - What is structured reference?
Using table names in formulas. - What is error in Excel?
Invalid formula result. - Common errors?
#DIV/0!, #VALUE!, #REF! - What is IFERROR?
Handles errors in formulas. - What is absolute reference?
Fixed reference ($A$1). - What is mixed reference?
Partial fixed reference. - What is relative reference?
Changes when copied. - What is data consolidation?
Combining data from multiple sheets. - What is grouping?
Group rows/columns. - What is subtotal?
Auto calculation for groups. - What is scenario manager?
What-if analysis tool. - What is goal seek?
Find input value for desired result. - What is data table?
Analyze multiple values. - What is chart formatting?
Customizing charts. - What is combo chart?
Combines two chart types. - What is sparkline?
Mini chart in cell. - What is hyperlink?
Link to resource. - What is protection?
Lock cells/sheets. - What is freeze panes?
Locks rows/columns. - What is split window?
Divide worksheet view. - What is macro?
Automates tasks. - What is VBA?
Programming in Excel. - How to record macro?
Use Record Macro option. - What is workbook link?
Connects two files. - What is external reference?
Reference to another workbook. - What is data import?
Import data from sources. - What is CSV file?
Comma-separated values file. - What is text file import?
Load text data. - What is Power Query?
Data transformation tool. - What is refresh data?
Update imported data. - What is pivot cache?
Stores pivot data. - What is drill down?
View detailed data. - What is dashboard?
Visual data summary. - What is KPI?
Key performance indicator. - What is timeline slicer?
Date filtering tool. - What is workbook sharing?
Multiple users access. - What is co-authoring?
Real-time editing. - What is OneDrive integration?
Cloud storage support. - What is version history?
Track changes. - What is comments feature?
Collaboration notes. - What is track changes?
Monitor edits. - What is formula auditing?
Trace formula errors. - What is watch window?
Monitor cells. - What is evaluate formula?
Step-by-step calculation. - What is data model?
Relational data structure. - What is Power Pivot?
Advanced data modeling. - What is DAX?
Formula language in Power Pivot.
📢 Join Our WhatsApp Channel
💼 Get Daily IT Job Updates, Interview Preparation Tips & Instant Alerts directly on WhatsApp.
👉 Join WhatsApp Now📢 Join Our Telegram Channel
💼 Get Daily IT Job Updates, Interview Tips & Exclusive Alerts directly on Telegram!
👉 Join Telegram