🔹 General Excel Basics
- Q: What is the default file extension of Excel 2016?
A:.xlsx - Q: Which company developed MS Excel?
A: Microsoft - Q: Which key is used to start a new line in a cell?
A:Alt + Enter - Q: What is the default row height in Excel?
A: 15 - Q: What is the maximum number of rows in Excel 2016?
A: 10,48,576 - Q: What is the maximum number of columns in Excel 2016?
A: 16,384 (Column XFD) - Q: What is a cell in Excel?
A: Intersection of a row and column - Q: How many sheets are there by default in Excel 2016?
A: One - Q: What is the name of the horizontal lines in Excel?
A: Rows - Q: What is the name of vertical lines in Excel?
A: Columns
🔹 Excel Formulas & Functions
- Q: Which symbol is used to start a formula in Excel?
A:= - Q: Which function is used to calculate sum?
A:=SUM() - Q: Which function finds the average value?
A:=AVERAGE() - Q: Which function returns the largest value?
A:=MAX() - Q: Which function returns the smallest value?
A:=MIN() - Q: Which function counts numeric values?
A:=COUNT() - Q: Which function counts all non-empty cells?
A:=COUNTA() - Q: What is the function for today’s date?
A:=TODAY() - Q: Which function returns current time?
A:=NOW() - Q: Which function is used to remove extra spaces?
A:=TRIM() - Q: Which function joins text?
A:=CONCATENATE()or=TEXTJOIN() - Q: What is the use of
IFfunction?
A: To test a condition and return value - Q: What is the syntax of IF function?
A:=IF(condition, value_if_true, value_if_false) - Q: Which function finds specific value in range?
A:=VLOOKUP() - Q: What does
ISBLANK()do?
A: Checks if a cell is empty
🔹 Excel Shortcuts
- Q: Shortcut to copy a cell?
A:Ctrl + C - Q: Shortcut to paste?
A:Ctrl + V - Q: Shortcut to cut?
A:Ctrl + X - Q: Shortcut to save workbook?
A:Ctrl + S - Q: Shortcut to open new workbook?
A:Ctrl + N - Q: Shortcut to print workbook?
A:Ctrl + P - Q: Shortcut to undo action?
A:Ctrl + Z - Q: Shortcut to redo action?
A:Ctrl + Y - Q: Shortcut to bold text?
A:Ctrl + B - Q: Shortcut to italicize text?
A:Ctrl + I - Q: Shortcut to underline text?
A:Ctrl + U - Q: Shortcut to insert hyperlink?
A:Ctrl + K - Q: Shortcut to move to next worksheet?
A:Ctrl + Page Down - Q: Shortcut to move to previous worksheet?
A:Ctrl + Page Up - Q: Shortcut to find text in worksheet?
A:Ctrl + F
🔹 Formatting & Editing
- Q: Shortcut to format cells?
A:Ctrl + 1 - Q: Shortcut to insert new row?
A:Ctrl + Shift + + - Q: Shortcut to delete row?
A:Ctrl + - - Q: How to merge cells?
A: Home > Merge & Center - Q: How to wrap text in a cell?
A: Home > Wrap Text - Q: Shortcut to AutoFit column width?
A:Alt + H + O + I - Q: Shortcut to AutoFit row height?
A:Alt + H + O + A - Q: What is conditional formatting?
A: Format cells based on condition - Q: Where is Format Painter found?
A: Home tab - Q: What is used to protect worksheet?
A: Review > Protect Sheet
🔹 Charts & Data Tools
- Q: Which chart is used for trends over time?
A: Line Chart - Q: Which chart is used to compare parts of whole?
A: Pie Chart - Q: Shortcut to insert chart?
A:Alt + F1 - Q: What is a Pivot Table?
A: Tool to summarize large data - Q: Where is Data Validation found?
A: Data tab - Q: What is used to sort data?
A: Sort button under Data tab - Q: What is the use of Filter?
A: Show only specific data - Q: What is Flash Fill?
A: Automatically fills pattern data - Q: Which feature removes duplicates?
A: Data > Remove Duplicates - Q: What is Goal Seek?
A: To find input for desired output
🔹 File & Workbook Management
- Q: What is a workbook?
A: A file that contains worksheets - Q: What is a worksheet?
A: A single sheet in Excel file - Q: Shortcut to switch between open Excel files?
A:Ctrl + Tab - Q: Shortcut to rename worksheet?
A:Alt + H + O + R - Q: How to insert comment in a cell?
A:Shift + F2 - Q: What is cell reference?
A: Address of a cell (e.g., A1) - Q: What is an absolute reference?
A: A reference that doesn’t change ($A$1) - Q: What is relative reference?
A: A reference that changes when copied - Q: What is mixed reference?
A: Combination of absolute and relative - Q: What does
.xlsstand for?
A: Excel Spreadsheet (older version)
🔹 Advanced Excel
- Q: What is the function of
=IFERROR()?
A: Returns value if error occurs - Q: What is
=LEN()used for?
A: Counts characters in a cell - Q: What is
=LEFT(text,n)?
A: Returns first n characters from text - Q: What is
=RIGHT(text,n)?
A: Returns last n characters from text - Q: What does
=MID(text, start, num)do?
A: Extracts text from middle - Q: What is
=ROUND()used for?
A: Rounds a number to desired digits - Q: What is the use of
=TEXT()?
A: Formats numbers/dates as text - Q: What is the use of
=PROPER()?
A: Capitalizes first letter of each word - Q: What is
=LOWER()?
A: Converts text to lowercase - Q: What is
=UPPER()?
A: Converts text to uppercase
🔹 Data Security & Review
- Q: How to protect a workbook with password?
A: File > Info > Protect Workbook - Q: Can you lock specific cells in Excel?
A: Yes, using Format Cells > Protection - Q: How to enable AutoSave in Excel?
A: File > Options > Save > AutoSave - Q: What is Track Changes?
A: Shows edits made by users - Q: Shortcut to check spelling?
A:F7
🔹 Miscellaneous
- Q: What is the default alignment for text in Excel?
A: Left - Q: What is the default alignment for numbers?
A: Right - Q: What is the intersection of row 5 and column C?
A: Cell C5 - Q: What are gridlines?
A: Light lines dividing cells - Q: Can you insert image in Excel?
A: Yes, via Insert > Pictures - Q: What is the use of Name Box?
A: Shows active cell name - Q: What does Formula Bar show?
A: Formula or content of active cell - Q: What is zoom control used for?
A: Enlarge or reduce worksheet view - Q: How to freeze top row?
A: View > Freeze Panes > Freeze Top Row - Q: How to insert drop-down list?
A: Data > Data Validation - Q: What is the use of Comments in Excel?
A: To add notes to cells - Q: Can Excel be used for budgeting?
A: Yes - Q: Can Excel connect to databases?
A: Yes, via Data > Get External Data - Q: What is cell range?
A: Group of selected cells (e.g., A1:B5) - Q: What is AutoSum?
A: Adds numbers quickly usingΣbutton