Short Q and A on Ms-Excel

Here are 20 questions and answers about Microsoft Excel:

1. Q: What is a cell in Excel?

• A: A cell is the intersection of a row and a column in an Excel worksheet, where data is entered.

1. Q: How do you create a new worksheet in Excel?

• A: You can create a new worksheet by clicking the “+” icon at the bottom of the workbook or by right-clicking on an existing sheet tab and selecting “Insert.”

1. Q: What is the purpose of the AutoSum feature in Excel?

• A: The AutoSum feature quickly adds up a column or row of numbers by automatically inserting a SUM function.

1. Q: How can you merge cells in Excel?

• A: To merge cells, select the cells you want to merge, then click on the “Merge & Center” button in the Home tab.

1. Q: What is a formula in Excel?

• A: A formula is an expression that calculates the value of a cell, starting with an equals sign (=), followed by the operation and cell references.

1. Q: How do you apply a filter to data in Excel?

• A: You can apply a filter by selecting the data range and clicking on the “Filter” button in the Data tab, then using the dropdown arrows to filter specific values.

1. Q: What is conditional formatting in Excel?

• A: Conditional formatting changes the appearance of cells based on specific criteria, such as highlighting cells with values above a certain threshold.

1. Q: How do you create a chart in Excel?

• A: To create a chart, select the data range and click on the “Insert” tab, then choose the desired chart type from the Charts group.

1. Q: What does the VLOOKUP function do?

• A: The VLOOKUP function searches for a value in the first column of a table and returns a value in the same row from a specified column.

1. Q: How can you freeze panes in Excel?
   • A: You can freeze panes by selecting the row or column you want to freeze, then clicking on the “View” tab and selecting “Freeze Panes.”
2. Q: What is a pivot table in Excel?
   • A: A pivot table is a powerful tool that allows you to summarize, analyze, and explore large sets of data by reorganizing and aggregating data.
3. Q: How do you protect a worksheet in Excel?
   • A: To protect a worksheet, go to the “Review” tab and click on “Protect Sheet,” then set the desired protection options and a password.
4. Q: What is the difference between relative and absolute cell references?
   • A: Relative references change when a formula is copied to another cell, while absolute references remain constant, indicated by dollar signs (e.g., $A$1).
5. Q: How do you concatenate text in Excel?
   • A: You can concatenate text using the CONCATENATE function or the “&” operator, for example, =CONCATENATE(A1, ” “, B1) or =A1 & ” ” & B1.
6. Q: What does the IF function do in Excel?
   • A: The IF function performs a logical test and returns one value if the test is true and another value if the test is false.
7. Q: How do you sort data in Excel?
   • A: You can sort data by selecting the range and clicking on the “Sort” button in the Data tab, then choosing the sort criteria.
8. Q: What is a macro in Excel?
   • A: A macro is a recorded sequence of actions that can be executed to automate repetitive tasks.
9. Q: How do you remove duplicates in Excel?
   • A: You can remove duplicates by selecting the data range, clicking on the “Data” tab, and choosing “Remove Duplicates.”
10. Q: What does the COUNTIF function do?
    • A: The COUNTIF function counts the number of cells in a range that meet a specified condition.
11. Q: How do you adjust column width to fit content in Excel?
    • A: To adjust column width to fit content, double-click the boundary to the right of the column header, or use “AutoFit Column Width” in the Home tab under the Format menu.