1. What is MS Excel primarily used for?

MS Excel is primarily used for creating, organizing, and analyzing data in spreadsheets. It enables users to perform calculations, manage data, and create visualizations like charts and graphs.

2. What is the intersection of a row and column called?

The intersection of a row and a column in MS Excel is called a cell, where data is entered. Each cell is identified by a unique cell reference (e.g., A1, B2).

3. What is the shortcut key to create a new workbook?

MS Excel is spreadsheet software used for organizing, analyzing, and visualizing data. It includes features like formulas, functions, charts, PivotTables, and Conditional Formatting, making data management efficient and user-friendly.

4. What does the AutoSum feature do?

The AutoSum feature in MS Excel automatically adds a range of numbers, saving time by inserting the SUM formula for selected cells. Shortcut: Alt + =.

5. What is the default file extension for Excel 2016 and later?

The default file extension for Excel 2016 and later versions is .xlsx, which supports advanced features like formulas, formatting, and charts. Older versions use .xls.

6. What is the shortcut key to select the entire row?

7. How do you wrap text in a cell?

To wrap text in a cell, go to the Home tab and click on Wrap Text in the Alignment group. This adjusts the text to fit within the cell.

8. What does Freeze Panes do?

The Freeze Panes feature locks specific rows or columns, allowing them to remain visible while scrolling through the rest of the worksheet.

9. How do you adjust the width of a column automatically?

To adjust the column width automatically to fit the content, double-click the boundary between column headers. This is called AutoFit Column Width.

10. What is the shortcut to hide a column?

The shortcut Ctrl + 0 is used to hide a column in MS Excel. To unhide, use Ctrl + Shift + 0.

11. What is the correct syntax for the SUM function?

The correct syntax for the SUM function can either be: =SUM(range) (for a single range) =SUM(range1, range2) (for multiple ranges).

12. Which function returns the current date and time?

The =NOW() function returns the current date and time in MS Excel. If you only need the current date, you can use =TODAY().

13. What is the VLOOKUP function used for?

The VLOOKUP function is used to search for a value in the first column of a table and return a value in the same row from a specified column.

14. What does the LEN function do?

The LEN function returns the number of characters in a given text string, including spaces and punctuation.

15. How do you create an absolute cell reference?

An absolute cell reference is created by using the $ symbol, such as $A$1. This ensures that the cell reference does not change when copied to other cells.

16. Which function is used to find the average of a range?

The =AVERAGE() function is used to find the average (mean) of a range of numbers in Excel.

17. What is the IF function used for?

The IF function is used to perform logical comparisons, allowing you to return different values based on whether a condition is true or false (e.g., =IF(A1>10, "Yes", "No")).

18. How do you count blank cells in a range?

The =COUNTBLANK() function is used to count the number of blank (empty) cells in a specified range.

19. Which function extracts a specific number of characters from the right?

The RIGHT() function is used to extract a specific number of characters from the right side of a text string.

20. What is the syntax for the CONCATENATE function?

The CONCATENATE function is used to join multiple text strings together, with the syntax =CONCATENATE(text1, text2, …). In newer versions of Excel, you can also use =CONCAT() as an alternative.