- What is Microsoft Excel?
Microsoft Excel is a spreadsheet software used to store, organize, and analyze data. - What is a workbook?
A workbook is a file in Excel that contains one or more worksheets. - What is a worksheet?
A worksheet is a single page in a workbook where data is stored. - What is a cell?
A cell is the intersection of a row and a column. - What is a cell address?
It is the unique identifier of a cell, such as A1, B2. - What are rows?
Rows are horizontal lines in Excel, numbered 1, 2, 3, etc. - What are columns?
Columns are vertical lines labeled A, B, C, etc. - What is the Ribbon?
The Ribbon is the top menu that contains tabs and commands. - What is the Home tab?
It contains commands for formatting, editing, and basic operations. - What is the formula bar?
It displays and allows editing of cell content. - What is a range?
A group of selected cells is called a range. - How to select a range?
Click and drag across cells. - What is AutoFill?
A feature to automatically fill data in a series. - What is formatting?
Changing the appearance of data like font, color, size. - What is Wrap Text?
It displays text in multiple lines within a cell. - What is Merge Cells?
Combining multiple cells into one. - What is alignment?
Positioning text within a cell. - What is a formula?
A formula is an expression used to calculate values. - What is a function?
A predefined formula in Excel. - What is SUM function?
Adds numbers. Example: =SUM(A1:A5) - What is AVERAGE function?
Calculates average value. - What is COUNT function?
Counts numeric values. - What is COUNTA?
Counts non-empty cells. - What is MIN function?
Finds smallest value. - What is MAX function?
Finds largest value. - What is sorting?
Arranging data in order. - What is filtering?
Displaying selected data based on conditions. - How to save a file?
Press Ctrl + S. - How to open a file?
Use Ctrl + O. - How to create a new workbook?
Ctrl + N. - What is copy and paste?
Copy duplicates data; paste inserts it. - Shortcut for copy?
Ctrl + C. - Shortcut for paste?
Ctrl + V. - Shortcut for cut?
Ctrl + X. - What is undo?
Reverses last action. - Shortcut for undo?
Ctrl + Z. - What is redo?
Repeats last action. - Shortcut for redo?
Ctrl + Y. - What is a chart?
Graphical representation of data. - Types of charts?
Bar, Line, Pie. - What is a header?
Top section of a printed page. - What is a footer?
Bottom section of a printed page. - What is page layout?
Controls printing settings. - What is print preview?
Shows how the sheet will look when printed. - What is cell formatting?
Changing cell appearance. - What is currency format?
Displays values as money. - What is percentage format?
Displays values as percentage. - What is a date format?
Displays date values. - What is a text format?
Stores data as text. - What is number format?
Displays numeric values. - What is gridline?
Lines separating cells. - What is zoom?
Adjusts view size. - What is freeze panes?
Locks rows/columns while scrolling. - What is split?
Divides worksheet view. - What is find?
Search for data. - Shortcut for find?
Ctrl + F. - What is replace?
Replaces data. - Shortcut for replace?
Ctrl + H. - What is data validation?
Restricts data entry. - What is drop-down list?
Predefined selectable values. - What is a comment?
Note added to a cell. - What is hyperlink?
Link to a webpage or file. - What is protection?
Locks cells or sheets. - What is a template?
Pre-designed workbook. - What is conditional formatting?
Formats cells based on rules. - What is duplicate removal?
Deletes repeated data. - What is text to columns?
Splits data into multiple columns. - What is flash fill?
Auto fills based on pattern. - What is auto sum?
Quickly calculates sum. - Shortcut for autosum?
Alt + = - What is cell reference?
Address used in formulas. - Types of references?
Relative, Absolute. - What is relative reference?
Changes when copied. - What is absolute reference?
Does not change (e.g., $A$1). - What is sheet tab?
Switch between sheets. - How to rename sheet?
Double click sheet name. - How to insert sheet?
Click + icon. - How to delete sheet?
Right click > delete. - What is hide/unhide?
Hide or show sheets. - What is column width?
Adjust column size. - What is row height?
Adjust row size. - What is spell check?
Checks spelling errors. - Shortcut for spell check?
F7. - What is status bar?
Shows summary like sum/average. - What is view tab?
Controls display settings. - What is zoom slider?
Adjust zoom quickly. - What is print area?
Selected area for printing. - What is orientation?
Portrait or Landscape. - What is margin?
Space around page. - What is workbook protection?
Protects entire file. - What is sharing?
Allows multiple users. - What is OneDrive?
Cloud storage by Microsoft. - What is Excel shortcut to close file?
Ctrl + W. - What is Excel shortcut to exit?
Alt + F4. - What is Excel used for?
Data management and analysis. - What is Excel extension?
.xlsx
📢 Join Our WhatsApp Channel
💼 Get Daily IT Job Updates, Interview Preparation Tips & Instant Alerts directly on WhatsApp.
👉 Join WhatsApp Now📢 Join Our Telegram Channel
💼 Get Daily IT Job Updates, Interview Tips & Exclusive Alerts directly on Telegram!
👉 Join Telegram