1.
Which method allows you to split data based on a delimiter, such as a space or a comma?
2.
Which shortcut key is used to insert a new worksheet in Excel?
3.
If you need to remove unwanted columns from a dataset in Excel, what should you do?
4.
What is the shortcut to copy a selection in Excel?
5.
What is the purpose of the IF formula in Excel?
6.
After using Ctrl + C to copy data, which option do you use to paste values only in Excel?
7.
How do you remove formulas and keep the values in Excel?
8.
What formula would you use to replace negative values with zero?
9.
How can you paste values using the ribbon in Excel?
10.
How do you apply Flash Fill to separate city and pin code data in Excel?
