Power Query in Excel is used for:
A) Importing, cleaning, and transforming data B) Creating charts C) Printing D) Formatting cells
Answer: A) Importing, cleaning, and transforming data

Power Query can be accessed from:
A) Data → Get & Transform B) View → Power Query C) Review → Tools D) Insert → Data
Answer: A) Data → Get & Transform

The Power Query Editor opens when you click:
A) Data → Get Data → Launch Editor B) Insert → Query C) View → Editor D) Home → View
Answer: A) Data → Get Data → Launch Editor

In Power Query, “Append Queries” is used to:
A) Combine tables vertically B) Combine horizontally C) Remove duplicates D) Group data
Answer: A) Combine tables vertically

“Merge Queries” in Power Query does what?
A) Joins two tables based on common fields B) Merges columns C) Removes blanks D) Filters rows
Answer: A) Joins two tables based on common fields

Power Pivot is primarily used for:
A) Data modeling and advanced analysis B) Chart creation C) Sorting D) Formatting
Answer: A) Data modeling and advanced analysis

DAX stands for:
A) Data Analysis Expressions B) Data Access Exchange C) Data Array Extension D) Database Access Expressions
Answer: A) Data Analysis Expressions

The Power Pivot window can be opened from:
A) Power Pivot → Manage B) Data → Tools C) View → Pivot D) Home → View
Answer: A) Power Pivot → Manage

To enable Power Pivot in Excel:
A) File → Options → Add-ins → COM Add-ins → Enable Power Pivot B) View → Enable C) Insert → Pivot D) Developer → Activate
Answer: A) File → Options → Add-ins → COM Add-ins → Enable Power Pivot

The function used to count cells that meet a single criterion is:
A) COUNTIF() B) COUNTIFS() C) SUMIF() D) AVERAGEIF()
Answer: A) COUNTIF()

COUNTIFS() is used for:
A) Counting cells meeting multiple criteria B) Counting empty cells C) Counting errors D) Counting characters
Answer: A) Counting cells meeting multiple criteria

SUMIFS() is used for:
A) Adding cells based on multiple conditions B) Counting blank cells C) Summing all D) Formatting
Answer: A) Adding cells based on multiple conditions

The AVERAGEIFS() function returns:
A) The average of cells that meet multiple criteria B) Median C) Mode D) Sum
Answer: A) The average of cells that meet multiple criteria

The function that checks multiple conditions and returns TRUE if any are TRUE:
A) OR() B) AND() C) IF() D) XOR()
Answer: A) OR()

The function that checks if all conditions are TRUE:
A) AND() B) OR() C) IF() D) NOT()
Answer: A) AND()

The function that reverses a logical value:
A) NOT() B) IFERROR() C) TRUE() D) FALSE()
Answer: A) NOT()

The function IFERROR(value, value_if_error) returns:
A) Alternative result if an error occurs B) Only numeric results C) Logical TRUE D) 0 for blank
Answer: A) Alternative result if an error occurs

The IFNA() function handles only:
A) #N/A errors B) #VALUE! errors C) #REF! errors D) #DIV/0! errors
Answer: A) #N/A errors

The function used to round a number to a specific number of digits:
A) ROUND() B) INT() C) TRUNC() D) FIXED()
Answer: A) ROUND()

ROUNDUP() always:
A) Rounds the number away from zero B) Rounds toward zero C) Rounds randomly D) Truncates digits
Answer: A) Rounds the number away from zero

ROUNDDOWN() always:
A) Rounds the number toward zero B) Away from zero C) Up to even D) Randomly
Answer: A) Rounds the number toward zero

INT() returns:
A) Integer part of a number B) Rounded value C) Decimal D) Negative sign
Answer: A) Integer part of a number

TRUNC() removes:
A) Fractional part of a number without rounding B) Leading zeros C) Digits before decimal D) Text
Answer: A) Fractional part of a number without rounding

MOD(number, divisor) returns:
A) The remainder B) The quotient C) The sum D) The average
Answer: A) The remainder

The function for random decimal numbers between 0 and 1:
A) RAND() B) RANDBETWEEN() C) RANDOMIZE() D) ROUND()
Answer: A) RAND()

RANDBETWEEN(1,10) generates:
A) Random integer between 1 and 10 B) Decimal number C) Random date D) Random text
Answer: A) Random integer between 1 and 10

The TODAY() function returns:
A) Current date B) Current time C) Date & time D) Month
Answer: A) Current date

The NOW() function returns:
A) Current date and time B) Only time C) Only date D) Year
Answer: A) Current date and time

The TEXT() function is used to:
A) Format numbers as text using a format code B) Convert text to numbers C) Count text D) Sort cells
Answer: A) Format numbers as text using a format code

The VALUE() function:
A) Converts text to numeric value B) Converts numbers to text C) Removes spaces D) Counts text
Answer: A) Converts text to numeric value

LEFT(text, [num_chars]) extracts:
A) Characters from the start of a string B) End C) Middle D) Word count
Answer: A) Characters from the start of a string

RIGHT(text, [num_chars]) extracts:
A) Characters from the end of a string B) Start C) Specific middle D) Words
Answer: A) Characters from the end of a string

MID(text, start_num, num_chars) extracts:
A) Characters from middle of text B) Start only C) End D) Spaces
Answer: A) Characters from middle of text

LEN(text) returns:
A) Number of characters in text B) Length in inches C) Font size D) Byte size
Answer: A) Number of characters in text

TRIM(text) removes:
A) Extra spaces except single between words B) All spaces C) Numbers D) Text
Answer: A) Extra spaces except single between words

UPPER(text) converts text to:
A) Uppercase B) Lowercase C) Title case D) Numbers
Answer: A) Uppercase

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

PROPER(text) converts text to:
A) First letter uppercase in each word B) All uppercase C) All lowercase D) Random case
Answer: A) First letter uppercase in each word

SUBSTITUTE(text, old_text, new_text) replaces:
A) Specific text in a string B) Numbers C) Formatting D) Formulas
Answer: A) Specific text in a string

REPLACE(text, start_num, num_chars, new_text) is used to:
A) Replace part of text at given position B) Replace full cell C) Add text D) Delete text
Answer: A) Replace part of text at given position

FIND() is case-____ search.
A) Sensitive B) Insensitive C) Neutral D) Random
Answer: A) Sensitive

SEARCH() is case-____ search.
A) Insensitive B) Sensitive C) Exact D) None
Answer: A) Insensitive

CONCATENATE() joins:
A) Two or more text strings B) Numbers C) Files D) Cells physically
Answer: A) Two or more text strings

The TEXTJOIN() function was introduced in Excel:
A) 2016 B) 2013 C) 2010 D) 2007
Answer: A) 2016

FILTER() function returns:
A) Array filtered by a condition B) Random cells C) Empty cells D) Text only
Answer: A) Array filtered by a condition

UNIQUE() function returns:
A) Distinct values from a range B) Sorted list C) Filtered list D) Errors only
Answer: A) Distinct values from a range

SORT() function arranges data:
A) In ascending or descending order B) Randomly C) By color only D) None
Answer: A) In ascending or descending order

The XLOOKUP() function replaces:
A) VLOOKUP() and HLOOKUP() B) SUMIF() C) INDEX() D) MATCH()
Answer: A) VLOOKUP() and HLOOKUP()

XMATCH() returns:
A) Position of a lookup value B) Cell value C) Range name D) Formula
Answer: A) Position of a lookup value

Dynamic Arrays were introduced in:
A) Excel 365 B) Excel 2016 C) Excel 2013 D) Excel 2010
Answer: A) Excel 365

The function SEQUENCE() generates:
A) A list of sequential numbers B) Random numbers C) Dates only D) Text only
Answer: A) A list of sequential numbers

The function RANDARRAY() returns:
A) An array of random numbers B) A sequence C) Sorted array D) Unique array
Answer: A) An array of random numbers

The LET() function allows:
A) Naming intermediate calculations within a formula B) Looping C) Formatting D) Data cleaning
Answer: A) Naming intermediate calculations within a formula

The LAMBDA() function allows users to:
A) Create custom functions B) Record macros C) Use VBA D) Format data
Answer: A) Create custom functions

The SORTBY() function sorts data:
A) Based on values in another range B) Randomly C) By color D) By cell type
Answer: A) Based on values in another range

The function CHOOSE() returns:
A) A value from a list based on index number B) Random item C) Range address D) Formula
Answer: A) A value from a list based on index number

The SWITCH() function is an alternative to:
A) Nested IFs B) SUM C) MATCH D) INDEX
Answer: A) Nested IFs

The IFS() function evaluates:
A) Multiple conditions in order B) Only one condition C) Random cells D) Cell formatting
Answer: A) Multiple conditions in order

The IMAGE() function in Excel 365 allows:
A) Inserting online images into cells B) Drawing C) Printing D) Pasting from Paint
Answer: A) Inserting online images into cells

The HYPERLINK() function creates:
A) Clickable links to files or web pages B) Styles C) Colors D) Filters
Answer: A) Clickable links to files or web pages

To protect a worksheet with a password:
A) Review → Protect Sheet B) View → Freeze C) Data → Validate D) File → Info
Answer: A) Review → Protect Sheet

To protect a workbook structure:
A) Review → Protect Workbook B) File → Save As C) View → Options D) Insert → Tools
Answer: A) Review → Protect Workbook

To allow users to edit certain cells only:
A) Unlock specific cells before protecting sheet B) Hide sheet C) Use VBA D) Use Review → Restrict Edit
Answer: A) Unlock specific cells before protecting sheet

To share a workbook with others:
A) File → Share → Invite People B) Data → Validation C) View → Window D) Insert → Links
Answer: A) File → Share → Invite People

Co-authoring in Excel 365 allows:
A) Multiple users editing the same workbook simultaneously B) Macro editing C) Data hiding D) File conversion
Answer: A) Multiple users editing the same workbook simultaneously

To track workbook changes:
A) Review → Track Changes B) Data → Sort C) File → Info D) View → Review
Answer: A) Review → Track Changes

Excel’s Comments feature was renamed to:
A) Notes B) Chat C) Sticky Notes D) Remarks
Answer: A) Notes

Threaded Comments allow:
A) Conversation-style discussions in cells B) VBA code C) Formulas D) Filters
Answer: A) Conversation-style discussions in cells

To convert an Excel range into a table:
A) Ctrl + T B) Ctrl + A C) Ctrl + Shift + N D) Alt + T
Answer: A) Ctrl + T

A table name can be changed from:
A) Table Design → Table Name box B) Data → Rename C) File → Info D) Review → Protect
Answer: A) Table Design → Table Name box

Structured references are used in:
A) Tables B) Charts C) Formulas only D) Sheets only
Answer: A) Tables

To convert a table back to a normal range:
A) Table Design → Convert to Range B) Data → Unlink C) View → Normal D) File → Convert
Answer: A) Table Design → Convert to Range

The Total Row in a table allows:
A) Auto calculations (Sum, Average, etc.) B) Formatting only C) Sorting D) Validation
Answer: A) Auto calculations (Sum, Average, etc.)

Table styles can be customized under:
A) Table Design tab B) Home tab C) Data tab D) View tab
Answer: A) Table Design tab

Data Validation helps to:
A) Restrict input type and range B) Format cells C) Sort data D) Filter data
Answer: A) Restrict input type and range

To display an input message on cell selection:
A) Data Validation → Input Message tab B) Review → Comments C) View → Message D) Insert → Text Box
Answer: A) Data Validation → Input Message tab

To show a custom error alert in Excel:
A) Data Validation → Error Alert tab B) Review → Protect C) File → Info D) View → Alerts
Answer: A) Data Validation → Error Alert tab

Data validation lists can be made dynamic using:
A) Named Ranges B) VBA C) Hyperlinks D) Filters
Answer: A) Named Ranges

Goal Seek is used to:
A) Find input value that produces desired output B) Forecast data C) Sort data D) Create charts
Answer: A) Find input value that produces desired output

Goal Seek is found under:
A) Data → What-If Analysis B) Review → Tools C) View → Analyze D) Home → Formulas
Answer: A) Data → What-If Analysis

Scenario Manager is used for:
A) Comparing different input scenarios B) Protecting sheets C) Merging cells D) Formatting
Answer: A) Comparing different input scenarios

The Data Table tool can evaluate:
A) Multiple inputs for a formula B) Charts C) Filters D) Tables only
Answer: A) Multiple inputs for a formula

Solver can handle:
A) Optimization problems with constraints B) Formatting C) Graph creation D) Data import
Answer: A) Optimization problems with constraints

Solver must be enabled from:
A) Add-ins (Excel Add-ins → Solver Add-in) B) File → Info C) View → Tools D) Home → Add-ins
Answer: A) Add-ins (Excel Add-ins → Solver Add-in)

The Analysis ToolPak provides:
A) Advanced statistical analysis tools B) Formatting options C) Chart layouts D) Pivot features
Answer: A) Advanced statistical analysis tools

To calculate correlation between two variables:
A) CORREL() B) COUNTIF() C) SUMPRODUCT() D) SLOPE()
Answer: A) CORREL()

The function COVARIANCE.P() returns:
A) Population covariance B) Sample covariance C) Standard deviation D) Mean
Answer: A) Population covariance

The STDEV.P() function calculates:
A) Population standard deviation B) Sample mean C) Variance D) Median
Answer: Population standard deviation