neha.docx

Which function calculates the average of a range of cells, ignoring any text values? **AVERAGE** 2. What is the keyboard shortcut to create a new worksheet in Excel? **Shift + F11** 3. Which feature allows you to visually inspect the relationships between formulas and cells? **Trace Depen...

Which function calculates the average of a range of cells, ignoring any text values? **AVERAGE** 2. What is the keyboard shortcut to create a new worksheet in Excel? **Shift + F11** 3. Which feature allows you to visually inspect the relationships between formulas and cells? **Trace Dependents** 4. In Excel 365, which function can be used to filter data based on a condition and return a specified range? **FILTER** 5. What is the use of the CONCAT function in Excel? **To combine text from multiple cells** 6. Which chart type is best for showing the distribution of data? **Histogram** 7. What is the default file extension for an Excel workbook? **.xlsx** 8. Which Excel function checks if a condition is met and returns one value if true and another value if false? **IF** 9. What is the purpose of the INDEX function in Excel? **To return the value of an element in a table or array** 10. Which function would you use to find the current date in Excel? **TODAY** 11. In Excel 365, which dynamic array function returns a unique list of values from a range? **UNIQUE** 12. Which Excel feature allows you to split the screen into multiple panes? **Split** 13. What is the use of the MATCH function in Excel? **To return the position of a value in a list** 14. Which tool in Excel allows you to summarize large datasets using interactive tables? **PivotTable** 15. What does the VLOOKUP function do in Excel? **Looks up data vertically in a table** 16. In Excel 365, what is the function of the LET function? **To assign names to calculation results** 17. Which of the following options allows you to protect a worksheet from changes? **Protect Sheet** 18. Which Excel function would you use to join several text strings into one text string? **CONCATENATE** 19. What is the purpose of the conditional formatting feature in Excel? **To change the format of cells based on their value** 20. Which Excel feature allows you to apply a predefined style to your data? **Styles**