Q51. Which function is used to count only numeric cells?
A) COUNT() B) COUNTA() C) COUNTIF() D) COUNTBLANK()
Answer: A) COUNT()
Q52. Function used to calculate average value in Excel?
A) SUM() B) AVERAGE() C) COUNT() D) PRODUCT()
Answer: B) AVERAGE()
Q53. Shortcut key to insert a new worksheet?
A) Shift + F11 B) Ctrl + N C) Ctrl + W D) Alt + N
Answer: A) Shift + F11
Q54. Default file extension of Excel 2019?
A) .xls B) .xlsx C) .docx D) .csv
Answer: B) .xlsx
Q55. Function to show current system date & time?
A) TODAY() B) NOW() C) DATE() D) TIME()
Answer: B) NOW()
Q56. Ctrl + ; inserts what in Excel?
A) Current time B) Current date C) Both date and time D) Format cell dialog
Answer: B) Current date
Q57. Function to count blank cells?
A) COUNT() B) COUNTBLANK() C) COUNTA() D) COUNTIF()
Answer: B) COUNTBLANK()
Q58. Best chart to compare trends over time?
A) Pie Chart B) Column Chart C) Line Chart D) Bar Chart
Answer: C) Line Chart
Q59. Function returns smallest number in a range?
A) LARGE() B) SMALL() C) MIN() D) LOW()
Answer: C) MIN()
Q60. Shortcut key to save workbook?
A) Ctrl + S B) Ctrl + W C) Alt + S D) Ctrl + Shift + S
Answer: A) Ctrl + S
Q61. Which chart shows part-to-whole relationships?
A) Line chart B) Bar chart C) Pie chart D) Scatter chart
Answer: C) Pie chart
Q62. Excel formula starts with which symbol?
A) = B) + C) - D) *
Answer: A) =
Q63. What does Ctrl + Shift + L do?
A) Add new row B) Apply filter C) Insert hyperlink D) Open Format Cells
Answer: B) Apply filter
Q64. Which function adds up values?
A) SUM() B) ADD() C) TOTAL() D) PLUS()
Answer: A) SUM()
Q65. What is the cell reference of column D and row 5?
A) D5 B) 5D C) D-5 D) 5-D
Answer: A) D5
Q66. Shortcut key to open Format Cells dialog?
A) Ctrl + 1 B) Ctrl + 2 C) Alt + F1 D) Shift + F1
Answer: A) Ctrl + 1
Q67. Which function returns the maximum value?
A) MAX() B) LARGE() C) BIG() D) TOP()
Answer: A) MAX()
Q68. Shortcut to copy selected data?
A) Ctrl + X B) Ctrl + C C) Ctrl + V D) Ctrl + A
Answer: B) Ctrl + C
Q69. What is used to join text from two cells?
A) CONCATENATE() B) MERGE() C) COMBINE() D) UNION()
Answer: A) CONCATENATE()
Q70. What does IF function do?
A) Adds two cells B) Checks logical condition C) Creates a chart D) Counts cells
Answer: B) Checks logical condition
Q71. Shortcut to paste data?
A) Ctrl + X B) Ctrl + V C) Ctrl + C D) Ctrl + A
Answer: B) Ctrl + V
Q72. How many worksheets are there by default in Excel 2019?
A) 1 B) 2 C) 3 D) 5
Answer: C) 3
Q73. Which function is used to remove spaces from text?
A) CLEAN() B) TRIM() C) REPLACE() D) SUBSTITUTE()
Answer: B) TRIM()
Q74. Function that converts text to upper case?
A) UPPER() B) LOWER() C) PROPER() D) CAPITAL()
Answer: A) UPPER()
Q75. Shortcut to insert current time?
A) Ctrl + : B) Ctrl + Shift + : C) Ctrl + ; D) Alt + T
Answer: B) Ctrl + Shift + :
Q76. The formula =LEN("Excel") returns?
A) 4 B) 5 C) 6 D) Error
Answer: B) 5
Q77. Shortcut to select entire worksheet?
A) Ctrl + A B) Ctrl + Shift + A C) Ctrl + Alt + A D) Shift + A
Answer: A) Ctrl + A
Q78. Shortcut to open Find and Replace box?
A) Ctrl + F B) Ctrl + H C) Ctrl + G D) Ctrl + E
Answer: A) Ctrl + F (Find), Ctrl + H (Replace)
Q79. Function that rounds a number to nearest integer?
A) ROUND() B) INT() C) TRUNC() D) CEILING()
Answer: A) ROUND()
Q80. Shortcut to close workbook?
A) Ctrl + W B) Alt + F4 C) Both A and B D) Ctrl + F4
Answer: C) Both A and B
Q81. What is the intersection of a row and a column called?
A) Table B) Cell C) Chart D) Formula
Answer: B) Cell
Q82. Shortcut to undo last action?
A) Ctrl + Z B) Ctrl + Y C) Ctrl + X D) Ctrl + U
Answer: A) Ctrl + Z
Q83. Shortcut to redo action?
A) Ctrl + Z B) Ctrl + Y C) Ctrl + Shift + Z D) Alt + Y
Answer: B) Ctrl + Y
Q84. Function that returns absolute value?
A) ABS() B) VAL() C) VALUE() D) ROUND()
Answer: A) ABS()
Q85. Which tab contains ‘Sort & Filter’ option?
A) Insert B) Data C) Home D) Review
Answer: B) Data
Q86. Which function gives current date only?
A) NOW() B) DATE() C) TODAY() D) TIME()
Answer: C) TODAY()
Q87. Shortcut to open a new workbook?
A) Ctrl + N B) Ctrl + O C) Ctrl + W D) Ctrl + Shift + N
Answer: A) Ctrl + N
Q88. Shortcut to open existing workbook?
A) Ctrl + O B) Ctrl + N C) Ctrl + S D) Alt + O
Answer: A) Ctrl + O
Q89. Function that converts text to proper case?
A) PROPER() B) UPPER() C) LOWER() D) TITLE()
Answer: A) PROPER()
Q90. Which feature allows automatic completion of data pattern?
A) Flash Fill B) AutoFill C) Smart Fill D) Pattern Fill
Answer: B) AutoFill
Q91. Excel function to calculate remainder?
A) MOD() B) DIV() C) REM() D) QUOT()
Answer: A) MOD()
Q92. The function =2^3 gives result?
A) 6 B) 8 C) 9 D) 5
Answer: B) 8
Q93. Shortcut to move to next worksheet tab?
A) Ctrl + Page Down B) Ctrl + Page Up C) Alt + Tab D) Shift + Tab
Answer: A) Ctrl + Page Down
Q94. Shortcut to move to previous worksheet?
A) Ctrl + Page Up B) Ctrl + Page Down C) Ctrl + Tab D) Ctrl + Shift + Tab
Answer: A) Ctrl + Page Up
Q95. Shortcut to open Go To dialog box?
A) Ctrl + G B) Ctrl + H C) Ctrl + F D) Alt + G
Answer: A) Ctrl + G
Q96. Excel default view is?
A) Normal View B) Page Layout View C) Page Break Preview D) Full Screen View
Answer: A) Normal View
Q97. Function to calculate square root?
A) SQRT() B) POWER() C) ROOT() D) EXP()
Answer: A) SQRT()
Q98. Excel formula =5+2*3 result?
A) 21 B) 11 C) 7 D) 10
Answer: B) 11
Q99. Shortcut to open Save As dialog?
A) F12 B) Ctrl + S C) Alt + S D) Ctrl + Shift + S
Answer: A) F12
Q100. Which Excel feature repeats the last action?
A) Redo B) Repeat C) Reapply D) Reuse
Answer: B) Repeat (F4)
