1. What is the default file extension of an Excel workbook in Excel 2016 and later?
A) .xls
B) .xlsx
C) .csv
D) .docx
Answer: B) .xlsx
Explanation: Excel 2007 onward uses the XML-based .xlsx format as the default workbook extension.
2. Which of the following is the default font in Excel 2016?
A) Times New Roman
B) Arial
C) Calibri
D) Verdana
Answer: C) Calibri
Explanation: Calibri, size 11, is the default font in Excel 2016.
3. Which key combination is used to create a new workbook in Excel?
A) Ctrl + N
B) Ctrl + O
C) Ctrl + S
D) Ctrl + P
Answer: A) Ctrl + N
Explanation: Ctrl + N opens a new blank workbook in Excel.
4. What is the intersection of a row and a column in Excel called?
A) Range
B) Cell
C) Column
D) Worksheet
Answer: B) Cell
Explanation: Each cell is uniquely identified by its column letter and row number (e.g., A1).
5. Which function is used to calculate the sum of numbers in Excel?
A) SUM
B) ADD
C) TOTAL
D) COUNT
Answer: A) SUM
Explanation: SUM adds all numbers in the specified range of cells.
6. Which key is used to edit the contents of a selected cell in Excel?
A) F2
B) F4
C) F7
D) F12
Answer: A) F2
Explanation: F2 allows you to edit the active cell directly.
7. Which function is used to calculate the average of a range of numbers in Excel?
A) AVG
B) MEAN
C) AVERAGE
D) SUM
Answer: C) AVERAGE
Explanation: AVERAGE calculates the mean of the numbers in the specified range.
8. Which of the following is used to copy the format of a cell to another cell?
A) Format Painter
B) Copy
C) Paste
D) Fill Handle
Answer: A) Format Painter
Explanation: Format Painter copies formatting such as font, color, and borders from one cell to another.
9. Which of the following is the shortcut key to save a workbook in Excel?
A) Ctrl + S
B) Ctrl + C
C) Ctrl + P
D) Ctrl + V
Answer: A) Ctrl + S
Explanation: Ctrl + S saves the current workbook.
10. Which of the following allows you to fill cells with a series of numbers, dates, or text in Excel?
A) Fill Handle
B) AutoSum
C) Paste
D) Format Painter
Answer: A) Fill Handle
Explanation: The Fill Handle (small square at the bottom-right corner) can be dragged to fill series automatically.
11. Which tab in Excel contains options for inserting charts, tables, and pictures?
A) Home
B) Insert
C) Data
D) Review
Answer: B) Insert
Explanation: The Insert tab provides tools for charts, tables, shapes, images, and other objects.
12. Which function in Excel counts the number of numeric entries in a range?
A) COUNTA
B) COUNT
C) COUNTIF
D) COUNTBLANK
Answer: B) COUNT
Explanation: COUNT counts only numeric entries, while COUNTA counts all non-empty cells.
13. Which key combination is used to select the entire worksheet in Excel?
A) Ctrl + A
B) Ctrl + S
C) Ctrl + C
D) Ctrl + V
Answer: A) Ctrl + A
Explanation: Ctrl + A selects all cells in the worksheet.
14. Which function returns the largest value in a range in Excel?
A) MIN
B) MAX
C) LARGE
D) SUM
Answer: B) MAX
Explanation: MAX returns the highest numeric value in the specified range.
15. Which function returns the smallest value in a range?
A) MAX
B) MIN
C) SMALL
D) AVERAGE
Answer: B) MIN
Explanation: MIN returns the smallest number in the specified range.
16. Which of the following is used to combine text from two or more cells into one in Excel?
A) CONCATENATE / CONCAT
B) MERGE
C) JOIN
D) COMBINE
Answer: A) CONCATENATE / CONCAT
Explanation: CONCATENATE (or CONCAT in newer versions) combines text from multiple cells.
17. Which of the following is the shortcut to insert a new worksheet in Excel?
A) Shift + F11
B) Ctrl + N
C) Alt + F1
D) Ctrl + F4
Answer: A) Shift + F11
Explanation: Shift + F11 inserts a new worksheet into the current workbook.
18. Which of the following is used to remove duplicate entries in Excel?
A) Remove Duplicates
B) Data Validation
C) Conditional Formatting
D) Text to Columns
Answer: A) Remove Duplicates
Explanation: Remove Duplicates (under the Data tab) removes repeated values from selected data.
19. Which feature in Excel allows sorting data in ascending or descending order?
A) Sort & Filter
B) Data Validation
C) Conditional Formatting
D) AutoFill
Answer: A) Sort & Filter
Explanation: Sort & Filter in the Data tab is used to organize data alphabetically or numerically.
20. Which function is used to look up a value in a vertical table in Excel?
A) HLOOKUP
B) VLOOKUP
C) LOOKUP
D) INDEX
Answer: B) VLOOKUP
Explanation: VLOOKUP searches for a value in the first column of a vertical table and returns a corresponding value.
21. Which function is used to return the current date in Excel?
A) TODAY()
B) NOW()
C) DATE()
D) CURRENT()
Answer: A) TODAY()
Explanation: TODAY() returns the current system date without time.
22. Which function is used to return the current date and time?
A) TODAY()
B) NOW()
C) TIME()
D) DATE()
Answer: B) NOW()
Explanation: NOW() returns both the current date and system time.
23. Which of the following is used to protect an Excel workbook with a password?
A) File → Info → Protect Workbook
B) Review → Protect Sheet
C) Data → Protect
D) Home → Format
Answer: A) File → Info → Protect Workbook
Explanation: Protect Workbook allows setting a password to restrict opening or editing.
24. Which feature allows entering the same data into multiple cells simultaneously?
A) Ctrl + Enter
B) Shift + Enter
C) Alt + Enter
D) Enter
Answer: A) Ctrl + Enter
Explanation: Ctrl + Enter fills the selected range with the same data or formula.
25. Which of the following is used to create a chart based on selected data?
A) Insert → Chart
B) Layout → Chart
C) Data → Chart
D) Review → Chart
Answer: A) Insert → Chart
Explanation: The Insert tab provides multiple chart types like Column, Line, Pie, and Bar charts.
26. Which function returns the number of non-empty cells in a range?
A) COUNT
B) COUNTA
C) COUNTBLANK
D) COUNTIF
Answer: B) COUNTA
Explanation: COUNTA counts all non-empty cells, including text, numbers, and errors.
27. Which function counts only blank cells in a range?
A) COUNT
B) COUNTA
C) COUNTBLANK
D) COUNTIF
Answer: C) COUNTBLANK
Explanation: COUNTBLANK counts only the empty cells in the specified range.
28. Which function is used to count cells that meet a specific condition?
A) COUNTIF
B) COUNTA
C) COUNTBLANK
D) COUNT
Answer: A) COUNTIF
Explanation: COUNTIF(range, criteria) counts cells in a range that meet the given condition.
29. Which of the following is used to create a drop-down list in Excel?
A) Data Validation
B) Conditional Formatting
C) Filter
D) Sort
Answer: A) Data Validation
Explanation: Data Validation allows creating lists, setting rules, and restricting input in cells.
30. Which shortcut key is used to open the Format Cells dialog box in Excel?
A) Ctrl + F
B) Ctrl + 1
C) Ctrl + 2
D) Ctrl + 3
Answer: B) Ctrl + 1
Explanation: Ctrl + 1 opens the Format Cells dialog for font, alignment, border, number, and fill options.
31. Which function is used to return a value from a specific row and column in Excel?
A) VLOOKUP
B) HLOOKUP
C) INDEX
D) MATCH
Answer: C) INDEX
Explanation: INDEX(array, row_num, [col_num]) returns the value at a specified row and column in a range.
32. Which function returns the relative position of a value in a range?
A) INDEX
B) MATCH
C) VLOOKUP
D) HLOOKUP
Answer: B) MATCH
Explanation: MATCH(value, range, 0) returns the position of a value in a range.
33. Which function combines INDEX and MATCH to perform flexible lookups?
A) VLOOKUP
B) HLOOKUP
C) INDEX + MATCH
D) LOOKUP
Answer: C) INDEX + MATCH
Explanation: Using INDEX + MATCH allows dynamic lookups both vertically and horizontally.
34. Which function in Excel returns the number of characters in a cell?
A) LEN
B) LEFT
C) RIGHT
D) MID
Answer: A) LEN
Explanation: LEN(text) counts all characters, including spaces, in a cell.
35. Which function extracts a specific number of characters from the beginning of a text string?
A) LEFT
B) RIGHT
C) MID
D) LEN
Answer: A) LEFT
Explanation: LEFT(text, num_chars) returns the first specified number of characters.
36. Which function extracts characters from the end of a text string?
A) LEFT
B) RIGHT
C) MID
D) LEN
Answer: B) RIGHT
Explanation: RIGHT(text, num_chars) returns characters from the end of a text string.
37. Which function extracts characters from the middle of a text string?
A) LEFT
B) RIGHT
C) MID
D) LEN
Answer: C) MID
Explanation: MID(text, start_num, num_chars) returns characters starting from a specified position.
38. Which function converts text to uppercase in Excel?
A) LOWER
B) UPPER
C) PROPER
D) CAPITAL
Answer: B) UPPER
Explanation: UPPER(text) converts all letters to uppercase.
39. Which function converts text to lowercase?
A) LOWER
B) UPPER
C) PROPER
D) CAPITAL
Answer: A) LOWER
Explanation: LOWER(text) converts all letters to lowercase.
40. Which function capitalizes the first letter of each word in a text string?
A) UPPER
B) LOWER
C) PROPER
D) CAPITAL
Answer: C) PROPER
Explanation: PROPER(text) converts the first letter of each word to uppercase.
41. Which Excel function removes extra spaces from text?
A) TRIM
B) CLEAN
C) SUBSTITUTE
D) REPLACE
Answer: A) TRIM
Explanation: TRIM removes leading, trailing, and multiple spaces between words.
42. Which function removes non-printable characters from text?
A) TRIM
B) CLEAN
C) SUBSTITUTE
D) REPLACE
Answer: B) CLEAN
Explanation: CLEAN removes all non-printable characters from text.
43. Which function is used to replace part of a text string with another text?
A) SUBSTITUTE
B) REPLACE
C) REPLACEB
D) MID
Answer: B) REPLACE
Explanation: REPLACE(old_text, start_num, num_chars, new_text) replaces a part of a string with new text.
44. Which function replaces all occurrences of a specific text in a string?
A) SUBSTITUTE
B) REPLACE
C) REPLACEB
D) MID
Answer: A) SUBSTITUTE
Explanation: SUBSTITUTE(text, old_text, new_text) replaces all or specific occurrences of a substring.
45. Which of the following is used to sort data alphabetically or numerically?
A) Sort & Filter
B) Conditional Formatting
C) Data Validation
D) Fill Handle
Answer: A) Sort & Filter
Explanation: Sort & Filter allows arranging data in ascending or descending order.
46. Which function returns the current system time in Excel?
A) TIME()
B) NOW()
C) TODAY()
D) CURRENT()
Answer: B) NOW()
Explanation: NOW() returns both current date and time; TIME() is used to create a time value.
47. Which Excel feature allows filtering data based on specific conditions?
A) AutoFilter
B) Conditional Formatting
C) Data Validation
D) Freeze Panes
Answer: A) AutoFilter
Explanation: AutoFilter enables filtering rows that meet criteria in selected columns.
48. Which of the following is used to freeze rows or columns in Excel?
A) Freeze Panes
B) Split
C) Lock Cells
D) Protect Sheet
Answer: A) Freeze Panes
Explanation: Freeze Panes keeps specific rows/columns visible while scrolling through the worksheet.
49. Which of the following is used to remove duplicates in Excel?
A) Data → Remove Duplicates
B) Home → Clear
C) Insert → Remove
D) Review → Delete
Answer: A) Data → Remove Duplicates
Explanation: Removes repeated values from selected data ranges.
50. Which function in Excel calculates the standard deviation of a set of values?
A) STDEV
B) VAR
C) STDEVP
D) STDDEV
Answer: A) STDEV
Explanation: STDEV estimates standard deviation based on a sample; STDEVP is for the entire population.
51. Which Excel function returns the present value of an investment?
A) PV
B) FV
C) PMT
D) RATE
Answer: A) PV
Explanation: PV(rate, nper, pmt, [fv], [type]) calculates the present value of an investment.
52. Which function calculates the future value of an investment?
A) PV
B) FV
C) PMT
D) RATE
Answer: B) FV
Explanation: FV(rate, nper, pmt, [pv], [type]) returns the future value of an investment.
53. Which function calculates the payment for a loan based on constant interest rate and periods?
A) PV
B) FV
C) PMT
D) RATE
Answer: C) PMT
Explanation: PMT(rate, nper, pv, [fv], [type]) calculates periodic loan payments.
54. Which function is used to calculate the interest rate per period of a loan?
A) PV
B) FV
C) PMT
D) RATE
Answer: D) RATE
Explanation: RATE(nper, pmt, pv, [fv], [type], [guess]) returns the interest rate per period.
55. Which function rounds a number to a specified number of digits?
A) ROUND
B) ROUNDUP
C) ROUNDDOWN
D) MROUND
Answer: A) ROUND
Explanation: ROUND(number, num_digits) rounds a number to the desired precision.
56. Which function always rounds a number up?
A) ROUND
B) ROUNDUP
C) ROUNDDOWN
D) CEILING
Answer: B) ROUNDUP
Explanation: ROUNDUP(number, num_digits) rounds numbers away from zero.
57. Which function always rounds a number down?
A) ROUND
B) ROUNDUP
C) ROUNDDOWN
D) FLOOR
Answer: C) ROUNDDOWN
Explanation: ROUNDDOWN(number, num_digits) rounds numbers toward zero.
58. Which function rounds a number to the nearest multiple?
A) ROUND
B) MROUND
C) CEILING
D) FLOOR
Answer: B) MROUND
Explanation: MROUND(number, multiple) rounds a number to the nearest specified multiple.
59. Which function returns the current week number of a date?
A) WEEKDAY
B) WEEKNUM
C) NOW
D) TODAY
Answer: B) WEEKNUM
Explanation: WEEKNUM(serial_number, [return_type]) returns the week number in the year.
60. Which function returns the day of the week as a number?
A) WEEKDAY
B) WEEKNUM
C) DAY
D) DAYOFWEEK
Answer: A) WEEKDAY
Explanation: WEEKDAY(serial_number, [return_type]) returns a number (1–7) representing the day.
61. Which function returns the current year from a date?
A) YEAR
B) MONTH
C) DAY
D) TODAY
Answer: A) YEAR
Explanation: YEAR(serial_number) extracts the year from a date.
62. Which function returns the month from a date?
A) YEAR
B) MONTH
C) DAY
D) TODAY
Answer: B) MONTH
Explanation: MONTH(serial_number) extracts the month number (1–12).
63. Which function returns the day from a date?
A) YEAR
B) MONTH
C) DAY
D) TODAY
Answer: C) DAY
Explanation: DAY(serial_number) extracts the day from a date.
64. Which Excel function rounds a number up to the nearest integer?
A) ROUND
B) CEILING
C) FLOOR
D) INT
Answer: B) CEILING
Explanation: CEILING(number, significance) rounds a number up to the nearest multiple of significance.
65. Which function rounds a number down to the nearest integer?
A) ROUND
B) CEILING
C) FLOOR
D) INT
Answer: C) FLOOR
Explanation: FLOOR(number, significance) rounds a number down to the nearest multiple of significance.
66. Which function removes the fractional part of a number, returning an integer?
A) ROUND
B) CEILING
C) FLOOR
D) INT
Answer: D) INT
Explanation: INT(number) returns the largest integer less than or equal to the number.
67. Which function returns a random number between 0 and 1?
A) RAND
B) RANDBETWEEN
C) RANDOM
D) RANDOMIZE
Answer: A) RAND
Explanation: RAND() generates a decimal number between 0 and 1.
68. Which function returns a random integer between two specified numbers?
A) RAND
B) RANDBETWEEN
C) RANDOM
D) RANDINT
Answer: B) RANDBETWEEN
Explanation: RANDBETWEEN(bottom, top) generates a random integer within the specified range.
69. Which function returns the largest value in a range?
A) MAX
B) MIN
C) LARGE
D) COUNT
Answer: A) MAX
Explanation: MAX(range) returns the maximum value in the range.
70. Which function returns the smallest value in a range?
A) MAX
B) MIN
C) SMALL
D) COUNT
Answer: B) MIN
Explanation: MIN(range) returns the minimum value in the range.
71. Which function returns the nth largest value in a range?
A) MAX
B) MIN
C) LARGE
D) COUNT
Answer: C) LARGE
Explanation: LARGE(array, n) returns the nth largest value in a range.
72. Which function returns the nth smallest value in a range?
A) MAX
B) MIN
C) SMALL
D) COUNT
Answer: C) SMALL
Explanation: SMALL(array, n) returns the nth smallest value in a range.
73. Which Excel feature highlights cells based on specific conditions?
A) Conditional Formatting
B) Data Validation
C) AutoFilter
D) Format Painter
Answer: A) Conditional Formatting
Explanation: Conditional Formatting allows formatting cells based on criteria, e.g., values above/below a threshold.
74. Which Excel feature allows analyzing data by summarizing it in a pivot table?
A) Pivot Table
B) Sort & Filter
C) Goal Seek
D) Scenario Manager
Answer: A) Pivot Table
Explanation: Pivot Tables summarize large datasets for quick insights.
75. Which feature is used to perform “what-if” analysis for a single variable?
A) Goal Seek
B) Scenario Manager
C) Data Table
D) Solver
Answer: A) Goal Seek
Explanation: Goal Seek adjusts an input value to achieve a desired output for a formula.
76. Which feature allows you to perform “what-if” analysis for multiple variables?
A) Goal Seek
B) Scenario Manager
C) Data Table
D) Solver
Answer: B) Scenario Manager
Explanation: Scenario Manager lets you define and compare multiple input scenarios to see their impact on results.
77. Which Excel feature allows creating tables that automatically expand when new data is added?
A) Pivot Table
B) Data Table
C) Excel Table
D) Named Range
Answer: C) Excel Table
Explanation: Excel Tables (Insert → Table) automatically adjust formulas, formatting, and references when data grows.
78. Which function returns the absolute value of a number?
A) SIGN
B) ABS
C) MOD
D) ROUND
Answer: B) ABS
Explanation: ABS(number) returns the non-negative value of a number.
79. Which function returns the remainder after division of two numbers?
A) MOD
B) QUOTIENT
C) INT
D) DIV
Answer: A) MOD
Explanation: MOD(number, divisor) returns the remainder of number divided by divisor.
80. Which function returns only the integer portion of a division?
A) MOD
B) QUOTIENT
C) INT
D) FLOOR
Answer: B) QUOTIENT
Explanation: QUOTIENT(numerator, denominator) returns the integer part of a division, ignoring remainder.
81. Which function returns the square root of a number in Excel?A) POWER
B) SQRT
C) EXP
D) ROOT
Answer: B) SQRT
Explanation: SQRT(number) returns the square root of a number.
82. Which function raises a number to a specified power?
A) POWER
B) SQRT
C) EXP
D) LOG
Answer: A) POWER
Explanation: POWER(number, power) returns the number raised to the specified exponent.
83. Which Excel function returns the logarithm of a number?
A) LOG
B) LOG10
C) LN
D) All of the above
Answer: D) All of the above
Explanation: LOG(number, base) returns logarithm with any base, LOG10 returns base 10 log, LN returns natural log.
84. Which function returns the integer part of a number toward zero?
A) INT
B) TRUNC
C) FLOOR
D) ROUND
Answer: B) TRUNC
Explanation: TRUNC(number, [num_digits]) truncates the decimal portion without rounding.
85. Which function is used to look up a value in a horizontal table?
A) VLOOKUP
B) HLOOKUP
C) INDEX
D) MATCH
Answer: B) HLOOKUP
Explanation: HLOOKUP searches in the first row of a horizontal range and returns value from specified row.
86. Which Excel feature is used to split text into multiple columns?
A) Text to Columns
B) Flash Fill
C) CONCAT
D) Split Cells
Answer: A) Text to Columns
Explanation: Text to Columns (Data tab) splits data based on delimiter or fixed width.
87. Which function combines multiple text strings into one?
A) CONCATENATE / CONCAT
B) TEXTJOIN
C) & operator
D) All of the above
Answer: D) All of the above
Explanation: CONCATENATE / CONCAT, TEXTJOIN, or & operator can combine text strings in Excel.
88. Which function inserts the current date in a cell that updates automatically?
A) TODAY
B) NOW
C) DATE
D) CURRENT
Answer: A) TODAY
Explanation: TODAY() returns the current system date and updates daily.
89. Which function inserts the current date and time in a cell?
A) TODAY
B) NOW
C) DATE
D) CURRENT
Answer: B) NOW
Explanation: NOW() returns both current date and time, updating whenever the worksheet recalculates.
90. Which function rounds a number to the nearest even integer?
A) EVEN
B) ODD
C) MROUND
D) ROUND
Answer: A) EVEN
Explanation: EVEN(number) rounds a number up to the nearest even integer.
91. Which function rounds a number up to the nearest odd integer?
A) EVEN
B) ODD
C) MROUND
D) ROUND
Answer: B) ODD
Explanation: ODD(number) rounds a number up to the nearest odd integer.
92. Which Excel feature allows automatic data entry based on patterns?
A) AutoFill
B) Flash Fill
C) Data Validation
D) Fill Handle
Answer: B) Flash Fill
Explanation: Flash Fill recognizes patterns in data entry and automatically fills remaining cells.
93. Which Excel feature displays the frequency distribution of data?
A) Pivot Table
B) Histogram
C) Data Table
D) Goal Seek
Answer: B) Histogram
Explanation: Histogram summarizes data by showing frequency distribution in bins.
94. Which option allows grouping and outlining rows or columns in Excel?
A) Group & Outline
B) Freeze Panes
C) Split
D) Filter
Answer: A) Group & Outline
Explanation: Group & Outline (Data tab) allows collapsing/expanding sections of rows or columns.
95. Which function converts a text string into a numeric value?
A) VALUE
B) NUMBERVALUE
C) TEXT
D) Both A & B
Answer: D) Both A & B
Explanation: VALUE(text) and NUMBERVALUE(text) convert text to numbers, depending on format.
96. Which Excel feature allows tracking changes made by multiple users?
A) Track Changes
B) Comments
C) Protect Sheet
D) Review
Answer: A) Track Changes
Explanation: Track Changes highlights edits made by users, useful for collaborative work.
97. Which Excel feature allows creating macros?
A) Developer → Record Macro
B) Insert → Macro
C) Home → Macro
D) Data → Macro
Answer: A) Developer → Record Macro
Explanation: Developer tab allows recording and managing macros to automate tasks.
98. Which feature in Excel allows scenario-based analysis using multiple input variables?
A) Scenario Manager
B) Goal Seek
C) Solver
D) Data Table
Answer: D) Data Table
Explanation: Data Tables allow analyzing the effect of one or two variables on formulas.
99. Which Excel tool finds solutions for optimizing a target cell?
A) Goal Seek
B) Solver
C) Scenario Manager
D) Data Table
Answer: B) Solver
Explanation: Solver adjusts multiple input values to optimize (maximize, minimize, or reach a target) output.
100. Which Excel feature protects a sheet from editing while allowing some cells to remain editable?
A) Protect Sheet
B) Protect Workbook
C) Lock Cells
D) Data Validation
Answer: A) Protect Sheet
Explanation: Protect Sheet restricts editing, and unlocked cells remain editable.