Which Excel feature allows you to summarize large datasets dynamically?
A) PivotTable B) Data Table C) Filter D) Chart
Answer: A) PivotTable

To refresh a PivotTable, you can press:
A) Alt + F5 B) F9 C) Ctrl + Alt + F5 D) Ctrl + R
Answer: C) Ctrl + Alt + F5

In a PivotTable, the “Values” area usually contains:
A) Numerical fields B) Text fields C) Dates D) Filters
Answer: A) Numerical fields

Which option lets you group PivotTable data by month or year?
A) Group Field B) Filter Field C) Data Slice D) Aggregate Field
Answer: A) Group Field

Slicers are used in Excel to:
A) Filter PivotTable data visually B) Sort worksheets C) Merge cells D) Highlight duplicates
Answer: A) Filter PivotTable data visually

Timelines in Excel work specifically with:
A) Date fields B) Text fields C) Numeric IDs D) Chart labels
Answer: A) Date fields

Which Excel feature allows creating a 3D map visualization?
A) Power Map B) SmartArt C) Power View D) Data Bars
Answer: A) Power Map

Power Query is primarily used for:
A) Data import and transformation B) Chart design C) Cell formatting D) VBA automation
Answer: A) Data import and transformation

To open Power Query Editor:
A) Data → Get & Transform → Launch Editor B) Insert → Chart C) Review → Track Changes D) Home → Paste Special
Answer: A) Data → Get & Transform → Launch Editor

Power Pivot helps in:
A) Managing large data models B) Editing macros C) Designing templates D) Creating comments
Answer: A) Managing large data models

Which add-in allows DAX calculations in Excel?
A) Power Pivot B) Solver C) Analysis ToolPak D) Power View
Answer: A) Power Pivot

In Power Pivot, relationships are built using:
A) Primary and foreign keys B) Formulas C) Filters D) Styles
Answer: A) Primary and foreign keys

What does the DAX function CALCULATE() do?
A) Modifies filter context B) Adds numbers C) Returns average D) Creates charts
Answer: A) Modifies filter context

The DAX function RELATED() is used to:
A) Retrieve values from related tables B) Merge text C) Compare data D) Sort lists
Answer: A) Retrieve values from related tables

Power View is used for:
A) Interactive data visualization B) File encryption C) Worksheet protection D) Formula auditing
Answer: A) Interactive data visualization

To activate Developer tab, you must:
A) Enable it from Excel Options → Customize Ribbon B) Press Alt + F11 C) Use Ctrl + D D) Open Power Query
Answer: A) Enable it from Excel Options → Customize Ribbon

The VBA editor opens with:
A) Alt + F11 B) Ctrl + Alt + F1 C) Shift + F11 D) F10
Answer: A) Alt + F11

VBA stands for:
A) Visual Basic for Applications B) Visual Basic Analyzer C) Visual Base Automation D) Variable Based Application
Answer: A) Visual Basic for Applications

In VBA, which keyword defines a variable?
A) Dim B) Var C) Let D) Const
Answer: A) Dim

To execute a VBA macro, you can press:
A) Alt + F8 B) Ctrl + M C) F9 D) Shift + F5
Answer: A) Alt + F8

A macro can be stored in:
A) Personal Macro Workbook B) Template File C) Add-in D) All of the above
Answer: D) All of the above

File extension for macro-enabled workbook:
A) .xlsm B) .xlsx C) .csv D) .xltx
Answer: A) .xlsm

Which function is used in VBA to display a message box?
A) MsgBox() B) Print() C) Show() D) Display()
Answer: A) MsgBox()

The InputBox() function in VBA is used to:
A) Get user input B) Display alert C) Open file D) Close workbook
Answer: A) Get user input

To protect a worksheet:
A) Review → Protect Sheet B) Data → Validation C) Home → Format D) File → Info
Answer: A) Review → Protect Sheet

To remove protection:
A) Review → Unprotect Sheet B) File → Options C) Data → Sort D) Home → Clear
Answer: A) Review → Unprotect Sheet

You can protect a workbook structure using:
A) Review → Protect Workbook B) File → Save As C) Home → Protect Range D) Data → Protect
Answer: A) Review → Protect Workbook

A workbook password can be set from:
A) File → Info → Protect Workbook → Encrypt with Password B) Data → Tools C) Review → Comments D) View → Options
Answer: A) File → Info → Protect Workbook → Encrypt with Password

To restrict editing in Excel:
A) File → Info → Protect Workbook → Restrict Access B) Review → Track Changes C) View → Page Layout D) Home → Cells
Answer: A) File → Info → Protect Workbook → Restrict Access

Which Excel feature records changes made by multiple users?
A) Track Changes B) Solver C) Formulas D) Flash Fill
Answer: A) Track Changes

Shared workbook feature allows:
A) Multiple users to edit the same workbook B) Password protection C) Hiding sheets D) Linking files
Answer: A) Multiple users to edit the same workbook

Co-authoring in modern Excel replaces:
A) Shared Workbook B) Data Tables C) Templates D) Power Query
Answer: A) Shared Workbook

To insert a chart quickly, press:
A) Alt + F1 B) F11 C) Alt + F2 D) Ctrl + Shift + C
Answer: A) Alt + F1

A chart on a separate sheet is called:
A) Chart Sheet B) Pivot Chart C) Graph Page D) Data Chart
Answer: A) Chart Sheet

To switch chart rows and columns:
A) Design → Switch Row/Column B) Data → Sort C) View → Transpose D) Insert → Convert
Answer: A) Design → Switch Row/Column

To change chart type:
A) Design → Change Chart Type B) Home → Format C) Data → Sort D) View → Switch
Answer: A) Design → Change Chart Type

A combination chart allows:
A) Two chart types on one chart B) Multiple sheets C) Macros D) Filters
Answer: A) Two chart types on one chart

Sparkline is used to:
A) Show mini charts inside cells B) Insert hyperlinks C) Highlight duplicates D) Calculate totals
Answer: A) Show mini charts inside cells

Conditional formatting allows you to:
A) Format cells based on criteria B) Change sheet names C) Protect cells D) Insert images
Answer: A) Format cells based on criteria

Data Validation can:
A) Restrict data entry based on rules B) Merge data C) Protect workbooks D) Sort data
Answer: A) Restrict data entry based on rules

To apply data validation for list entries:
A) Data → Data Validation → Allow: List B) Home → Format C) Insert → Table D) Review → Protect
Answer: A) Data → Data Validation → Allow: List

Flash Fill is used to:
A) Automatically fill values based on patterns B) Copy formulas C) Highlight rows D) Merge columns
Answer: A) Automatically fill values based on patterns

Shortcut for Flash Fill:
A) Ctrl + E B) Alt + E C) Ctrl + Shift + E D) F9
Answer: A) Ctrl + E

The Goal Seek feature is found under:
A) Data → What-If Analysis B) Formulas → Audit C) Review → Track D) View → Macros
Answer: A) Data → What-If Analysis

Scenario Manager is used for:
A) Creating multiple data outcome models B) Data sorting C) Chart animation D) Sheet protection
Answer: A) Creating multiple data outcome models

Data Table in What-If Analysis allows:
A) Testing formulas for different inputs B) Creating PivotTables C) Summarizing data D) Copying charts
Answer: A) Testing formulas for different inputs

Solver is used for:
A) Optimization problems B) Statistical summaries C) Sorting data D) Finding duplicates
Answer: A) Optimization problems

Analysis ToolPak provides:
A) Advanced statistical analysis tools B) Chart templates C) Formatting options D) Keyboard shortcuts
Answer: A) Advanced statistical analysis tools

To enable Analysis ToolPak:
A) File → Options → Add-ins → Manage Excel Add-ins B) Data → Analysis C) View → Macros D) Review → Comments
Answer: A) File → Options → Add-ins → Manage Excel Add-ins

The FORECAST() function is used to:
A) Predict a future value based on existing data B) Calculate averages C) Sort lists D) Validate data
Answer: A) Predict a future value based on existing data

The TREND() function:
A) Returns values along a linear trend B) Finds average C) Merges data D) Displays chart
Answer: A) Returns values along a linear trend

The GROWTH() function performs:
A) Exponential curve fitting B) Linear regression C) Counting D) Filtering
Answer: A) Exponential curve fitting

The RSQ() function returns:
A) The square of the Pearson correlation coefficient B) Regression intercept C) Mean D) Slope
Answer: A) The square of the Pearson correlation coefficient

The SLOPE() function returns:
A) Slope of the linear regression line B) Correlation C) Mean D) Range
Answer: A) Slope of the linear regression line

The INTERCEPT() function returns:
A) Y-intercept of regression line B) Correlation C) Mode D) Median
Answer: A) Y-intercept of regression line

The STEYX() function returns:
A) Standard error of predicted Y values B) Standard deviation C) Median D) Mode
Answer: A) Standard error of predicted Y values

Which function performs multiple criteria lookup?
A) XLOOKUP() B) VLOOKUP() C) INDEX() D) SEARCH()
Answer: A) XLOOKUP()

XLOOKUP() replaces which two older functions?
A) VLOOKUP() and HLOOKUP() B) SUM() and COUNT() C) IF() and OR() D) LEFT() and RIGHT()
Answer: A) VLOOKUP() and HLOOKUP()

XMATCH() function returns:
A) Relative position of an item B) Matching cell value C) Cell address D) Formula result
Answer: A) Relative position of an item

The INDEX-MATCH combination is used instead of:
A) VLOOKUP() B) SUMIF() C) COUNTIF() D) CONCAT()
Answer: A) VLOOKUP()

To combine text from multiple cells:
A) CONCAT() B) SUM() C) PRODUCT() D) MID()
Answer: A) CONCAT()

CONCATENATE() function is replaced by:
A) CONCAT() and TEXTJOIN() B) JOIN() C) COMBINE() D) MERGE()
Answer: A) CONCAT() and TEXTJOIN()

TEXTJOIN() allows you to:
A) Specify a delimiter B) Merge sheets C) Create formulas D) Delete spaces
Answer: A) Specify a delimiter

SUBSTITUTE() function replaces:
A) Old text with new text B) Formulas C) Numbers D) Dates
Answer: A) Old text with new text

REPLACE() function changes:
A) Part of a text string by position B) Values in range C) Formats D) Styles
Answer: A) Part of a text string by position

TRIM() removes:
A) Extra spaces from text B) All punctuation C) Formulas D) Numbers
Answer: A) Extra spaces from text

CLEAN() removes:
A) Non-printable characters B) Extra spaces C) Duplicates D) Formulas
Answer: A) Non-printable characters

PROPER() converts text to:
A) Proper case B) Uppercase C) Lowercase D) Sentence case
Answer: A) Proper case

UPPER() converts text to:
A) Uppercase B) Lowercase C) Proper case D) Mixed case
Answer: A) Uppercase

LOWER() converts text to:
A) Lowercase B) Uppercase C) Proper case D) Sentence case
Answer: A) Lowercase

EXACT() function checks if:
A) Two text strings are identical B) Numbers match C) Values are blank D) Strings contain digits
Answer: A) Two text strings are identical

FIND() function returns:
A) Position of a substring B) Text value C) Cell address D) Word count
Answer: A) Position of a substring

SEARCH() function differs from FIND() because it:
A) Is not case-sensitive B) Is faster C) Returns formulas D) Counts cells
Answer: A) Is not case-sensitive

MID() extracts text from:
A) Middle of a string B) Start C) End D) Random position
Answer: A) Middle of a string

LEFT() extracts characters from:
A) Beginning of a string B) End C) Middle D) Next cell
Answer: A) Beginning of a string

RIGHT() extracts characters from:
A) End of a string B) Start C) Middle D) Formula
Answer: A) End of a string

LEN() returns:
A) Number of characters in text B) Cell width C) File size D) Row length
Answer: A) Number of characters in text

VALUE() converts:
A) Text to number B) Number to text C) Formula to text D) Date to text
Answer: A) Text to number

CODE() returns:
A) Numeric code for first character B) ASCII of last C) Unicode text D) Binary code
Answer: A) Numeric code for first character

CHAR() returns:
A) Character from code number B) Code from character C) Cell address D) Random text
Answer: A) Character from code number

The TEXT() function can format:
A) Numbers and dates as text B) Charts C) Macros D) Comments
Answer: A) Numbers and dates as text

Custom number format “#,##0.00” means:
A) Commas for thousands, two decimal places B) Percent style C) Date format D) Scientific notation
Answer: A) Commas for thousands, two decimal places

Conditional format icon sets show:
A) Visual indicators (arrows, bars) B) Numbers C) Comments D) Errors
Answer: A) Visual indicators (arrows, bars)

MS-excel extensions  ?  Ans. .exex