MS-Excel MCQs (101-200)

  1. Which function displays the current system time?
    A) TIME() B) NOW() C) TODAY() D) CLOCK()
    Answer: B) NOW()

  2. Which function is used to extract specific text from the left side of a cell?
    A) LEFT() B) RIGHT() C) MID() D) EXTRACT()
    Answer: A) LEFT()

  3. Which function extracts text from the right side of a string?
    A) LEFT() B) RIGHT() C) MID() D) END()
    Answer: B) RIGHT()

  4. Which function extracts text from the middle of a string?
    A) MID() B) LEFT() C) RIGHT() D) CENTER()
    Answer: A) MID()

  5. Which function replaces part of a text string with another?
    A) SUBSTITUTE() B) REPLACE() C) CHANGE() D) EDIT()
    Answer: B) REPLACE()

  6. Which function replaces old text with new text in a string?
    A) REPLACE() B) SUBSTITUTE() C) TEXTCHANGE() D) SWAP()
    Answer: B) SUBSTITUTE()

  7. Which function returns a value based on multiple conditions?
    A) IF() B) IFS() C) SWITCH() D) CHOOSE()
    Answer: B) IFS()

  8. The SWITCH() function is used for:
    A) Choosing a value based on a list of expressions B) Replacing text C) Converting numbers D) Splitting text
    Answer: A) Choosing a value based on a list of expressions

  9. Which function allows you to select a value from a list of options?
    A) CHOOSE() B) PICK() C) SELECT() D) OPTION()
    Answer: A) CHOOSE()

  10. To add up a range of cells quickly, which tool is used?
    A) AutoSum B) QuickSum C) SmartSum D) FastAdd
    Answer: A) AutoSum

  11. Which function calculates the future value of an investment?
    A) FV() B) PV() C) RATE() D) NPER()
    Answer: A) FV()

  12. Which function calculates the present value of an investment?
    A) PV() B) FV() C) RATE() D) PMT()
    Answer: A) PV()

  13. Which function calculates the interest rate for an investment?
    A) RATE() B) IRR() C) ROI() D) PV()
    Answer: A) RATE()

  14. Which function calculates the number of periods for an investment?
    A) NPER() B) TERM() C) DURATION() D) PERIOD()
    Answer: A) NPER()

  15. Which function calculates periodic loan payment?
    A) PMT() B) IPMT() C) PPMT() D) EMI()
    Answer: A) PMT()

  16. The function that returns the internal rate of return is:
    A) IRR() B) RATE() C) ROI() D) NPV()
    Answer: A) IRR()

  17. The function that returns the net present value is:
    A) NPV() B) PV() C) IRR() D) ROI()
    Answer: A) NPV()

  18. The function that rounds a number down to the nearest integer is:
    A) FLOOR() B) CEILING() C) INT() D) ROUND()
    Answer: A) FLOOR()

  19. The function that rounds a number up to the nearest integer is:
    A) CEILING() B) FLOOR() C) ROUNDUP() D) INT()
    Answer: A) CEILING()

  20. Which function returns the absolute value of a number?
    A) ABS() B) VALUE() C) POS() D) NUM()
    Answer: A) ABS()

  21. Which function gives the column number of a reference?
    A) COLUMN() B) COL() C) COLNUM() D) INDEX()
    Answer: A) COLUMN()

  22. Which function gives the row number of a reference?
    A) ROW() B) ROWNUM() C) INDEX() D) FIND()
    Answer: A) ROW()

  23. Which function returns the cell reference as text?
    A) ADDRESS() B) CELL() C) REF() D) VALUE()
    Answer: A) ADDRESS()

  24. The OFFSET() function returns:
    A) A cell or range offset from a reference B) The difference between two numbers C) A count of rows D) A blank cell
    Answer: A) A cell or range offset from a reference

  25. The INDIRECT() function returns:
    A) A reference specified by text B) A direct reference C) The opposite of ADDRESS() D) A formula result
    Answer: A) A reference specified by text

  26. The RAND() function generates:
    A) A random number between 0 and 1 B) A random integer C) Random text D) Random date
    Answer: A) A random number between 0 and 1

  27. The RANDBETWEEN() function generates:
    A) A random number within a range B) Random text C) Random color D) Random string
    Answer: A) A random number within a range

  28. Which function converts a serial number to a date?
    A) DATE() B) TEXT() C) TODAY() D) VALUE()
    Answer: A) DATE()

  29. Which function converts a date to a serial number?
    A) VALUE() B) DATEVALUE() C) NUM() D) TEXT()
    Answer: B) DATEVALUE()

  30. Which function converts a time to a serial number?
    A) TIMEVALUE() B) TIME() C) VALUE() D) HOUR()
    Answer: A) TIMEVALUE()

  31. Which function extracts the year from a date?
    A) YEAR() B) DATE() C) MONTH() D) DAY()
    Answer: A) YEAR()

  32. Which function extracts the month from a date?
    A) MONTH() B) YEAR() C) DAY() D) WEEKNUM()
    Answer: A) MONTH()

  33. Which function extracts the day from a date?
    A) DAY() B) DATE() C) MONTH() D) WEEKDAY()
    Answer: A) DAY()

  34. Which function returns the week number of a date?
    A) WEEKNUM() B) WEEKDAY() C) DAY() D) MONTH()
    Answer: A) WEEKNUM()

  35. Which function returns the day of the week (1–7)?
    A) WEEKDAY() B) DAY() C) DATE() D) MONTH()
    Answer: A) WEEKDAY()

  36. Which function returns the hour of a time value?
    A) HOUR() B) TIME() C) SECOND() D) MINUTE()
    Answer: A) HOUR()

  37. Which function returns the minute from a time value?
    A) MINUTE() B) SECOND() C) HOUR() D) TIME()
    Answer: A) MINUTE()

  38. Which function returns the seconds from a time value?
    A) SECOND() B) MINUTE() C) HOUR() D) TIME()
    Answer: A) SECOND()

  39. The CONCAT() function is used to:
    A) Combine text strings B) Join numbers C) Split text D) Count text
    Answer: A) Combine text strings

  40. The TEXTJOIN() function:
    A) Joins text with a delimiter B) Splits text C) Converts text to number D) Removes spaces
    Answer: A) Joins text with a delimiter

  41. The FIND() function is used to:
    A) Locate a substring within text B) Sort text C) Replace text D) Merge text
    Answer: A) Locate a substring within text

  42. The SEARCH() function differs from FIND() by:
    A) Being case-insensitive B) Being case-sensitive C) Faster D) Replaces text
    Answer: A) Being case-insensitive

  43. The REPT() function:
    A) Repeats text a given number of times B) Replaces text C) Returns repeated numbers D) Removes duplicates
    Answer: A) Repeats text a given number of times

  44. The SUBSTITUTE function can:
    A) Replace specific occurrences of text B) Replace all text C) Delete text D) Count text
    Answer: A) Replace specific occurrences of text

  45. The LARGE() function returns:
    A) The nth largest value in a range B) The largest only C) Average value D) Count of large numbers
    Answer: A) The nth largest value in a range

  46. The SMALL() function returns:
    A) The nth smallest value B) The smallest only C) Median D) Mode
    Answer: A) The nth smallest value

  47. The MEDIAN() function returns:
    A) The middle value B) The mean C) The mode D) The maximum
    Answer: A) The middle value

  48. The MODE() function returns:
    A) The most frequent value B) The largest C) The average D) The smallest
    Answer: A) The most frequent value

  49. The STDEV() function calculates:
    A) Standard deviation B) Mean C) Median D) Mode
    Answer: A) Standard deviation

  50. The VAR() function calculates:
    A) Variance B) Average C) Range D) Median
    Answer: A) Variance

  1. The CORREL() function calculates:
    A) Correlation coefficient B) Standard deviation C) Mean D) Covariance
    Answer: A) Correlation coefficient

  2. The COVAR() function calculates:
    A) Covariance B) Correlation C) Variance D) Range
    Answer: A) Covariance

  3. The TRANSPOSE() function is used to:
    A) Switch rows to columns and vice versa B) Sort data C) Filter data D) Rotate charts
    Answer: A) Switch rows to columns and vice versa

  4. The UNIQUE() function is used to:
    A) Return distinct values from a range B) Remove duplicates permanently C) Filter blank cells D) Merge ranges
    Answer: A) Return distinct values from a range

  5. The FILTER() function is used to:
    A) Return filtered data based on criteria B) Sort data C) Count rows D) Highlight duplicates
    Answer: A) Return filtered data based on criteria

  6. The SORT() function in Excel:
    A) Sorts a range or array B) Filters unique values C) Counts cells D) Creates pivot tables
    Answer: A) Sorts a range or array

  7. The RANDARRAY() function generates:
    A) A range of random numbers B) A list of text C) Random dates D) Random strings
    Answer: A) A range of random numbers

  8. The SEQUENCE() function generates:
    A) A list of sequential numbers B) Random numbers C) Text patterns D) Formulas
    Answer: A) A list of sequential numbers

  9. Which function combines arrays vertically or horizontally?
    A) VSTACK() and HSTACK() B) APPEND() C) COMBINE() D) JOIN()
    Answer: A) VSTACK() and HSTACK()

  10. The LET() function allows you to:
    A) Assign names to calculation results B) Define functions C) Create macros D) Insert comments
    Answer: A) Assign names to calculation results

  11. The LAMBDA() function allows you to:
    A) Create custom functions B) Calculate lambda values C) Generate charts D) Link data
    Answer: A) Create custom functions

  12. The ISBLANK() function checks:
    A) Whether a cell is empty B) Whether a cell has a formula C) Whether a cell contains text D) Whether a cell is locked
    Answer: A) Whether a cell is empty

  13. The ISTEXT() function returns TRUE if:
    A) The cell contains text B) The cell is blank C) The cell has a number D) The cell is a formula
    Answer: A) The cell contains text

  14. The ISNUMBER() function returns TRUE if:
    A) The cell contains a numeric value B) The cell has text C) The cell is empty D) The cell has a formula
    Answer: A) The cell contains a numeric value

  15. The ISERROR() function checks for:
    A) Any type of error B) Only #VALUE! errors C) Only #REF! errors D) Blank cells
    Answer: A) Any type of error

  16. The IFERROR() function:
    A) Returns a value if formula results in an error B) Highlights errors C) Deletes errors D) Ignores formulas
    Answer: A) Returns a value if formula results in an error

  17. The IFNA() function is similar to IFERROR but handles:
    A) Only #N/A errors B) All errors C) Text formatting D) Blank cells
    Answer: A) Only #N/A errors

  18. The NA() function returns:
    A) The #N/A error B) A blank cell C) 0 D) Null text
    Answer: A) The #N/A error

  19. The INFO() function returns:
    A) Information about the operating environment B) File size C) Sheet name D) System date
    Answer: A) Information about the operating environment

  20. The CELL() function can return:
    A) Information about cell formatting, location, or contents B) Only address C) Only value D) Only formula
    Answer: A) Information about cell formatting, location, or contents

  21. The SHEET() function returns:
    A) The sheet number of a reference B) The sheet name C) The workbook name D) The cell range
    Answer: A) The sheet number of a reference

  22. The SHEETNAME() function (SHEET.NAME in some versions) returns:
    A) The name of the worksheet B) The number of cells C) The workbook path D) The file type
    Answer: A) The name of the worksheet

  23. The HYPERLINK() function:
    A) Creates a clickable link to a document or webpage B) Opens a webpage C) Merges cells D) Adds comments
    Answer: A) Creates a clickable link to a document or webpage

  24. Which shortcut key inserts a hyperlink?
    A) Ctrl + K B) Ctrl + H C) Alt + K D) Ctrl + L
    Answer: A) Ctrl + K

  25. To insert a comment in Excel:
    A) Shift + F2 B) Ctrl + Alt + C C) Alt + F2 D) Ctrl + M
    Answer: A) Shift + F2

  26. To delete a comment:
    A) Right-click → Delete Comment B) Press Delete C) Ctrl + D D) Alt + Delete
    Answer: A) Right-click → Delete Comment

  27. Which function converts numbers to text?
    A) TEXT() B) VALUE() C) STR() D) STRING()
    Answer: A) TEXT()

  28. Which function converts text to numbers?
    A) VALUE() B) NUM() C) NUMBER() D) INT()
    Answer: A) VALUE()

  29. The DATEDIF() function is used to:
    A) Calculate difference between two dates B) Add days C) Convert date formats D) Count days only
    Answer: A) Calculate difference between two dates

  30. The NETWORKDAYS() function:
    A) Calculates working days between two dates B) Counts weekends C) Calculates total days D) Adds holidays
    Answer: A) Calculates working days between two dates

  31. The WORKDAY() function:
    A) Returns a date after a certain number of workdays B) Counts weekdays C) Adds all days D) Finds holidays
    Answer: A) Returns a date after a certain number of workdays

  32. The EOMONTH() function returns:
    A) The last day of the month B) The first day C) The middle day D) The weekday
    Answer: A) The last day of the month

  33. The YEARFRAC() function calculates:
    A) Fraction of the year between two dates B) Full years only C) Months D) Quarters
    Answer: A) Fraction of the year between two dates

  34. The DATEVALUE() function converts:
    A) Text date to serial number B) Serial to text C) Date to text D) Time to serial
    Answer: A) Text date to serial number

  35. The TIMEVALUE() function converts:
    A) Text time to serial number B) Serial to text C) Date to time D) Number to time
    Answer: A) Text time to serial number

  36. The FORMULATEXT() function:
    A) Displays the formula in a referenced cell B) Shows formula results C) Hides formulas D) Locks formulas
    Answer: A) Displays the formula in a referenced cell

  37. The TYPE() function returns:
    A) Type of value in a cell (number, text, etc.) B) Cell format C) Font type D) Formula type
    Answer: A) Type of value in a cell (number, text, etc.)

  38. The GETPIVOTDATA() function:
    A) Extracts data from a PivotTable B) Creates PivotTables C) Filters data D) Adds charts
    Answer: A) Extracts data from a PivotTable

  39. The CUBESET() function:
    A) Defines a set of members from a cube B) Adds values C) Filters Pivot data D) Formats tables
    Answer: A) Defines a set of members from a cube

  40. The INFO(“directory”) argument returns:
    A) Current directory path B) File name C) Cell path D) File size
    Answer: A) Current directory path

  41. The SHEETS() function returns:
    A) Total number of sheets in a workbook B) Names of sheets C) Sheet index D) Sheet paths
    Answer: A) Total number of sheets in a workbook

  42. The ERF() function calculates:
    A) Error function B) Efficiency rate C) Effective rate D) Exponential formula
    Answer: A) Error function

  43. The PI() function returns:
    A) The value of π (3.14159265) B) The value of e C) Product index D) Percentage increase
    Answer: A) The value of π (3.14159265)

  44. The SQRTPI() function calculates:
    A) Square root of (number * π) B) Square root of π only C) π × number D) π²
    Answer: A) Square root of (number * π)

  45. The POWER() function is used to:
    A) Raise a number to a power B) Multiply C) Divide D) Square root
    Answer: A) Raise a number to a power

  46. The PRODUCT() function:
    A) Multiplies all numbers in a range B) Adds numbers C) Finds percentage D) Divides numbers
    Answer: A) Multiplies all numbers in a range

  47. The EXP() function returns:
    A) e raised to a given number B) Logarithm C) Exponent D) Cube root
    Answer: A) e raised to a given number

  48. The LN() function returns:
    A) Natural logarithm of a number B) Log base 10 C) Log base 2 D) Square root
    Answer: A) Natural logarithm of a number

  49. The LOG10() function returns:
    A) Logarithm base 10 B) Natural log C) Log base 2 D) Inverse log
    Answer: A) Logarithm base 10

  50. The LOG() function can:
    A) Return log of any base B) Only base 10 C) Only base e D) Only base 2
    Answer: A) Return log of any base

Leave a Comment

Your email address will not be published. Required fields are marked *

You cannot copy content of this page

Scroll to Top