1. What is Microsoft Excel?
Ans:- Microsoft Excel is a spreadsheet software developed by Microsoft Corporation.
2. What is a cell in Excel?
Ans:- A cell is the intersection point of a row and a column in Excel. It is the smallest unit in a worksheet where data can be entered.
3. How can you add a new worksheet in Excel?
Ans:- To add a new worksheet, click on the “Insert Worksheet” button in the bottom left corner of the Excel window.
4. What is the shortcut key to save an Excel workbook?
Ans:- The shortcut key to save an Excel workbook is Ctrl + S.
5. What is a function in Excel?
Ans:- A function is a predefined formula that performs a specific calculation in Excel.
6. What is the shortcut key to insert a new column in Excel?
Ans:- The shortcut key to insert a new column is Ctrl + Shift + +.
7. What is the shortcut key to insert a new row in Excel?
Ans:- The shortcut key to insert a new row is Ctrl + Shift + =.
8. What is the shortcut key to select an entire column in Excel?
Ans:- The shortcut key to select an entire column is Ctrl + Space.
9. What is the shortcut key to select an entire row in Excel?
Ans:- The shortcut key to select an entire row is Shift + Space.
10. What is the purpose of conditional formatting in Excel?
Ans:- The purpose of conditional formatting is to highlight cells that meet certain criteria, such as values that are above or below a certain threshold.
11. What is the shortcut key to insert the current date in Excel?
Ans:- The shortcut key to insert the current date is Ctrl + ;.
12. What is the shortcut key to insert the current time in Excel?
Ans:- The shortcut key to insert the current time is Ctrl + Shift + ;.
13. What is the purpose of the COUNT function in Excel?
Ans:- The purpose of the COUNT function is to count the number of cells that contain numeric values.
14. What is the purpose of the SUM function in Excel?
Ans:- The purpose of the SUM function is to add a range of numbers in Excel.
15. What is the purpose of the AVERAGE function in Excel?
Ans:- The purpose of the AVERAGE function is to calculate the average of a range of numbers in Excel.
16. What is the purpose of the MAX function in Excel?
Ans:- The purpose of the MAX function is to find the maximum value in a range of numbers in Excel.
17. What is the purpose of the MIN function in Excel?
Ans:- The purpose of the MIN function is to find the minimum value in a range of numbers in Excel.
18. What is the purpose of the IF function in Excel?
Ans:- The purpose of the IF function is to test a condition and return one value if the condition is true, and another value if the condition is false.
19. What is the purpose of the VLOOKUP function in Excel?
Ans:- The purpose of the VLOOKUP function is to search for a specific value in the first column of a table and return a corresponding value from a specified column in the same row.
20. What is the purpose of the HLOOKUP function in Excel?
Ans:- The purpose of the HLOOKUP function is to search for a specific value in the first row of a table and return a corresponding value from a specified row in the same column.
21. What is the purpose of the CONCATENATE function in Excel?
Ans:- The purpose of the CONCATENATE function is to join two or more text strings together in Excel.
22. What is the purpose of the LEFT function in Excel?
Ans:- The purpose of the LEFT function is to extract a specified number of characters from the left side of a text string in Excel.
23. What is the purpose of the RIGHT function in Excel?
Ans:- The purpose of the RIGHT function is to extract a specified number of characters from the right side of a text string in