Master your Excel Interviews to Crack a High Paying Job Current Status Not Enrolled Price Closed Get Started This course is currently closed Access the datasheet here 👉 Google Drive Link Course Content 1. Introduction 2. What is the difference between relative & absolute referencing? 3. How do you freeze panes in MS Excel? 4. How to restrict someone from modifying data in a worksheet? 5. What is the order of operations used in MS Excel while evaluating formulas? 6. How will you write the formula for this? 7. What is the difference between count, counta, and countblank? 8. What is the shortcut to add a filter to a data table? 9. How to create a hyperlink in MS Excel? 10. How can we merge multiple text strings in MS Excel? 11. How can you split a column into 2 or more columns? 12. How to create a dropdown list in MS Excel? 13. How to apply advanced filters in MS Excel? 14. Using the below-given sales data, highlight those cells where total sales > $500 15. How to find duplicate values in a column? 16. How to remove duplicate values from a range of cells? 17. What is Data Validation? Illustrate with an example. 18. How to calculate your age in years from the current date? 19. How to get today’s date in MS Excel? 20. How to password protect a MS Excel file? 1 of 3
