MS Excel top 100 one liner questions

🔹 General Excel Basics

1. Q: What is the default file extension of Excel 2016?
   A: .xlsx
2. Q: Which company developed MS Excel?
   A: Microsoft
3. Q: Which key is used to start a new line in a cell?
   A: Alt + Enter
4. Q: What is the default row height in Excel?
   A: 15
5. Q: What is the maximum number of rows in Excel 2016?
   A: 10,48,576
6. Q: What is the maximum number of columns in Excel 2016?
   A: 16,384 (Column XFD)
7. Q: What is a cell in Excel?
   A: Intersection of a row and column
8. Q: How many sheets are there by default in Excel 2016?
   A: One
9. Q: What is the name of the horizontal lines in Excel?
   A: Rows
10. Q: What is the name of vertical lines in Excel?
    A: Columns

---

🔹 Excel Formulas & Functions

11. Q: Which symbol is used to start a formula in Excel?
    A: =
12. Q: Which function is used to calculate sum?
    A: =SUM()
13. Q: Which function finds the average value?
    A: =AVERAGE()
14. Q: Which function returns the largest value?
    A: =MAX()
15. Q: Which function returns the smallest value?
    A: =MIN()
16. Q: Which function counts numeric values?
    A: =COUNT()
17. Q: Which function counts all non-empty cells?
    A: =COUNTA()
18. Q: What is the function for today’s date?
    A: =TODAY()
19. Q: Which function returns current time?
    A: =NOW()
20. Q: Which function is used to remove extra spaces?
    A: =TRIM()
21. Q: Which function joins text?
    A: =CONCATENATE() or =TEXTJOIN()
22. Q: What is the use of IF function?
    A: To test a condition and return value
23. Q: What is the syntax of IF function?
    A: =IF(condition, value_if_true, value_if_false)
24. Q: Which function finds specific value in range?
    A: =VLOOKUP()
25. Q: What does ISBLANK() do?
    A: Checks if a cell is empty

---

🔹 Excel Shortcuts

26. Q: Shortcut to copy a cell?
    A: Ctrl + C
27. Q: Shortcut to paste?
    A: Ctrl + V
28. Q: Shortcut to cut?
    A: Ctrl + X
29. Q: Shortcut to save workbook?
    A: Ctrl + S
30. Q: Shortcut to open new workbook?
    A: Ctrl + N
31. Q: Shortcut to print workbook?
    A: Ctrl + P
32. Q: Shortcut to undo action?
    A: Ctrl + Z
33. Q: Shortcut to redo action?
    A: Ctrl + Y
34. Q: Shortcut to bold text?
    A: Ctrl + B
35. Q: Shortcut to italicize text?
    A: Ctrl + I
36. Q: Shortcut to underline text?
    A: Ctrl + U
37. Q: Shortcut to insert hyperlink?
    A: Ctrl + K
38. Q: Shortcut to move to next worksheet?
    A: Ctrl + Page Down
39. Q: Shortcut to move to previous worksheet?
    A: Ctrl + Page Up
40. Q: Shortcut to find text in worksheet?
    A: Ctrl + F

---

🔹 Formatting & Editing

41. Q: Shortcut to format cells?
    A: Ctrl + 1
42. Q: Shortcut to insert new row?
    A: Ctrl + Shift + +
43. Q: Shortcut to delete row?
    A: Ctrl + -
44. Q: How to merge cells?
    A: Home > Merge & Center
45. Q: How to wrap text in a cell?
    A: Home > Wrap Text
46. Q: Shortcut to AutoFit column width?
    A: Alt + H + O + I
47. Q: Shortcut to AutoFit row height?
    A: Alt + H + O + A
48. Q: What is conditional formatting?
    A: Format cells based on condition
49. Q: Where is Format Painter found?
    A: Home tab
50. Q: What is used to protect worksheet?
    A: Review > Protect Sheet

---

🔹 Charts & Data Tools

51. Q: Which chart is used for trends over time?
    A: Line Chart
52. Q: Which chart is used to compare parts of whole?
    A: Pie Chart
53. Q: Shortcut to insert chart?
    A: Alt + F1
54. Q: What is a Pivot Table?
    A: Tool to summarize large data
55. Q: Where is Data Validation found?
    A: Data tab
56. Q: What is used to sort data?
    A: Sort button under Data tab
57. Q: What is the use of Filter?
    A: Show only specific data
58. Q: What is Flash Fill?
    A: Automatically fills pattern data
59. Q: Which feature removes duplicates?
    A: Data > Remove Duplicates
60. Q: What is Goal Seek?
    A: To find input for desired output

---

🔹 File & Workbook Management

61. Q: What is a workbook?
    A: A file that contains worksheets
62. Q: What is a worksheet?
    A: A single sheet in Excel file
63. Q: Shortcut to switch between open Excel files?
    A: Ctrl + Tab
64. Q: Shortcut to rename worksheet?
    A: Alt + H + O + R
65. Q: How to insert comment in a cell?
    A: Shift + F2
66. Q: What is cell reference?
    A: Address of a cell (e.g., A1)
67. Q: What is an absolute reference?
    A: A reference that doesn’t change ($A$1)
68. Q: What is relative reference?
    A: A reference that changes when copied
69. Q: What is mixed reference?
    A: Combination of absolute and relative
70. Q: What does .xls stand for?
    A: Excel Spreadsheet (older version)

---

🔹 Advanced Excel

71. Q: What is the function of =IFERROR()?
    A: Returns value if error occurs
72. Q: What is =LEN() used for?
    A: Counts characters in a cell
73. Q: What is =LEFT(text,n)?
    A: Returns first n characters from text
74. Q: What is =RIGHT(text,n)?
    A: Returns last n characters from text
75. Q: What does =MID(text, start, num) do?
    A: Extracts text from middle
76. Q: What is =ROUND() used for?
    A: Rounds a number to desired digits
77. Q: What is the use of =TEXT()?
    A: Formats numbers/dates as text
78. Q: What is the use of =PROPER()?
    A: Capitalizes first letter of each word
79. Q: What is =LOWER()?
    A: Converts text to lowercase
80. Q: What is =UPPER()?
    A: Converts text to uppercase

---

🔹 Data Security & Review

81. Q: How to protect a workbook with password?
    A: File > Info > Protect Workbook
82. Q: Can you lock specific cells in Excel?
    A: Yes, using Format Cells > Protection
83. Q: How to enable AutoSave in Excel?
    A: File > Options > Save > AutoSave
84. Q: What is Track Changes?
    A: Shows edits made by users
85. Q: Shortcut to check spelling?
    A: F7

---

🔹 Miscellaneous

86. Q: What is the default alignment for text in Excel?
    A: Left
87. Q: What is the default alignment for numbers?
    A: Right
88. Q: What is the intersection of row 5 and column C?
    A: Cell C5
89. Q: What are gridlines?
    A: Light lines dividing cells
90. Q: Can you insert image in Excel?
    A: Yes, via Insert > Pictures
91. Q: What is the use of Name Box?
    A: Shows active cell name
92. Q: What does Formula Bar show?
    A: Formula or content of active cell
93. Q: What is zoom control used for?
    A: Enlarge or reduce worksheet view
94. Q: How to freeze top row?
    A: View > Freeze Panes > Freeze Top Row
95. Q: How to insert drop-down list?
    A: Data > Data Validation
96. Q: What is the use of Comments in Excel?
    A: To add notes to cells
97. Q: Can Excel be used for budgeting?
    A: Yes
98. Q: Can Excel connect to databases?
    A: Yes, via Data > Get External Data
99. Q: What is cell range?
    A: Group of selected cells (e.g., A1:B5)
100. Q: What is AutoSum?
     A: Adds numbers quickly using Σ button