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